12 2010 档案

常用sql命令
摘要: 1.查看数据库连接的sql语句use master;select * from sysprocesses where dbid in (select dbid from sysdatabases where name ='数据库名');2.允许将显式值插入表的标识列中。SET IDENTITY_INSERT语法SET IDENTITY_INSERT [ database.[ owner.] ] { table } { ON | OFF }3.重置identity列的值 查看表tablename的自增列的当前值dbcc checkident('tablename'阅读全文
posted @ 2010-12-27 09:31 东风31 阅读(26) | 评论 (0) 编辑