快速查询表的总记录数
SELECT rows FROM sysindexes WHERE id = OBJECT_ID('表名') AND indid < 2
如何在数据库中进行跨服务器查询
SELECT * FROMOPENDATASOURCE('SQLOLEDB' , 'Data Source=172.18.24.245;User ID=sa;Password=aaa*'). CenterObj_xx.dbo .TableLog AS A
使用事务,
begin try
begin tran
sqlstatement
commit tran
end try
begin catch
rollback tran
end catch