摘要： /* from: http://topic.csdn.net/t/20051208/20/4447231.html*/字段rowno int identity(1,1)，在delete完数据之后，如何让rowno再次从1开始自动增长？TRUNCATE TABLE name************************* 下例强制 jobs 表中的当前标识值为 30。 USE pubs GO DBCC CHECKIDENT (jobs, RESEED, 30) GO*************************TRUNCATE TABLE ... 阅读全文

摘要： /* from: http://www.diybl.com/course/7_databases/sql/sqlServer/2007106/77007.html*/远程登录SQL2005出错Error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not a 阅读全文