SQL Server Stored procedure query

This stored procedure implements a generic query on a data table

--Query Create PROCEDURE [dbo]. [Selelctmessage] @strTable varchar,  --the table to query @strcolum varchar (500),--the field to query (* denotes all fields) @strWhere varchar (500)  --The condition of the query, without adding where, direct column name = value. If the value is a string, enclose the single quotation mark asdeclare @sqlString varchar;d eclare @whereString varchar ($), if @strwhere is null or RTRIM (@ strwhere) = '    set @whereString = ', else    set @whereString = ' where ' [email protected];set @sqlString = ' SELECT ' [ Email protected]+ ' from ' [email protected][email protected];exec (@sqlString);--execute [dbo]. [Selelctmessage] ' Base._member ', ' id,acctnbr,acctname,acctpswd1 ', ' id>10 '

　　

SQL Server Stored procedure query