行级安全性+ Switch语句

作者: 疯子哥哥
发布时间: 2024-12-12 01:44:56 (12天前)
转自：

2 条回复

0#
回复此人
一瓶泡沫 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <pre> <code> DECLARE @ProfileType date = (SELECT ProfileType FROM dbo.UserProfiles WHERE UserLogin = @username) if @ProfileType = 1 select isnull(Data, 'NaN') from BIG_TABLE else if @ProfileType = 2 select isnull(Data, 'NaN') from BIG_TABLE where colA = @username else select isnull(Data, 'NaN') from BIG_TABLE where colB = @username End </code> </pre> <P> 或者，如果你喜欢使用str exec </p> <pre> <code> DECLARE @ProfileType date = (SELECT ProfileType FROM dbo.UserProfiles WHERE UserLogin = @username) declare @str_sql varchar(1000) set @str_sql = 'select isnull(Data, "NaN") from BIG_TABLE' if @ProfileType = 2 set @str_sql += ' where colA = ' + @username else if @ProfileType = 3 set @str_sql += ' where colB = ' + @username exec(@str_sql) </code> </pre> </DIV>

编辑

登录后才能参与评论