SELECT * FROM ( SELECT a.name as TableName , a.Type , a.Status , a.info as ColCount , b.number as IsColParam , b.name as ColName , b.colorder as ColOrder , b.xtype as ColType , b.length as ColLength , b.pr ...
比如,将 192.168.1.87的SQL Server 默认实例添加到当前的 SQL Server 实例中,设访问192.168.1.87的登录ID 为 sa, 密码为 use_link_svr,执行如下步骤: use master GO exec master.dbo.sp_addlinkedserver @server = N' 192.168.1.87 ', @srvproduct = N' SQL Server ...
SQL Server 2000 : GETDATE GetUTCDate NEWID RAND TEXTPTR SQL Server 2005 : NEWID RAND NEWSEQUENTIALID TEXTPTR SQL Server 2005 可以在用户定义函数中使用的函数: CURRENT_TIMESTAMP GET_TRANSMISSION_STATUS GETDATE GE ...