member 不用 message 字段 引号 sha 对数 roc
此存储过程实现了对数据表的通用查询
- --查询CREATE PROCEDURE[dbo]. [SelelctMessage]@strTable varchar(50),
- --要查询的表@strColum varchar(500),
- --要查询的字段( * 表示全部字段)@strWhere varchar(500)--查询的条件,
- 不用加where,直接列名 = 值。如果值是字符串,需加单引号as declare@sqlString varchar(400);
- declare@whereString varchar(500);
- 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‘
sqlserver 存储过程 查询
来源: http://www.bubuko.com/infodetail-2285443.html