MSSQL
Hotzenplotz
这个作者很懒,什么都没留下…
展开
-
SQL Server查看表占用的空间
create table #Data(name varchar(100),row varchar(100),reserved varchar(100),data varchar(100),index_size varchar(100),unused varchar(100))declare @name varchar(100) declare cur cursor for select nam...转载 2018-07-19 13:57:01 · 839 阅读 · 0 评论 -
SQL Server 查询每个表中各有多少条记录
select id,object_name(id) as tableName,indid,rows,rowcnt from sys.sysindexes a where indid in(0,1) order by rows desc原创 2018-07-19 13:58:13 · 9879 阅读 · 0 评论 -
MSSQLServer垮库查询
Delete from OPENDATASOURCE( 'SQLOLEDB', 'Data Source=192.168.1.20;User ID=binladen;Password=binladen_Password' ).[DBTest].dbo.职务 Select * From OPENDATASOURCE(...原创 2018-07-19 14:00:11 · 251 阅读 · 0 评论