CREATE PROCEDURE sp_userlogin
@name varchar(50),@pass varchar(50),@usermeter varchar(50)
AS
exec('select top 1 UserId,UserRoot,UserLogTime from '+@usermeter+'
where UserName='''+@name+''' and UserPass='''+@pass+'''')
GO
@name varchar(50),@pass varchar(50),@usermeter varchar(50)
AS
exec('select top 1 UserId,UserRoot,UserLogTime from '+@usermeter+'
where UserName='''+@name+''' and UserPass='''+@pass+'''')
GO
@name char(50),@pass char(50),@usermeter char(50)
AS exec('select top 1 UserId,UserRoot,UserLogTime from ' + @usermeter + 'where UserName=''' + @name + ''' and UserPass=''' + @pass + '''')
GO