MS sqlserver
iteye_3911
这个作者很懒,什么都没留下…
展开
-
常用数据字典
sp_fkeys 这个存储过程可以查询哪些表以指定的主表作为外键连接 EXEC sp_fkeys @pktable_name = N'MEETING' select * from sysforeignkeys select * from sysobjects select * from syscolumns select * from sysreferences...原创 2010-11-18 10:30:25 · 118 阅读 · 0 评论 -
ms sqlserver sql example
select p.long_title as title, ps.[name] as STATUS, i.[name] as industry, c.[name] as category, pc.comment as 'comment', users.first_name + ' ' + users.last_name...原创 2010-11-18 10:32:30 · 97 阅读 · 0 评论