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

Sql µãµÎ

ID int identity(1,1) primary key ×Ô¶¯Ôö³¤,Ö÷¼ü
EXEC sp_rename 'login_info','PDI_login_info'  Ö´Ðд洢¹ý³Ì sp_rename , ½«login_info±íÃû ¸ü¸ÄΪ PDI_login_info
SET   XACT_ABORT  {ON|OFF} Èç¹ûÊÂÎñÖз¢Éú´íÎó£¬on   Ôò»áÖÕÖ¹Õû¸öÊÂÎñµÄÖ´ÐУ¬Èç¹ûOFF£¬¼ÌÐø´íÎóµÄÏÂÃæÒ»¾ä  
SET   ANSI_NULLS {ON|OFF} ÓÃÓÚºÍNULLµÄ±È½Ï£¬È磺null=nullÔÚoffʱ»á·µ»Ø   true,ÔÚon   ʱΪfalse
set QUOTED_IDENTIFIER ON  Ϊ ON ʱ£¬±êʶ·û¿ÉÒÔÓÉË«ÒýºÅ»òÕß[]·Ö¸ô£¬¶øÎÄ×Ö±ØÐëÓɵ¥ÒýºÅ·Ö¸ô,Ϊ OFF ʱ£¬±êʶ·û²»¿É¼ÓÒýºÅ£¬ÇÒ±ØÐë·ûºÏËùÓÐ Transact-SQL ±êʶ·û¹æÔò
SET   NOCOUNT {ON| OFF} µ±SET NOCOUNT Ϊ ON ʱ£¬²»·µ»Ø¼ÆÊý£¨±íʾÊÜ   Transact-SQL   Óï¾äÓ°ÏìµÄÐÐÊý£©¡£µ±   SET   NOCOUNT   Ϊ   OFF   ʱ£¬·µ»Ø¼ÆÊý 


Ïà¹ØÎĵµ£º

Pl/sql µÄ×Ô¶¯ÌáʾºÍÌá½»£¨commit£©

×Ô¶¯ÌáʾµÄ¿ì½Ý¼ü£ºF6
¿ÉÒÔ¸ü¸Ä£ºTools->Preferences->User interface->Key Configuration ,ÔÚItemÁÐÀïÕÒµ½“Tools/Code Assistant”,ÔÚºóÃæ¶ÔÓ¦µÄ¿ì½Ý¸Ä³É×Ô¼ºÏ²»¶µÄ¡£
ĬÈÏÊDz»ÄÜ×Ô¶¯Ìá½»µÄ£¬°´ F10 ¼ü¿ÉÒÔÔÚ×ö¸ü¸ÄºóÌá½»¡£ ......

SQL express °²×°Êֲᣭ°²×°

2¡¢sql express °²×° Èç¹ûÔÚXPÏ£¬Ö±½ÓË«»÷°²×°¾ÍºÃÁË¡£ ÏȰ²×° [ÔÚvistaÏÂÈç¹ûÖ±½ÓË«»÷¿ÉÄÜ»á³öÏÖ °²×°sql server express ³ö´í29506 ] [Vista°²×°µÄʱºò£¬ÐèҪʹÓá°ÒÔ¹ÜÀíÔ±Éí·ÝÔËÐС±°²×°] SQLServer2005_SSMSEE.msi°²×°½áÊø   studioÒѾ­°²×°ÉÏÈ¥£¬µ«ÊÇÄãÓÐûÓз¢ÏÖ£¬°²×°sqlµÄʱºòûÓз¢ÏÖÓÐÓû§saµÄà ......

ÔõÑùÖÆ¶¨×Ô¼ºµÄSQL Server 2000´¥·¢Æ÷

´´½¨Ò»¸ö¼òµ¥µÄ´¥·¢Æ÷
´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì£¬ÀàËÆÓÚʼþº¯Êý£¬SQL Server? ÔÊÐíΪ INSERT¡¢UPDATE¡¢DELETE ´´½¨´¥·¢Æ÷£¬¼´µ±ÔÚ±íÖвåÈë¡¢¸üС¢É¾³ý¼Ç¼ʱ£¬´¥·¢Ò»¸ö»òһϵÁÐ T-SQLÓï¾ä¡£
´¥·¢Æ÷¿ÉÒÔÔÚ²éѯ·ÖÎöÆ÷Àï´´½¨£¬Ò²¿ÉÒÔÔÚ±íÃûÉϵãÓÒ¼ü->“ËùÓÐÈÎÎñ”->“¹ÜÀí´¥·¢Æ÷”À´´´½¨£¬²» ......

ÉèÖÃSQL·¢²¼¶©Ôijö´í

½ñÌìҪͬ²½Ô¶³ÌÊý¾Ý¿âʱ³ö´í£¬±¨´í“ʵ¼ÊµÄ·þÎñÆ÷Ãû³Æ¡£¡£¡£¡£”£¬ÒÔÏÂÊǽâ¾ö·½·¨
SQL code--²é¿´µ±Ç°·þÎñÃû³Æ
select @@servername

--Èç¹ûÓ뵱ǰ¼ÆËã»úÃû²»Ò»Ö£¬ÔòÓÃÒÔÏÂÓï¾äÐÞ¸ÄSQL Server·þÎñÆ÷Ãû
sp_dropserver 'old_name'    --ÏÈɾ³ýÔ­Ãû³Æ
GO
sp_addserver 'new_name', lo ......

SQL³£ÓÃÓï¾ä

1¡¢Óëgroup by´îÅäʹÓõĺ¯Êý
ÔÚÊý¾Ý¿âÖУ¬ÎÒÃÇ¿ÉÒÔʹÓÃGROUP BYº¯Êý°ÑÊý¾Ý×éºÏÔÚÒ»Æð£¬´Ó¶ø»ñµÃ×ܼÆÐÅÏ¢¡£¿ÉÒ԰Ѵ˹¦ÄÜ¿´³ÉÊÇÒ»ÖÖµ±Êý¾Ý´ÓÊý¾Ý¿âÖзµ»ØÊ±°ÑÏàͬÀàÐ͵ÄÐÅÏ¢¼¯Öе½Ò»ÆðµÄÄÜÁ¦¡£ÏÂÃæ¸ø³öÁËÍêÕûÁÐ±í¡£
avg([distinct]column_name)
ÇóËùÓйÍԱнˮµÄƽ¾ùÖµ¡£
select AVG(emp_salary)
from employee;
ÇóÈ¡c ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ