sql小技巧

快速查询表的总记录数

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 tranend trybegin catch    rollback tranend catch