sql
lu_huabin
这个作者很懒,什么都没留下…
展开
-
truncate table 之后id列的处理,重置ID列
select IDENT_CURRENT('TM_TEST')--20899486truncate table TM_TESTDBCC CHECKIDENT (TM_TEST, RESEED, 20899486)原创 2015-08-13 11:56:50 · 737 阅读 · 0 评论 -
BULK INSERT的使用,FIRSTROW的赋值
BULK INSERT tempdb.dbo.TMP_TEST FROM 'C:\DATA\TMP_TEST.csv' WITH (KEEPIDENTITY, FIELDTERMINATOR = '\t',ROWTERMINATOR = '\n',BATCHSIZE =1000 )BATCHSIZE选项的必要性:针对大文件,大数据提交的情况非常必要FIRST原创 2015-08-14 09:08:49 · 676 阅读 · 0 评论 -
列出有非簇集索引的表
select o.name as TableName ,i.name as IndexNamefrom sysindexes iinner join sysobjects o on i.id = o.idwhere type = 'u' and indid>1and i.name not like '_WA_Sys_%'order by o.name原创 2015-08-19 16:35:13 · 338 阅读 · 0 评论 -
有ID列的表
select object_name(id) tablename,name IDFieldfrom syscolumnswhere status=0x80原创 2015-08-19 16:37:06 · 291 阅读 · 0 评论 -
视图不能更新的检查,制约失效的检查
select * from sysobjects where id in( SELECT parent_obj FROM sysobjects WHERE xtype = 'C' AND status &0x800 = 0x800)原创 2015-08-19 16:38:00 · 357 阅读 · 0 评论 -
sp_MSforeachtable的用法,对某数据库的所有表进行操作
EXEC sp_MSforeachtable @command1="DBCC UPDATEUSAGE('tempdb','?') WITH count_rows",@command2="sp_spaceused '?'"sp_MSforeachdb有类似的用法原创 2015-08-19 16:39:13 · 1175 阅读 · 0 评论