SQL distinct 去除重复数据 删除

1、distinct 去重

SELECT distinct * FROM StandardProduct

SELECT distinct(ID) FROM StandardProduct

SELECT distinct ID,StandardProductName FROM StandardProduct

SELECT * FROM RetailerProduct WHERE ID IN (SELECT Max(ID) from RetailerProduct GROUP BY StandardProductID)

2、删除表

drop table [表名称]

3、删除表数据

truncate table [表名称]

4、删除某个数据库中所有表

use [dbTest]
go

--删除数据库中所有表
declare @sql varchar(8000)
while (select count(*) from sysobjects where type='u') > 0
    begin
        select @sql='drop table ' + name from sysobjects where (type = 'u') order by 'drop table ' + name
        exec(@sql) 
    end
GO

--创建表
CREATE TABLE [dbo].[sys_user](
	[id] [int] NOT NULL,
	[name] [nvarchar](20) NOT NULL
) ON [PRIMARY]
GO

5、删除某个数据库中所有表的数据

--1、Delete
declare @sql  varchar(5000)
set @sql = ''
select @sql = @sql +'delete from  '+[name]+';' from sysobjects where xtype='u'
print  @sql
--exec(@sql)
go

--2、Turncate
declare @sql  varchar(5000)
set @sql = ''
select @sql = @sql +'truncate table '+[name]+';'  from sysobjects where xtype='u'
print  @sql
--exec(@sql)
go

--3、创建表
CREATE TABLE [dbo].[sys_user](
	[id] [int] NOT NULL,
	[name] [nvarchar](20) NOT NULL
) ON [PRIMARY]
GO

--4、插入数据
insert [dbo].[sys_user] ([id], [name]) values (1, N'1')
go
insert [dbo].[sys_user] ([id], [name]) values (2, N'2')
go
insert [dbo].[sys_user] ([id], [name]) values (3, N'3')
go

*
*
*