摘要：
use master;gocreate procedure bakdb (@f varchar(max))asbegin declare @file varchar(max) set @file=@f declare auth_cur cursor for select name from sysd 阅读全文
摘要：
DECLARE @x XML SET @x='<root> <rogue id="001"> <hobo id="1"> <name>彪</name> <nickname>阿彪</nickname> <type>流氓</type> <name>含</name> </hobo> </rogue> <r 阅读全文
摘要：
SELECT STUFF(( select '/'+convert(varchar,ID) from ( SELECT TOP 2 ID FROM dbo.T ) as a FOR XML PATH ('')),1,1,'') 阅读全文
摘要：
with a(a,b,c)as( SELECT [deptid],[deptname],[deptmgrid] FROM [T].[dbo].[Departments])select * from a 阅读全文
摘要：
select 1 where '[^A-Z]ABCDE' like 'a[a^Aa-Za]%' escape 'a' 阅读全文
摘要：
select a.ProjectID,c.* from BatchTask a cross apply (select * from TaskLog b where a.RsIndex=b.BatchTaskID) as c 同理，outer apply 阅读全文
摘要：
CREATE TABLE [dbo].[t]( [id] [int] IDENTITY(1,1) NOT NULL, [p] [nvarchar](max) NULL) ON [PRIMARY]insert into t(p) values('a,b,c')insert into t(p) valu 阅读全文