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

¾«ÃîSqlÓï¾ä

1£® ÅжÏa±íÖÐÓжøb±íÖÐûÓеļǼ
select a.* from tbl1 a
left join tbl2 b
on a.key = b.key
where b.key is null
         ËäȻʹÓÃinÒ²¿ÉÒÔʵÏÖ£¬µ«ÊÇÕâÖÖ·½·¨µÄЧÂʸü¸ßһЩ
2£® н¨Ò»¸öÓëij¸ö±íÏàͬ½á¹¹µÄ±í
select * into b
from a where 1<>1
3£®betweenµÄÓ÷¨,betweenÏÞÖÆ²éѯÊý¾Ý·¶Î§Ê±°üÀ¨Á˱߽çÖµ,not between²»°üÀ¨
select * from table1 where time between time1 and time2
select a,b,c, from table1 where a not between ÊýÖµ1 and ÊýÖµ2
4. ˵Ã÷£º°üÀ¨ËùÓÐÔÚ TableA Öе«²»ÔÚ TableBºÍTableC ÖеÄÐв¢Ïû³ýËùÓÐÖØ¸´ÐжøÅÉÉú³öÒ»¸ö½á¹û±í
(select a from tableA ) except (select a from tableB) except (select a from tableC)
5. ³õʼ»¯±í£¬¿ÉÒÔ½«×ÔÔö³¤±íµÄ×ÖÔö³¤×Ö¶ÎÖÃΪ1
TRUNCATE TABLE table1
6£®¶àÓïÑÔÉèÖÃÊý¾Ý¿â»òÕß±í»òÕßorder byµÄÅÅÐò¹æÔò
         --ÐÞ¸ÄÓû§Êý¾Ý¿âµÄÅÅÐò¹æÔò
ater database dbname collate SQL_Latin1_General_CP1_CI_AS
--ÐÞ¸Ä×ֶεÄÅÅÐò¹æÔò
alter table a alter column c2 varchar(50) collate SQL_Latin1_General_CP1_CI_AS
--°´ÐÕÊϱʻ­ÅÅÐò
select * from ±íÃû order by ÁÐÃû Collate Chinese_PRC_Stroke_ci_as
--°´Æ´ÒôÊ××ÖĸÅÅÐò
select * from ±íÃû order by ÁÐÃû Collate Chinese_PRC_CS_AS_KS_WS
7£®ÁгöËùÓеÄÓû§Êý¾Ý±í£º
SELECT TOP 100 PERCENT o.name AS ±íÃû
from dbo.syscolumns c INNER JOIN
      dbo.sysobjects o ON o.id = c.id AND objectproperty(o.id, N'IsUserTable') = 1 AND
      o.name <> 'dtproperties' LEFT OUTER JOIN
      dbo.sysproperties m ON m.id = o.id AND m.smallid = c.colorder
WHERE (c.colid = 1)
ORDER BY o.name, c.colid
8£®ÁгöËùÓеÄÓû§Êý¾Ý±í¼°Æä×Ö¶ÎÐÅÏ¢£º
SELECT TOP 100 PERCENT c.colid AS ÐòºÅ, o.name AS ±íÃû, c.name AS ÁÐÃû,
      t.name AS ÀàÐÍ, c.length AS ³¤¶È, c.isnullable AS ÔÊÐí¿Õ,
      CAST(m.[value] AS Varchar(100)) AS ˵Ã÷
from dbo.syscolumns c INNER JOIN
      dbo.sysobjects o ON o.id = c.id A


Ïà¹ØÎĵµ£º

SQL ServerÁ¬½ÓÖеÄËĸö×î³£¼û´íÎó

SQL ServerÁ¬½ÓÖеÄËĸö×î³£¼û´íÎó:
Ò»."SQL Server ²»´æÔÚ»ò·ÃÎʱ»¾Ü¾ø"
Õâ¸öÊÇ×ÔÓµÄ,´íÎó·¢ÉúµÄÔ­Òò±È½Ï¶à,ÐèÒª¼ì²éµÄ·½ÃæÒ²±È½Ï¶à.
Ò»°ã˵À´,ÓÐÒÔϼ¸ÖÖ¿ÉÄÜÐÔ:
1,SQL ServerÃû³Æ»òIPµØÖ·Æ´Ð´ÓÐÎó
2,·þÎñÆ÷¶ËÍøÂçÅäÖÃÓÐÎó
3,¿Í»§¶ËÍøÂçÅäÖÃÓÐÎó
Òª½â¾öÕâ¸öÎÊÌâ,ÎÒÃÇÒ»°ãÒª×ñÑ­ÒÔϵIJ½ÖèÀ´Ò»²½²½ÕÒ³öµ¼Ö´íÎóµ ......

SQL SERVER 2005 Óû§µÇ¼ʱ±¨18456´íÎó

[ÎÊÌâ]
×î½üͻȻ·¢ÏÖSQL SERVER Éí·ÝÑéÖ¤·½Ê½ÎÞ·¨Õý³£µÇ¼ÁË£¬×ÜÊDZ¨18456´íÎ󣬶øwindows Óû§¿ÉÒÔÕý³£µÇ¼¡£
[½â¾ö·½·¨]
ÔÚÍøÉÏËÑÁËһϣ¬ÄÇЩ·½·¨¶¼²»Äܽâ¾öÎÊÌ⣬ÓÚÊÇ»ØÏë×î½üÔÚ·þÎñÆ÷ÉÏ×öµÄһЩ²Ù×÷£ºÒ»¡¢¸ü¸Ä»úÆ÷Ãû³Æ£»¶þ¡¢Õë¶ÔÈ䳿²¡¶¾½Ï¶à£¬¹Ø±ÕÁËһЩDZÔÚÍþв¶Ë¿ÚÈç135¡¢445¡¢137£º139¡£
ÓÚÊÇÏȻָ´»úÆ÷Ãû³Æ£¬ ......

SQLÓï¾ä£º²éѯÊý¾Ý¿âÖÐËùÓзÇϵͳ±íµÄÐÅÏ¢

SELECT
       (case when a.colorder=1 then d.name else '' end)±íÃû,
       a.colorder ×Ö¶ÎÐòºÅ,
       a.name ×Ö¶ÎÃû,
       (case when COLUMNPROPERTY( a.id,a.name,'IsIdentity ......

SQL Server ֪ʶ»ýÀÛ

varcharºÍnvarcharÈçºÎÑ¡Ôñ£º
varcharÔÚSQL ServerÖÐÊDzÉÓõ¥×Ö½ÚÀ´´æ´¢Êý¾ÝµÄ£¬nvarcharÊÇʹÓÃUnicoÀ´´æ´¢Êý¾ÝµÄ¡£ÖÐÎÄ×Ö·û´æ´¢µ½SQL ServerÖлᱣ´æÎªÁ½¸ö×Ö½Ú£¨Ò»°ã²ÉÓÃUnico±àÂ룩£¬Ó¢ÎÄ×Ö·û±£´æµ½Êý¾Ý¿âÖУ¬Èç¹û×ֶεÄÀàÐÍΪvarchar£¬ÔòÖ»»áÕ¼ÓÃÒ»¸ö×Ö½Ú£¬¶øÈç¹û×ֶεÄÀàÐÍΪnvarchar£¬Ôò»áÕ¼ÓÃÁ½¸ö×Ö½Ú¡£ËäȻʹÓÃnva ......

SQLÁ÷Ë®ÕʺŵÄÉú³É

1 --ÏÂÃæµÄ´úÂëÉú³É³¤¶ÈΪ8µÄ±àºÅ£¬±àºÅÒÔBH¿ªÍ·£¬ÆäÓà6λΪÁ÷Ë®ºÅ¡£
2 --µÃµ½Ð±àºÅµÄº¯Êý
3 CREATE FUNCTION f_NextBH()
4 RETURNS char(8)
5 AS
6 BEGIN
7     RETURN(SELECT 'BH'+RIGHT(1000001+ISNULL(RIGHT(MAX(BH),6),0),6) from tb WITH(XLOCK,PAGLOCK))
8 END
9 GO
10
11 --ÔÚ±íÖÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ