Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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   ʱ£¬·µ»Ø¼ÆÊý 


Ïà¹ØÎĵµ£º

SQLÓï¾ä£º°Ñͳ¼Æ½á¹û°´ÕÕÌØ¶¨µÄÁÐֵת»»³É¶àÁÐ

ÒªÇ󣺲éѯÿ¸öÀÏʦËù´ø±ÏÒµÉè¼ÆµÄ»ã×ÜÇé¿ö£¬±ÏÒµÉè¼ÆÑ§Éú·Ö±¾¿Æ¡¢×¨¿Æ£¬ÔºÍâ¡¢ÔºÄÚ£¬ÒªÇóµÃµ½µÄ½á¹ûÐÎʽÈçÏ£º
½ÌʦÃû ÔºÄÚ±¾¿Æ Ô°ÄÚר¿Æ ÔºÍâ±¾¿Æ ÔºÍâר¿Æ ºÏ¼Æ
Ïà¹ØµÄ±íÓУºÑ§Éú±í£¨°üº¬Ñ§Éú²ã´Î£©¡¢½Ìʦ±í£¨½ÌʦÃû£©¡¢Ñ§Éú¿ÎÌâ±í£¨Ñ§Éú½Ìʦ¶ÔÓ¦¹ØÏµÒÔ¼°ÔºÄÚÔºÍâÐÅÏ¢£©¡£
SQLÓï¾äÈçÏ£º
select
    ......

sql²éѯ

1¡¢²éѯÈýÃŹ¦¿Î¶¼ÔÚ80·ÖÒÔÉϵÄͬѧÐÕÃû(Ò»ÌõsqlÓï¾ä)
   name   kecheng    fenshu
   ÕÅÈý   ÓïÎÄ        78
   ÕÅÈý   Êýѧ        81
   ÕÅÈý  ......

SQL express °²×°ÊֲᣭÏÂÔØ

1¡¢ÏÂÔØ£ºÐèÒªÏÂÔØ2¸öÎļþ¡£ 1) sql server express studioÏÂÔØµØÖ·£º Microsoft SQL Server Management Studio Express http://www.microsoft.com/downloads/details.aspx?FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=zh-cn ÔÙÏÂÔØ£º 2£©Microsoft SQL Server 2005 Express Edition http:// ......

OracleÖÐÓÃÒ»¾äSQLÓï¾äʵÏÖÐÐÁÐת»»

SQL*PLus>   desc   emp;  
    Ãû³Æ                                                                   &nbs ......

SQL express °²×°ÊÖ²á £­ ÉèÖÃ

°²×°Íê±ÏÖ®ºó£¬»¹ÐèÒªÉèÖÃһϲÅÄÜʹsql·þÎñÁ´½Ó³É¹¦¡£ Ñ¡ÔñµÚÒ»¸ö£º·þÎñºÍÁ´½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷ µã»÷¡°Ô¶³ÌÁ´½Ó¡±£¬ÔÙÑ¡Ôñ±¾µØÁ´½ÓºÍÔ¶³ÌÁ´½Ó¡£Ñ¡ÔñµÚ3¸öÑ¡Ïî¡£ ºÃÁË¡£ÎÒÃÇ¿ÉÒÔµ½¿ªstudioÁË¡£ ¼ÇµÃÔÚ·þÎñÆ÷Ãû³ÆÊäÈ룺localhost\SQLEXPRESS
µÇ¼Ãûsa¡£ÃÜÂë¾ÍÊǰ²×°µÄʱºòÊäÈëµÄÃÜÂë¡£ ok¡£¡£¡£ºÃÁË¡£¡£¡£¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ