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
*
*
*