Create proc up_use @table varchar(10), @column varchar(10) as declare @sqlstr varchar(100) set @sqlstr='select * from '+ @table +' where ''''='+ @column exec (@sqlstr) go
alter proc up_use @table varchar(10), @column varchar(10) as declare @sqlstr nvarchar(100) set @sqlstr='select * from '+ @table +' where ''''='+ @column exec sp_executesql @sqlstr go
exec('select * from '+@table_+' where '+@column_+'='''...''') 这句话会不会最后少个'
create proc up_use @table_ char(10), @column_ char(10) as DECLARE @strSql varchar(8000) set @strSql = 'select * from ' + @table_ + ' where ' + @column_ + '=''''' print @strSql exec(@strSql) go输入要查询的表和字段就可以了
@table varchar(10),
@column varchar(10)
as
declare @sqlstr varchar(100)
set @sqlstr='select * from '+ @table +' where ''''='+ @column
exec (@sqlstr)
go
@table varchar(10),
@column varchar(10)
as
declare @sqlstr nvarchar(100)
set @sqlstr='select * from '+ @table +' where ''''='+ @column
exec sp_executesql @sqlstr
go
这句话会不会最后少个'
@table_ char(10),
@column_ char(10)
as
DECLARE @strSql varchar(8000)
set @strSql = 'select * from ' + @table_ + ' where ' + @column_ + '='''''
print @strSql
exec(@strSql)
go输入要查询的表和字段就可以了