随笔分类 -  SqlServer

摘要：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... 阅读全文

摘要：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... 阅读全文