ÓÃSQLÓï¾äÐÞ¸ÄSQL±í½á¹¹
×î½üÐÞ¸ÄÊý¾Ý¿âÒѾ´æÔڵıí½á¹¹£¬·¢ÏÖÓÃSQLÓï¾äÄܺܺõÄÐ޸ıíµÄ½á¹¹¡£SQLÊý¾Ý¿â¼Ç¼Êý·Ç³£ÅÓ´ó£¬Èç¹ûÏëÐ޸ıíµÄ×Ö¶ÎÀàÐÍ£¬Ê¹ÓÃÆóÒµ¹ÜÀíÆ÷À´¸ü¸Ä×Ö¶ÎÀàÐÍ£¬ºÜ¶àʱºò»á³¬Ê±£¬¸ü¸Ä²»³É¹¦£¬Õâ¸öʱºò£¬¿ÉÒÔÓÃSQLÓï¾äÀ´¸ü¸Ä£¬ÒÔÏÂΪÏàÓ¦µÄ´úÂëʵÀý£º
1.¸ü¸Ä×Ö¶ÎÀàÐͳ¤¶È
alert table ±í alert column ×Ö¶ÎÃû ÀàÐ͵ij¤¶È
eg: alter table users alter column IDcard char(20)
2.¸ü¸Ä×Ö¶ÎÀàÐÍ
alert table ±í alert column ×Ö¶ÎÃû ¸ü¸ÄºóµÄÀàÐÍ
eg:°Ñ³ÇÊбíµÄ³ÇÊÐÃû×Ö¶ÎÓÉÔÀ´µÄvarchar¸Ä³Éint
alert table testcity alter column cityname int
3.Ìí¼Ónot nullÔ¼Êø
alert table ±íalert column ×Ö¶ÎÃû int not null
4.ÉèÖÃÖ÷¼ü
alert table ±í add constraint Ö÷¼üÃû primary key(×Ö¶ÎÃû)
5.¸ü¸Ä×Ö¶ÎÃû
EXEC sp_name '±íÃû.×Ö¶ÎÃû‘£¬¸ü¸ÄºóµÄ×Ö¶ÎÃû£¬’COLUMN‘
6.Ìí¼Ó×Ö¶ÎÃû
alert table ±í add ×Ö¶ÎÃû ×Ö¶ÎÀàÐÍ default null
Ïà¹ØÎĵµ£º
Sql´úÂë:Powered by chenjiazi
--²éѯµ±Ì죺
select * from info where DateDiff(dd,datetime,getdate())=0
--²éѯ24СʱÄÚµÄ:
select * from info where DateDiff(hh,datetime,getDate())<=24
--infoΪ±íÃû,datetimeΪÊý ......
ÈçºÎÈÃÄãµÄSQLÔËÐеøü¿ì(תÌù)
---- ÈËÃÇÔÚʹÓÃSQLʱÍùÍù»áÏÝÈëÒ»¸öÎóÇø£¬¼´Ì«¹Ø×¢ÓÚËùµÃµÄ½á¹ûÊÇ·ñÕýÈ·£¬¶øºöÂÔ
Á˲»Í¬µÄʵÏÖ·½·¨Ö®¼ä¿ÉÄÜ´æÔÚµÄÐÔÄܲîÒ죬ÕâÖÖÐÔÄܲîÒìÔÚ´óÐ͵ĻòÊǸ´ÔÓµÄÊý¾Ý¿â
»·¾³ÖУ¨ÈçÁª»úÊÂÎñ´¦ÀíOLTP»ò¾ö²ßÖ§³ÖϵͳDSS£©ÖбíÏÖµÃÓ ......
ÔÎijö´¦£ºhttp://www.cnblogs.com/luoht/archive/2010/03/01/1676049.html
ÓÃINд³öÀ´µÄSQLµÄÓŵãÊDZȽÏÈÝÒ×д¼°ÇåÎúÒ׶®£¬Õâ±È½ÏÊʺÏÏÖ´úÈí¼þ¿ª·¢µÄ·ç¸ñ¡£
¡¡¡¡µ«ÊÇÓÃINµÄSQLÐÔÄÜ×ÜÊDZȽϵ͵ģ¬´ÓSQLÖ´ÐеIJ½ÖèÀ´·ÖÎöÓÃINµÄSQLÓë²»ÓÃINµÄSQLÓÐÒÔÏÂÇø±ð£º
¡¡¡¡SQLÊÔͼ½«Æäת»»³É¶à¸ö±íµÄÁ¬½Ó£¬Èç¹ûת»»²»³É¹¦ÔòÏÈÖ´ÐÐ ......
³¬¼¶ÓÐÓõÄSQLÓï¾ä £¨ÓÃÓÚSQL SERVER ·þÎñÆ÷£©
³¬¼¶ÓÐÓõÄSQLÓï¾ä £¬Ö´Ðк󷵻صÄÁзֱðÊÇ£º±íÃû¡¢ÁÐÃû¡¢ÁÐÀàÐÍ¡¢Áг¤¶È¡¢ÁÐÃèÊö¡¢ÊÇ·ñÖ÷¼ü£¬Óï¾äÈçÏ£º
(·ÖÎöSQL SERVER Êý¾Ý¿â±í½á¹¹×¨ÓÃ)
Select Sysobjects.Name As ±íÃû,
Syscolumns.Name As ÁÐÃû,
......
×î¼Ñ´ð°¸·½·¨1£º
ÔÚ²éѯ·ÖÎöÒÇÀïÃæÔËÐÐÏÂÃæ´úÂ룺
backup log dbname with NO_LOG
backup log dbname with TRUNCATE_ONLY
DBCC SHRINKDATABASE(dbname)
·½·¨2£º
½øÈëÆóÒµ¹ÜÀíÆ÷£¬Ñ¡ÖÐÊý¾Ý¿â
ËùÓÐÈÎÎñ->·ÖÀëÊý¾Ý¿â
µ½Êý¾Ý¿âÎļþµÄ´æ·ÅĿ¼£¬½«dbname_log.LDFÎļþɾ³ý£¬ÅÂSµÄ»° ......