如何使用sql server编写内联查询 [英] how to write inline query using sql server

问题描述

create procedure check
declare @p_condition varchar(50);
declare @p_main varchar(50);
set @p_main='SELECT * FROM MASTER;
set @p_condition=where UPPER(USERNAME)=UPPER(admin);

exec check 

如何执行此操作。请帮助

how to execute this . please help

推荐答案

访问这里..



http://social.msdn.microsoft.com/Forums/vstudio / en-US / 3c2c7b74-addd-4aca-a324-ce74d88d883b / inline-queries-or-stored-procedure [ ^ ]

visit here..

http://social.msdn.microsoft.com/Forums/vstudio/en-US/3c2c7b74-addd-4aca-a324-ce74d88d883b/inline-queries-or-stored-procedure[^]

嘿那里，



我认为你的意思是动态查询：

在T-SQL上创建和执行动态SQL [ ^ ]



希望有帮助



Aze e ...

Hey there,

I think you mean dynamic queries:
Create and Execute Dynamic SQL on T-SQL[^]

Hope it helps

Azee...

试试这个： -

根据您的需要设置@UserName

Try this :-
set @UserName as per your need

Declare @SqlStr Varchar(4000)
Declare @UserName nvarchar(4000)
SET @Sql = ' SELECT  *  from Master where userName = ' + @UserName + ''
Execute(@SqlStr)

--Print @SqlStr

这篇关于如何使用sql server编写内联查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！