zhoupuyue的专栏

declare @begin_date datetime declare @end_date datetime select @begin_date = getdate() SQL语句 select @end_date = getdate() select datediff(ms,@begin_date,@end_date) as '用时/毫秒'  ...

select id, [value] = stuff((select ',' + [value] from tb where id = t.id for xml path('')) , 1 , 1 , '') from tb t group by id 1 a 1 b 1 c 1 d 2 a 2 b 2 d 结果： 1 a,b,c...

在Microsoft SQL Server Management Studio Express中执行： SQL语法： insert into TableName (field1,field2,field3,field4) SELECT * FROM OPENDATASOURCE('SQLOLEDB', 'Data Source=192.168.54.54,1433...