create proc uniqueNo
(
@TableName varchar(30),
@SelecttField varchar(30),
@WhereValue varchar(30)
)as
begin
exec('select '+@SelectField+' from '+@TableName+' where '+@selectField+'='+@WhereValue )
end
(
@TableName varchar(30),
@SelecttField varchar(30),
@WhereValue varchar(30)
)as
begin
exec('select '+@SelectField+' from '+@TableName+' where '+@selectField+'='+@WhereValue )
end
exec uniqueNo 'name','sysobjects','''xx'''注意''转椅为一个'select '''',''''''
(
@TableName varchar(30),
@SelecttField varchar(30),
@WhereValue varchar(30)
)
as
begin
exec('select '+@SelectField+' from '+@TableName+' where '+@selectField+'='''+@WhereValue+'''')
end--测试:
exec uniqueNo 'name','sysobjects','xx'