SQL¸ù¾ÝÒÑÖªµÄÄêÔÂ,¼ÆËã¸ÃÔµÄÌìÊý.
±¾ÎÄÊÇÒ»¸ö¼¼ÇÉÎÄÕÂ,½éÉÜSQL¸ù¾ÝÒÑÖªµÄÄêÔÂ,¼ÆËã¸ÃÔµÄÌìÊý.
±¾ÎÄÊÇÒ»¸ö¼¼ÇÉÎÄÕÂ,½éÉÜSQL¸ù¾ÝÒÑÖªµÄÄêÔÂ,¼ÆËã¸ÃÔµÄÌìÊý.
declare @iDays int
declare @dt varchar(50)
set @dt=@Year+'-'+@Month+'-01'
select @iDays=day(dateadd(d,-Day(dateadd(m,1,convert(datetime,@dt))),dateadd(m,1,convert(datetime,@dt))))
print @idays
Ïà¹ØÎĵµ£º
NO ACTION
Ö¸¶¨Èç¹ûÊÔͼɾ³ý/ÐÞ¸ÄijһÐУ¬¶ø¸ÃÐеļü±»ÆäËû±íµÄÏÖÓÐÐÐÖеÄÍâ¼üËùÒýÓã¬Ôò²úÉú´íÎ󲢻عö DELETE/UPDATEÓï¾ä¡£
CASCADE¡¢SET NULL ºÍ SET DEFAULT
ÔÊÐíͨ¹ýɾ³ý»ò¸üмüÖµÀ´Ó°ÏìÖ¸¶¨¾ßÓÐÍâ¼ü¹ØϵµÄ±í£¬ÕâЩÍâ¼ü¹Øϵ¿É×·Ëݵ½ÔÚÆäÖнøÐÐÐÞ¸ÄµÄ±í¡£Èç¹ûΪĿ±ê±íÒ²¶¨ÒåÁ˼¶ÁªÒýÓòÙ×÷£¬ÄÇôָ¶¨µÄ¼¶Áª²Ù ......
½ñÌìÐÇÆÚÌì,ÒòÊý¾Ý¿âÌ«Âý,×îºó¾ö¶¨½«Êý¾Ý¿â½øÐÐÖØÐÂÕûÀí.
(¼Ù¶¨Êý¾Ý¿âÃû³ÆΪ£ºDB_ste)
1¡¢¸ù¾ÝÏÖÔÚµÄÊý¾Ý¿âµÄ½Å±¾´´½¨Ò»¸ö½Å±¾Îļþ£¨FILENAME£ºDB_ste.sql)
2¡¢½¨Á¢ÐµÄÊý¾Ý¿âDB_ste2,ÈôÓÐÎļþ×éµÄÊý¾Ý¿â,ÔòÐèÒª½¨Á¢ÏàͬµÄÎļþ×é¡££¨DB_ste_Group)
3¡¢½«Êý¾ÝÎÄ ......
MS Sql Server ÌṩÁ˺ܶàÊý¾Ý¿âÐÞ¸´µÄÃüÁµ±Êý¾Ý¿âÖÊÒÉ»òÊÇÓеÄÎÞ·¨Íê³É¶Áȡʱ¿ÉÒÔ³¢ÊÔÕâЩÐÞ¸´ÃüÁî¡£
¡¡¡¡1. DBCC CHECKDB
¡¡¡¡ÖØÆô·þÎñÆ÷ºó£¬ÔÚûÓнøÐÐÈκβÙ×÷µÄÇé¿öÏ£¬ÔÚSQL²éѯ·ÖÎöÆ÷ÖÐÖ´ÐÐÒÔÏÂSQL½øÐÐÊý¾Ý¿âµÄÐÞ¸´£¬ÐÞ¸´Êý¾Ý¿â´æÔÚµÄÒ»ÖÂÐÔ´íÎóÓë·ÖÅä´íÎó¡£
use master
declare @databasename varch ......
Microsoft SQL Server ±í²»Ó¦¸Ã°üº¬Öظ´ÐкͷÇΨһÖ÷¼ü¡£Îª¼ò½àÆð¼û£¬ÔÚ±¾ÎÄÖÐÎÒÃÇÓÐʱ³ÆÖ÷¼üΪ“¼ü”»ò“PK”£¬µ«ÕâʼÖÕ±íʾ“Ö÷¼ü”¡£Öظ´µÄ PK Î¥·´ÁËʵÌåÍêÕûÐÔ£¬ÔÚ¹ØϵϵͳÖÐÊDz»ÔÊÐíµÄ¡£SQL Server Óи÷ÖÖÇ¿ÖÆÖ´ÐÐʵÌåÍêÕûÐԵĻúÖÆ£¬°üÀ¨Ë÷Òý¡¢Î¨Ò»Ô¼Êø¡¢Ö÷¼üÔ¼Êøº ......
×÷Õß Haidong Ji ·Òë GoodKid
ÔÚÎҵĹØÓÚOracleºÍSQL Server »¥ÓÃÐÔµÄϵÁÐÎÄÕ part 1 ºÍ part 2 µ±ÖУ¬ÎÒÌÖÂÛÁËOracleºÍSQL Server µÄһЩ²»Í¬µãµÄ»°ÌâÒÔ¼°OracleÇý¶¯µÄ¿ÉÑ¡ÐÔ¡£ÔÚ±¾Ö÷ÌâÖУ¬ÎÒ½«ÌÖÂÛÒ»¸öÀ´×ÔOracle 10gµÄй¤¾ß£¬Oracle¼´Ê±¿Í»§¶Ë¡£
¶ÔÓÚOracle 10gÒÔÇ°µÄ°æ±¾£¬Èç¹ûÏ뽨Á¢ºÍOracleµÄÁ¬½Ó£¬ ......