2011 年 9月 7 日随笔档案 - qanholas

2011年9月7日

摘要： --------------------------------------------------------------------------------------------------清空缓存DBCC FREEPROCCACHE WITH NO_INFOMSGSDBCC FREESESSIONCACHE WITH NO_INFOMSGSDBCC FREESYSTEMCACHE('All') WITH NO_INFOMSGSDBCC DROPCLEANBUFFERS WITH NO_INFOMSGSSET NOCOUNT on CREATE TABLE #result 阅读全文

posted @ 2011-09-07 18:13 qanholas 阅读(1911) 评论(0) 推荐(0)

GUID和自增ID的比较_insert

摘要： 1.单条插入--------------------------------------------------------------------------------------------------清空缓存DBCC FREEPROCCACHE WITH NO_INFOMSGSDBCC FREESESSIONCACHE WITH NO_INFOMSGSDBCC FREESYSTEMCACHE('All') WITH NO_INFOMSGSDBCC DROPCLEANBUFFERS WITH NO_INFOMSGSSET NOCOUNT on DECLARE @费用ID 阅读全文

posted @ 2011-09-07 17:20 qanholas 阅读(1162) 评论(0) 推荐(0)

GUID和自增ID的比较_delete

摘要： 1.范围删除--------------------------------------------------------------------------------------------------清空缓存DBCC FREEPROCCACHE WITH NO_INFOMSGSDBCC FREESESSIONCACHE WITH NO_INFOMSGSDBCC FREESYSTEMCACHE('All') WITH NO_INFOMSGSDBCC DROPCLEANBUFFERS WITH NO_INFOMSGSSET NOCOUNT on DECLARE @费用ID 阅读全文

posted @ 2011-09-07 16:48 qanholas 阅读(533) 评论(0) 推荐(0)

GUID和自增ID的比较_select

摘要： 1.取最后一条数据--------------------------------------------------------------------------------------------------清空缓存DBCC FREEPROCCACHE WITH NO_INFOMSGSDBCC FREESESSIONCACHE WITH NO_INFOMSGSDBCC FREESYSTEMCACHE('All') WITH NO_INFOMSGSDBCC DROPCLEANBUFFERS WITH NO_INFOMSGSSET NOCOUNT on CREATE TABL 阅读全文

posted @ 2011-09-07 16:20 qanholas 阅读(1345) 评论(0) 推荐(0)

SQL语句实现取消自增列属性

摘要： 1、如果仅仅是指定值插入，可用以下语句，临时取消SET IDENTITY_INSERT TableName ONINSERT INTO tableName(xx,xx) values(xx,xx)SET IDENTITY_INSERT TableName OFF2、新增一列，删除自增列，修改改列名alter table a add xxx intupdate a set xxx=idalter table a drop column idexec sp_rename 'xxx', 'id', 'column'3、通过修改系统关于该表的列属性，该方阅读全文

posted @ 2011-09-07 10:57 qanholas 阅读(611) 评论(0) 推荐(0)

公告