Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

°²×°SQL Server 2005ÐÔÄܼàÊÓÆ÷¼ÆÊýÆ÷ÒªÇó (´íÎó)

ÊÖ¶¯ÉèÖüÆÊýÆ÷×¢²á±íÏîµÄÔöÁ¿ :
     1.ÔÚ Microsoft Windows 2003 »ò Windows XP ×ÀÃæÉÏ£¬ÒÀ´Îµ¥»÷“¿ªÊ¼”¡¢“ÔËÐД£¬È»ºóÔÚ“´ò¿ª”ÖмüÈë regedit.exe£¬ÔÙµ¥»÷“È·¶¨”¡£ÔÚ Windows 2000 ÖУ¬Ê¹Óà regedt32.exe Æô¶¯×¢²á±í±à¼­Æ÷¡£
     2.¶¨Î»µ½ÒÔÏÂ×¢²á±íÏ
     [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib]
     "Last Counter"=dword:00000ed4 (5276)
     "LastHelp"=dword:00000ed5 (5277)
     3.ÉÏÒ»²½µÄ“Last Counter”Öµ (5276) ±ØÐëÓëÒÔÏÂ×¢²á±íÏîÖГPerflib\004”µÄ“Counter”ÏîµÄ×î´óֵƥÅ䣬²¢ÇÒÉÏÒ»²½µÄ“Last Help”Öµ (5277) ±ØÐëÓëÒÔÏÂ×¢²á±íÏîÖГPerflib\004”µÄ“Help”ÏîµÄ×î´óֵƥÅä¡£
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\009]
×¢Òâ 009Öд洢µÄÊÇÓ¢Îİ汾µÄ¼ÆÊýÆ÷(Èç¹ûÄã°²×°µÄÊÇÓ¢ÎİæMicrosoft SQL Server2005ÔòÐÞ¸ÄPerflib\009)£¬004Öд洢µÄÊÇÖÐÎİ汾µÄ¼ÆÊýÆ÷(Èç¹ûÄã°²×°µÄÊÇÖÐÎİæMicrosoft SQL Server2005ÔòÐÞ¸ÄPerflib\004)¡£“Last Counter”ºÍ“Last Help”ÖµÊÇÓÉ Windows ¶¯Ì¬·ÖÅäµÄ£»ÕâÁ½¸öÖµ»áÒò¼ÆËã»úµÄ²»Í¬¶ø²»Í¬¡£


Ïà¹ØÎĵµ£º

MySQL Ñϸñģʽ sql_mode

ËäȻ˵ÎÒÃǾ¡Á¿ÔÚд³ÌÐòµÄʱºò¿ØÖƲåÈëµ½Êý¾Ý¿âµÄÊý¾Ý£¬¶ø²»ÒªÓÃÊý¾Ý¿âÈ¥ÅжÏÊý¾ÝµÄ¶Ô´í£¬µ«ÊÇÓÐʱºòΪÁË·½±ã»¹ÊÇÐèÒªÊý¾Ý¿â×ÔÉíµÄÈÝ´íÄÜÁ¦À´°ïÖúÎÒÃǴﵽĿµÄµÄ¡£¾ÙÀý˵Ã÷£º
´´½¨ÈçÏÂÊý¾Ý±í
CREATE TABLE `book` (
  `id` int(11) default NULL,
  `num` int(11) unsigned default NULL
) ENGINE=InnoDB DE ......

sql陽曆轉陰曆

USE [rossic]
GO
/****** Object:  StoredProcedure [dbo].[fn_GetLunar]    Script Date: 02/23/2010 15:46:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
     
CREATE     proc   [dbo].[fn_GetLunar]   ......

SQLº¯ÊýÖ®ÈÕÆÚºÍʱ¼äº¯Êý

MySQLÖÐÎIJο¼ÊÖ²á- 7 MySQL ÓïÑԲο¼
<!--
body { font-size: 9pt; }
a:hover{color:red;}
a.t1:visited{color:red;}
-->
¶ÔÓÚÿ¸öÀàÐÍÓµÓеÄÖµ·¶Î§ÒÔ¼°²¢ÇÒÖ¸¶¨ÈÕÆÚºÎʱ¼äÖµµÄÓÐЧ¸ñʽµÄÃèÊö¼û7.3.6 ÈÕÆÚºÍʱ¼äÀàÐÍ
¡£
ÕâÀïÊÇÒ»¸öʹÓÃÈÕÆÚº¯ÊýµÄÀý×Ó¡£ÏÂÃæµÄ²éѯѡÔñÁËËùÓмǼ£¬Æädate_col
µÄÖµÊÇÔÚ×îº ......

¹ØÓÚSQL SERVER Êý¾Ý²ð·Ö

if object_id('tb') is not null drop table tb
go
create table tb([A] varchar(10),[B] int)
insert tb
select 'bcd',1 union all
select 'bcde',2 union all
select 'cd',3
go
¸öÈË·ÖÎöÕâµÀÌâµÄ˼·ÊÇ£º
ͨ¹ýSubstring() À´Ñ­»··Ö¸î B ÁÐϵÄ×Ö·û´®¡£¡£
--ÏëµÃµ½µÄ½á¹û£º
/**
a    b& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ