摘要：实验室表：LaboratoryRoom标签表：Tag关系表：Lab_Tagselect lab.Name,STUFF( ( SELECT ',' + isnull(TagName,'') FROM Tag WHERE Id in (select TagId from Lab_Tag where LabId = lab.Id) FOR XML PATH('') ), 1, 1, '') as tags from dbo.LaboratoryRoom as labstuff函数用于去掉多余的逗号stuff函数用法：select STU 阅读全文

摘要：insert into t (f) select f1 union select f2 union select f3 多值插入select xxx into t2 from t1update t1 set xx = (select xx from t2 where id=t1.id) 阅读全文

摘要：调用系统存储过程清空所有表 EXECUTE sp_msforeachtable 'truncate table ?' 阅读全文

摘要：SetStyle(ControlStyles.UserPaint | ControlStyles.AllPaintingInWmPaint | ControlStyles.OptimizedDoubleBuffer | ControlStyles.ResizeRedraw | ControlStyles.SupportsTransparentBackColor, true); 阅读全文