![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sqlserver
lu_huabin
这个作者很懒,什么都没留下…
展开
-
truncate table 之后id列的处理,重置ID列
select IDENT_CURRENT('TM_TEST') --20899486 truncate table TM_TEST DBCC CHECKIDENT (TM_TEST, RESEED, 20899486)原创 2015-08-13 11:56:50 · 734 阅读 · 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 · 674 阅读 · 0 评论 -
扩展存储过程 xp_smtp_sendmail的安装
文件: xpsmtp80.dll 存放路径: C:\Program Files\Microsoft SQL Server\80\Tools\Binn 注册存储过程: EXEC master.dbo.sp_addextendedproc 'xp_smtp_sendmail', 'xpsmtp80.dll'原创 2015-08-18 16:35:32 · 361 阅读 · 0 评论 -
sp_spaceused 或者sysindexes 的rowcnt不准确的解决办法
DBCC UPDATEUSAGE('dbname','tablename') WITH count_rows原创 2015-08-18 16:37:37 · 577 阅读 · 0 评论 -
列出有非簇集索引的表
select o.name as TableName ,i.name as IndexName from sysindexes i inner join sysobjects o on i.id = o.id where type = 'u' and indid>1 and i.name not like '_WA_Sys_%' order by o.name原创 2015-08-19 16:35:13 · 336 阅读 · 0 评论 -
sp_MSforeachtable的用法,对某数据库的所有表进行操作
EXEC sp_MSforeachtable @command1="DBCC UPDATEUSAGE('tempdb','?') WITH count_rows", @command2="sp_spaceused '?'" sp_MSforeachdb有类似的用法原创 2015-08-19 16:39:13 · 1168 阅读 · 0 评论 -
有ID列的表
select object_name(id) tablename,name IDField from syscolumns where status=0x80原创 2015-08-19 16:37:06 · 288 阅读 · 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 · 355 阅读 · 0 评论