SQLServer ×î³£ÓõÄË÷Òý×Ö¶Î(ͨÓÃË÷Òý×Ö¶Î)
Ò»¡¢SQLServer ͨÓÃË÷Òý×Ö¶Î
1¡¢Primary Key's Ö÷¼ü
2¡¢Foreign Key's Íâ¼ü
3¡¢Ö§³ÖSELECT¡¢INSERT¡¢UPDATEºÍDELETEÃüÁîµÄ×Ö¶Î :
(1)¡¢INNER JOIN
(£²)¡¢RIGHT | LEFT OUTER JOIN
(£³)¡¢WHERE
(£´)¡¢ORDER BY
(£µ)¡¢GROUP BY
(£¶)¡¢HAVING
¶þ¡¢´´½¨Ë÷ÒýµÄÆäËûÒòËØ(Ö÷ÒªÒòËØ¶¼ÒòΪË÷ÒýÊÇÊý¾Ý±íÍⲿ¶ÀÁ¢µÄ×éÖ¯,µ±±íÖеÄÊý¾Ý·¢Éú±ä»¯Ê±,Ë÷ÒýÒ²ÐèҪͬ²½Î¬»¤,Õ⽫ӰÏìÊý¾Ý±íµÄ¸üвÙ×÷µÄЧÂÊ):
1¡¢Êý¾ÝÁ¿——Èç¹û¼Ç¼ÐÐÊýºÜÉÙ,²»±Ø½¨Á¢Ë÷Òý¾ÍÄÜ¿ìËÙ·ÃÎÊ
2¡¢Êý¾Ý±ä¶¯ÆµÂÊ——Èç¹û±íÖеÄÊý¾Ý±ä¶¯Æµ·±(INSERT¡¢UPDATEºÍDELETE²Ù×÷)ÿ´Î±ä¶¯,Ë÷Òý¶¼ÒªÔö¼Óά»¤µÄ¿ªÏú,ÎÒÃǽ¨Á¢Ë÷ÒýÓ¦¸Ã¿¼Âǵ½Êý¾Ý±ä¶¯µÄÇ÷ÊÆ,ÀýÈç:bbsÖеķ¢Ìû,ÕâÕűíµÄÐÂÊý¾ÝÊǰ´ÕÕ´´½¨Ê±¼äÅÅÁеÄ,ËùÒÔ°´ÕÕ´´½¨Ê±¼ä½¨Á¢µÄË÷Òý,ÔÚÌí¼ÓÐÂÊý¾Ýʱ,ά»¤Ë÷ÒýµÄ¿ªÏúÊÇ×îµÍµÄ
3¡¢¾¡Á¿´´½¨ÊÝË÷Òý——Èç¹ûÄã²»ÄÜÈ·¶¨Ë÷ÒýÊýÁ¿,ÄÇô¾Íÿ¸öË÷ÒýÓÃÒ»¸ö×ֶξͺÃÁË,³ý·ÇƵ·±µÄ¶Ôijһ×é×ֶνøÐвéѯ,·ñÔòûÓбØÒª½¨Á¢ÅÖË÷Òý
Ïà¹ØÎĵµ£º
ÔÚsqlserver(Ó¦¸Ã˵ÔÚĿǰËùÓÐÊý¾Ý¿â²úÆ·)Öд´½¨Ò»¸ö×ÊÔ´Èç±í£¬ÊÓͼ£¬´æ´¢¹ý³ÌÖж¼ÒªÅжÏÓë´´½¨µÄ×ÊÔ´ÊÇ·ñÒѾ´æÔÚ
ÔÚsqlserverÖÐÒ»°ã¿Éͨ¹ý²éѯsys.objectsϵͳ±íÀ´µÃÖª½á¹û£¬²»¹ý¿ÉÒÔÓиü·½±ãµÄ·½·¨
ÈçÏ£º
if object_id('tb_table') is not null
......
sp_databases --Áгö·þÎñÆ÷ÉϵÄËùÓÐÊý¾Ý¿â
sp_server_info --Áгö·þÎñÆ÷ÐÅÏ¢£¬Èç×Ö·û¼¯£¬°æ±¾ºÍÅÅÁÐ˳Ðò
sp_stored_procedures--Áгöµ±Ç°»·¾³ÖеÄËùÓд洢¹ý³Ì
sp_tables --Áгöµ±Ç°»·¾³ÖÐËùÓпÉÒÔ²éѯµÄ¶ÔÏó
sp_start_job --Á¢¼´Æô¶¯×Ô¶¯»¯ÈÎÎñ
sp_stop_job --Í£Ö¹ÕýÔÚÖ´ÐеÄ×Ô¶¯»¯ÈÎÎñ
sp_password --Ìí¼Ó»òÐ ......
ÔÚÓÃAsp.net¶Ô±¸·ÝµÄÊý¾Ý¿âÎļþ½øÐл¹ÔµÄʱºò£¬ÓÐʱºò»á³öÏÖÏÂÃæµÄ´íÎóÒì³££º
[ÒòΪÊý¾Ý¿âÕýÔÚʹÓã¬ËùÒÔδÄÜ»ñµÃ¶ÔÊý¾Ý¿âµÄÅÅËü·ÃÎÊȨ¡£ RESTORE DATABASE ²Ù×÷Òì³£ÖÕÖ¹¡£Òѽ«Êý¾Ý¿âÉÏÏÂÎĸÄΪ 'master'¡£]
Õâ¸öʱºò£¬×ÔÓɵȴýÆäËû½ø³ÌÊͷŶÔӦȨÏ޺󣬲ſɻ¹Ô³É¹¦£¡ÓÐûÓнâ¾ö°ì·¨ÄØ£¿ÎÒ²ÎÕÕ¡¾Java¡¿¶ÔÕâ¸öÎÊÌâµÄ½â¾ö ......
ÁÙ½üÄêÖÕ£¬ÔÚ¹¤×÷Ö®Óà¶Ô¹¤×÷ºÍѧϰÖÐÓöµ½µÄÎÊÌâÒÔ¼°³£ÓõÄһЩ֪ʶµã×öÁËЩÕûÀí£¬ÒÔ±¸ºóÓᣱ¾ÎÄÉæ¼°µÄÄÚÈÝΪÊý¾Ý¿â,ËãÊǶԿª·¢×ܽá(1)---Êý¾Ý¿âÒ»ÎĵIJ¹³ä¡£
1 ¶ÔÓÚÖ÷¼üÉèÖÃÁËIdentityµÄ±í£¬ÔÚɾ³ý±íÖÐÊý¾ÝºóÔÙÍù±íÖвåÈëÊý¾Ý£¬IdentityÁв»ÊÇ´Ó1ÆðʼÁË£¬Èç¹ûÏëɾ³ýÊý¾ÝºóIndentityÁÐÈÔ´Ó1Æðʼ£¬¿ÉÒÔÓÃÏÂÃæ´úÂëÀ´É¾³ýÊý¾Ý ......
--ÿ¸öÔµĵÚÒ»Ìì
select dateadd(dd,-datepart(dd,getdate())+1,getdate())
--µÚ¸öÔµÄ×îºóÒ»Ìì
select dateadd(dd,-datepart(dd,getdate()),dateadd(mm,1,getdate()))
--±¾ÔµÄÌìÊý
select datediff(dd,getdate(),dateadd(mm,1,getdate()))
......