摘要: SELECT 表名=case when a.colorder=1 then d.name else '' end, 表说明=case when a.colorder=1 then isnull(f.value,'') else '' end, 字段序号=a.colorder, 字段名=a.name, 标识=case when COLUMNPROPERTY( a.id,a.name,'IsId... 阅读全文
posted @ 2006-07-05 09:47 滋心 阅读(252) 评论(0) 推荐(0) 编辑
摘要: exec sp_addlinkedserver @server='test_hmc', @srvproduct ='', @provider ='MSDASQL', @provstr ='driver={sql server};server=192.168.0.77;uid=sa;pwd=' go exec sp_addlinkedsrvlogin @rmtsrvname='test... 阅读全文
posted @ 2006-07-05 09:42 滋心 阅读(283) 评论(0) 推荐(0) 编辑