插入
create proc usp_add
(
@Name nvarchar(max),
@param nvarchar(max)
)
as
declare @sql nvarchar(max)
set @sql = 'insert into '+ @Name+' values('+@param+')'
exec sp_executesql @sql
GO
查询
create proc usp_select
(
@Name nvarchar(max),
@Where nvarchar(max)=null
)
as
declare @sql nvarchar(max)
set @sql = 'select * from '+@Name
if(@Where is not null and len(@Where)>0)
set @sql+=' where '+@Where
exec sp_executesql @sql
GO
修改
create proc usp_update
(
@Name nvarchar(max),
@Param nvarchar(max),
@Where nvarchar(max)=null
)
as
declare @sql nvarchar(max)
set @sql = 'update '+@Name+' set '+ @param
if(@Where is not null and len(@Where)>0)
set @sql+=' where '+@Where
exec sp_executesql @sql
GO
删除
create proc usp_delete
(
@Name nvarchar(max),
@Where nvarchar(max)=null
)
as
declare @sql nvarchar(max)
set @sql = 'delete from '+@Name
if(@Where is not null and len(@Where)>0)
set @sql+=' where '+@Where
exec sp_executesql @sql
GO
create proc usp_add
(
@Name nvarchar(max),
@param nvarchar(max)
)
as
declare @sql nvarchar(max)
set @sql = 'insert into '+ @Name+' values('+@param+')'
exec sp_executesql @sql
GO
查询
create proc usp_select
(
@Name nvarchar(max),
@Where nvarchar(max)=null
)
as
declare @sql nvarchar(max)
set @sql = 'select * from '+@Name
if(@Where is not null and len(@Where)>0)
set @sql+=' where '+@Where
exec sp_executesql @sql
GO
修改
create proc usp_update
(
@Name nvarchar(max),
@Param nvarchar(max),
@Where nvarchar(max)=null
)
as
declare @sql nvarchar(max)
set @sql = 'update '+@Name+' set '+ @param
if(@Where is not null and len(@Where)>0)
set @sql+=' where '+@Where
exec sp_executesql @sql
GO
删除
create proc usp_delete
(
@Name nvarchar(max),
@Where nvarchar(max)=null
)
as
declare @sql nvarchar(max)
set @sql = 'delete from '+@Name
if(@Where is not null and len(@Where)>0)
set @sql+=' where '+@Where
exec sp_executesql @sql
GO