Sqlº¯Êý´óÈ«
--¾ÛºÏº¯Êý
use pubs
go
select avg(distinct price) --ËãÆ½¾ùÊý
from titles
where type='business'
go
use pubs
go
select max(ytd_sales) --×î´óÊý
from titles
go
use pubs
go
select min(ytd_sales) --×îСÊý
from titles
go
use pubs
go
select type,sum(price),sum(advance) --ÇóºÍ
from titles
group by type
order by type
go
use pubs
go
select count(distinct city) --Çó¸öÊý
from authors
go
use pubs
go
select stdev(royalty) --·µ»Ø¸ø¶¨±í´ïʽÖÐËùÓÐÖµµÄͳ¼Æ±ê׼ƫ²î
from titles
go
use pubs
go
select stdevp(royalty) --·µ»Ø±í´ïʽÖÐËùÓÐÖÆµÄÌî³äͳ¼Æ±ê׼ƫ²î
from titles
go
use pubs
go
select var(royalty) --·µ»ØËùÓÐÖµµÄͳ¼Æ·½²î
from titles
go
use pubs
go
select varp(royalty) --·µ»ØËùÓÐÖµµÄÌî³äµÄͳ¼Æ·½²î
from titles
go
--Êýѧº¯Êý
select sin(23.45),atan(1.234),rand(),PI(),sign(-2.34) --ÆäÖÐrandÊÇ»ñµÃÒ»¸öËæ»úÊý
--ÅäÖú¯Êý
SELECT @@VERSION --»ñÈ¡µ±Ç°Êý¾Ý¿â°æ±¾
SELECT @@LANGUAGE --µ±Ç°ÓïÑÔ
--ʱ¼äº¯Êý
select getdate() as 'wawa_getdate' --µ±Ç°Ê±¼ä
select getutcdate() as 'wawa_getutcdate' --»ñÈ¡utcʱ¼ä
select day(getdate()) as 'wawa_day' --È¡³öÌì
select month(getdate()) as 'wawa_month' --È¡³öÔÂ
select year(getdate()) as 'wawa_year' --È¡³öÄê
select dateadd(d,3,getdate()) as wawa_dateadd --¼ÓÈýÌì,×¢Òâ'd'±íʾÌì,'m'±íʾÔÂ,'yy'±íʾÄê,ÏÂÃæÒ»Ñù
select datediff(d,'2004-07-01','2004-07-15') as wawa_datediff --¼ÆËãÁ½¸öʱ¼äµÄ²î
select datename(d,'2004-07-15') as wawa_datename --È¡³öʱ¼äµÄijһ²¿·Ö
select datepart(d,getdate()) as wawa_datepart --È¡³öʱ¼äµÄijһ²¿·Ö,ºÍÉÏÃæµÄÄǸö²î²»¶à
--×Ö·û´®º¯Êý
select ascii(123) as '123',ascii('123') as '"123"',ascii('abc') as '"abc"' --ת»»³ÉasciiÂë
select char(123),char(321),char(-123) --¸ù¾Ýasciiת»»³É×Ö·û
select lower('ABC'),lower('Abc'),upper('Abc'),upper('abc') --ת»»´óСд
select str(123.45,6,1), str(123.45,2,2) --°ÑÊýֵת»»³É×Ö·û´®
select ltrim(' "×ó±ßûÓпոñ"') --È¥¿Õ¸ñ
select rtrim('"ÓÒ±ßûÓпոñ" ') --È¥¿
Ïà¹ØÎĵµ£º
Ò»¡¢°´Ö¸¶¨·ûºÅ·Ö¸î×Ö·û´®£¬·µ»Ø·Ö¸îºóµÄÔªËØ¸öÊý£¬·½·¨ºÜ¼òµ¥£¬¾ÍÊÇ¿´×Ö·û´®ÖдæÔÚ¶àÉÙ¸ö·Ö¸ô·ûºÅ£¬È»ºóÔÙ¼ÓÒ»£¬¾ÍÊÇÒªÇóµÄ½á¹û¡£
CREATE function Get_StrArrayLength
(
@str varchar(1024), --Òª·Ö¸îµÄ×Ö·û´®
@split varchar(10) --·Ö¸ô·ûºÅ
)
......
1¡¢ÔÚ°²×°ÓÐSQL SERVER 2000µÄµçÄÔÉÏ´ò¿ª“ʼþ̽²éÆ÷”£¬²Ù×÷Èçͼ£º
2¡¢Ôړʼþ̽²éÆ÷”ÖÐн¨Ò»¸ö¸ú×Ù£ºÎļþ/н¨/¸ú×Ù
3¡¢ÊäÈëÁ¬½Ó·þÎñÆ÷µÄÃØÃÜ£¬×¢ÒâÊÇU8µÄÊý¾Ý·þÎñÆ÷£¬¿ÉÒÔ¸ù¾Ýʵ¼ÊÐÞ¸ÄIPµØÖ·¡£
4¡¢¸ü¸Ä¹ýÂËÉèÖ㺿ÉÒÔÔÚ¡¾Îļþ/ÊôÐÔ¡¿´ò¿ªÕâ¸ö¶Ô»°¿ò£¬µ«ÊÇÒª¸ü¸Ä£¬Ê× ......
ÏÖÔÚÓÃMSSQLµÄµØ·½Ì«¶àÁË£¬Óкܶà×ö¼¼ÊõµÄ¸öÈ˵çÄÔÉÏÒ²°²×°SQLרҵ°æ£¬ÒòΪËüÓõĶ࣬µ«ÓõÄÈ˶¼ÖªµÀ£¬SQLÓиö³¬¼¶Óû§sa£¬´ËÓû§Ä¬ÈÏÇé¿öÏ£¬ËüÖ¸Åɸø¹Ì¶¨·þÎñÆ÷½ÇÉ« sysadmin£¬²¢²»ÄܽøÐиü¸Ä¡£Ò»°ã¶®µã°²È«ÎÊÌâµÄ¼¼ÊõÈËÔ±¶¼»á°ÑÕâ¸öÃÜÂëÐ޸ĵô£¬µ«ÐÞ¸ÄÔÙ¸´ÔÓµÄÃÜÂë¶¼²»ÊǾø¶Ô°²È«µÄ£¬Ò»Ð©±©Á¦ÆÆ½âÈí¼þ£¬²ËÄñ¶¼»áÓá£
ÄÇ ......
SQL Server¸ù¾Ý²éѯ½á¹û,Éú³ÉXMLÎļþ
À´Ô´£º²»Ïê ×÷ÕߣºØýÃû ʱ¼ä£º2009-3-6 22:15:58 ·¢²¼£ººÚ¿ÍÈí¼þÔ°
/*
'bcp' ²»ÊÇÄÚ²¿»òÍⲿÃüÁҲ²»ÊÇ¿ÉÔËÐеijÌÐò£¿
¿´¿´ÔÚC:\Program Files\Microsoft SQL Server\80\Tools\BinnÀïÃæÓÐûÓÐbcp.exeÕâ¸öÎļþ
È»ºó¿´¿´pathÀïÃæ¼ÓC:\Program Files\Microso ......