sqlµãµÎ

×Ó±í²éѯ£¬¸¸±íÒ»¶¨Òª¼Ó±ðÃû£¬·ñÔòÊý¾Ý»áÓÐÎÊÌ⣬²»±¨±àÒë´í
select * from table1 a where exist(select 1 from table2 where a.id=b.id)
´æ´¢¹ý³Ì½á¹û¼¯²åÈëµ½ÏÖÓбí
insert into table1 exec procname args
ÁªºÏÒÑÓÐ±í£¬½ô¸úÔÚºóÃ棬¶Ô»ã×ܺÜÓÐÓÃ
select a from table1 union all select 'ºÏ¼Æ'
½á¹û¼¯ÀïµÄijÁÐÏà¼Ó
declare @var nvarchar(1000)
set @var=''
select @var=@var+','+alarmname from notice where args=@args
print @var
shellÃüÁî
declare @cmd nvarchar(1000)
set @cmd='bcp "select cellphone,msg from atm.dbo.sendoutmsg" queryout '+@outfile+' -c -q -t "|"  -U'+@sqluser+' -P'+@sqlpwd +' -S'+@server
EXEC master..xp_cmdshell    @cmd    ,NO_OUTPUT
(
@cmd ¿ÉÒÔÊÇ£º
dir    c:\      c:\dir_out.txt
del   c:\deposit.htm
copy   c:\resource\deposit.htm    c:\
move   c:\µ¹Èë0911.xls    d:\µ¹Èë0911.xls
)
´óÈÝÁ¿Êý¾Ýµ¼Èë(ÒÔ\r\nΪÊý¾ÝÐнáβ,|ΪÁзָî·û)
DECLARE @bulk_cmd varchar(1000);
SET @bulk_cmd = 'BULK INSERT dbo.tmpbasedevinfo from ''D:\dev_bmsg.txt''
                             with (FIELDTERMINATOR =''|'',
                                      ROWTERMINATOR = '''+CHAR(10)+''')';
exec(@bulk_cmd);
ÅжÏÎļþÊÇ·ñ´æÔÚ
create table #tb(a bit,b bit,c bit)  
  insert into #tb exec master..xp_fileexist 'c:\furniture.txt'
  if exists(select * from #tb where a=1)
  PRINT Îļþ´æÔÚ
  else
  PRINT Îļþ²»´æÔÚ
drop table #tb