07 2010 档案
利用select for xml 生成以逗号分隔的字符串
摘要:代码 Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--DECLARE@T1table(UserIDint,UserNamenvarchar(50),CityNamenvarchar(50));insertinto@T1(UserID,UserName,... 阅读全文
posted @ 2010-07-27 18:02 vitamin 阅读(379) 评论(0) 推荐(1)
sql 显示外键关系
摘要:代码 Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--selectobject_name(fkeyid)FK_Table,object_name(rkeyid)PK_Table,b.nameFK_Column,c.namePK_Columnfromsy... 阅读全文
posted @ 2010-07-15 17:32 vitamin 阅读(253) 评论(0) 推荐(1)