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

MSSQLÊý¾Ý¿â²Ù×÷ʹÓÃÓï¾ä


1.°´ÐÕÊϱʻ­ÅÅÐò: 
Select * from TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as 
2.·ÖÒ³SQLÓï¾ä 
select * from(select (row_number() OVER (ORDER BY tab.ID Desc)) as rownum,tab.* from ±íÃû As tab) As t where rownum between ÆðʼλÖà And ½áÊøÎ»Öà
3.»ñÈ¡µ±Ç°Êý¾Ý¿âÖеÄËùÓÐÓû§±í 
select * from sysobjects where xtype='U' and category=0 
4.»ñȡijһ¸ö±íµÄËùÓÐ×ֶΠ
select name from syscolumns where id=object_id('±íÃû') 
5.²é¿´Óëijһ¸ö±íÏà¹ØµÄÊÓͼ¡¢´æ´¢¹ý³Ì¡¢º¯Êý 
select a.* from sysobjects a, syscomments b where a.id = b.id and b.text like '%±íÃû%' 
6.²é¿´µ±Ç°Êý¾Ý¿âÖÐËùÓд洢¹ý³Ì 
select name as ´æ´¢¹ý³ÌÃû³Æ from sysobjects where xtype='P' 
7.²éѯÓû§´´½¨µÄËùÓÐÊý¾Ý¿â 
select * from master..sysdatabases D where sid not in(select sid from master..syslogins where name='sa') 
»òÕß 
select dbid, name AS DB_NAME from master..sysdatabases where sid <> 0x01 
8.²éѯijһ¸ö±íµÄ×ֶκÍÊý¾ÝÀàÐÍ 
select column_name,data_type from information_schema.columns 
where table_name = '±íÃû' 
9.ʹÓÃÊÂÎñ 
ÔÚʹÓÃһЩ¶ÔÊý¾Ý¿â±íµÄÁÙʱµÄSQLÓï¾ä²Ù×÷ʱ£¬¿ÉÒÔ²ÉÓÃSQL SERVERÊÂÎñ´¦Àí£¬·ÀÖ¹¶ÔÊý¾Ý²Ù×÷ºó·¢ÏÖÎó²Ù×÷ÎÊÌâ 
¿ªÊ¼ÊÂÎñ 
Begin tran 
  Insert Into TableName Values(…) 
SQLÓï¾ä²Ù×÷²»Õý³££¬Ôò»Ø¹öÊÂÎñ¡£ 
»Ø¹öÊÂÎñ 
Rollback tran 
SQLÓï¾ä²Ù×÷Õý³££¬ÔòÌá½»ÊÂÎñ£¬Êý¾ÝÌá½»ÖÁÊý¾Ý¿â¡£ 
Ìá½»ÊÂÎñ 
Commit tran 
10. °´È«ÎÄÆ¥Å䷽ʽ²éѯ 
×Ö¶ÎÃû LIKE N'%[^a-zA-Z0-9]China[^a-zA-Z0-9]%' 
OR ×Ö¶ÎÃû LIKE N'%[^a-zA-Z0-9]China' 
OR ×Ö¶ÎÃû LIKE N'China[^a-zA-Z0-9]%' 
OR ×Ö¶ÎÃû LIKE N'China 
11£®¼ÆËãÖ´ÐÐSQLÓï¾ä²éѯʱ¼ä 
declare @d datetime 
set @d=getdate() 
select * from SYS_ColumnProperties select [Óï¾äÖ´Ðл¨·Ñʱ¼ä(ºÁÃë)]=datediff(ms,@d,getdate()) 
12¡¢ËµÃ÷£º¼¸¸ö¸ß¼¶²éѯÔËËã´Ê 
A£º UNION ÔËËã·û 
UNION ÔËËã·ûͨ¹ý×éºÏÆäËûÁ½¸ö½á¹û±í£¨ÀýÈç TABLE1 ºÍ TA


Ïà¹ØÎĵµ£º

»ùÓÚmssql °ÙÍò¼¶ Êý¾Ý ²éѯ ÓÅ»¯ ¼¼ÇÉÈýÊ®Ôò

1.¶Ô²éѯ½øÐÐÓÅ»¯£¬Ó¦¾¡Á¿±ÜÃâÈ«±íɨÃ裬Ê×ÏÈÓ¦¿¼ÂÇÔÚ where ¼° order by Éæ¼°µÄÁÐÉϽ¨Á¢Ë÷Òý¡£
2.Ó¦¾¡Á¿±ÜÃâÔÚ where ×Ó¾äÖжÔ×ֶνøÐÐ null ÖµÅжϣ¬·ñÔò½«µ¼ÖÂÒýÇæ·ÅÆúʹÓÃË÷Òý¶ø½øÐÐÈ«±íɨÃ裬È磺
select id from t where num is null
¿ÉÒÔÔÚnumÉÏÉèÖÃĬÈÏÖµ0£¬È·±£±íÖÐnumÁÐûÓÐnullÖµ£¬È»ºóÕâÑù²éѯ£º
select id ......

MSSQLÊý¾ÝÀàÐͼ°³¤¶ÈÏÞÖÆÏêϸ˵Ã÷

SQL Server ÌṩϵͳÊý¾ÝÀàÐͼ¯£¬¶¨ÒåÁË¿ÉÓë SQL Server Ò»ÆðʹÓõÄËùÓÐÊý¾ÝÀàÐÍ¡£ÏÂÃæÁгöϵͳÌṩµÄÊý¾ÝÀàÐͼ¯¡£
¿ÉÒÔ¶¨ÒåÓû§¶¨ÒåµÄÊý¾ÝÀàÐÍ£¬ÆäÊÇϵͳÌṩµÄÊý¾ÝÀàÐ͵ıðÃû¡£ÓйØÓû§¶¨ÒåµÄÊý¾ÝÀàÐ͵ĸü¶àÐÅÏ¢£¬Çë²Î¼û sp_addtype ºÍ´´½¨Óû§¶¨ÒåµÄÊý¾ÝÀàÐÍ¡£
µ±Á½¸ö¾ßÓв»Í¬Êý¾ÝÀàÐÍ¡¢ÅÅÐò¹æÔò¡¢¾«¶È¡¢Ð¡ÊýλÊý»ò³ ......

MSSQLÊý¾Ý¿âÊý¾ÝÀàÐÍ


 
    Êý¾ÝÀàÐÍ
 
 ÀàÐÍ
 
 ÃèÊö
 
bit
 
ÕûÐÍ
 
bit Êý¾ÝÀàÐÍÊÇÕûÐÍ£¬ÆäÖµÖ»ÄÜÊÇ0¡¢1»ò¿ÕÖµ¡£ÕâÖÖÊý¾ÝÀàÐÍÓÃÓÚ´æ´¢Ö»ÓÐÁ½ÖÖ¿ÉÄÜÖµµÄÊý¾Ý £¬ÈçYes »òNo¡¢True »òFa lse ¡¢On »òOff
int
 
ÕûÐÍ
 
int Êý¾ÝÀàÐÍ¿ÉÒÔ´æ´¢´Ó- 231( ......

MSSQLÊý¾Ý¿âÖз¢ÏÖD99_tmp±íµÄ´¦Àí·½·¨

ÏàÐźܶàASP+MSSQLµÄÍøÕ¾¶¼Óб»ÈË×¢Èë¹ýµÄ¾­Àú£¬Êý¾Ý¿â±íÖжàÁËһЩ±í£¬ÀàËÆÒÔϵıíD99_tmp,D99_cmd£¬kill_kk¡£
D99_tmp£¨subdirectory,depth,fileÈý¸ö×ֶΣ¬ÀïÃæµÄÊý¾Ý¶¼ÊÇÍøÕ¾ÎļþºÍĿ¼£©
MSSQLÊý¾Ý¿â´æÔÚ¼¸¸öΣÏÕµÄÀ©Õ¹´æ´¢¹ý³Ì£¬Ä¬ÈÏPublic×é¿ÉÖ´ÐÐȨÏÞ£¬SQL×¢ÈëÕß¿ÉÀûÓô˶ÁÈ¡ÎļþĿ¼¼°Óû§×飬²¢¿Éͨ¹ýÏÈдÈëÊý¾ ......

php 5.3 Á¬½ÓmssqlÊý¾Ý¿â

×î½üÓиöС¶«Î÷Òª²é¿´mssqlÊý¾Ý¿âÊÇÓÃphpʵÏֵģ¬ÒÔǰÎÒÓÃphp5.2ʱ¸Ð¾õͦ¼òµ¥µÄËùÒÔÏëphp5.3Ò²Ó¦¸ÃºÜ¼òµ¥µÄ
ΪʲôҪÓÃphp5.3ÄØÒòΪÎÒÏëÓÃsqlite3.0µÄ°¡£¬ÒòΪphp5.2µÄ²»Ö§³Ösqlite3.0µÄ°¡£¬ËùÒÔÎÒÌØÒâÈ¥ÏÂÁË5.3ÁËÏÂÔØ»ØÀ´Á˲ŷ¢ÏÖ5.3ÀïûÓÐmssqlµÄdllÀ©Õ¹ÁË£¬ÓôÃÆ°¡£¬²»¹ÜÕâô¶àÏÈÓÃÆðÄÇsqlite3.0ÔÙ˵ÁË
sqlite3.0µÄ²¿·Ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ