SQL常用功能

最新推荐文章于 2022-08-02 09:25:21 发布

weixin_30892889

最新推荐文章于 2022-08-02 09:25:21 发布

阅读量195

点赞数

原文链接：http://www.cnblogs.com/hubj/archive/2008/07/13/1241750.html

版权

SQL筛选出相同记录

选出相同记录的SQL语句是：
select * from tableName where id in (
select id from tableName group by id having count(*) > 1)

删除相同记录的SQL语句是：
delete from tableName where id in (
select id from tableName group by id having count(*) > 1)

例如:

select * from book where isbn in (
select isbn from book group by isbn having count(*) > 1)

MSSQL ID自动从１开始
DBCC CHECKIDENT (表名, RESEED, 0) ＞＞MSSQL ID自动从１开始或者 truncate table tablename

把存储过程记录集新增到另一表 INSERT INTO EXEC
truncate table [tablename] 清空表,ID自动从１开始,
INSERT INTO [tablename]
EXEC [dbo].[spname]
@parameters = 0

转载于:https://www.cnblogs.com/hubj/archive/2008/07/13/1241750.html