Re: sqlexec

On Sun, 27 Aug 2006 01:40:02 -0700, shif wrote:

Hi
How can i execute a piece of sqlstmt which is stored in a string variable
from query analyser.
for ex:@var1="select name,code from" + @var2

Hi shif,

http://www.sommarskog.se/dynamic_sql.html

--
Hugo Kornelis, SQL Server MVP
.

Relevant Pages

Re: Help with SPROC, COMPUTE and OUTPUT
... Tibor Karaszi, SQL Server MVP ... > I am using an SQL data link from my ASP application to a SPROC - this all ... > This works in Query Analyser and outputs the COMPUTE statement - how do I ... The input variables defined ...
(microsoft.public.sqlserver.programming)
Re: Compare record count in table1 to qty in table2?
... Here is a query I'm trying to use and, of course, it does not work: ... INNER JOIN Item_Serial ... Hugo Kornelis, SQL Server MVP ...
(comp.databases.ms-sqlserver)
Re: Compare row data and input data into a new field
... >>I have a simple query which I cannot seem to work out and would like some ... > Why store it in the table and recalculate it each time you need it? ... > Hugo Kornelis, SQL Server MVP ...
(microsoft.public.sqlserver.mseq)
Re: SQL2005 collation vs Oracle
... Maybe keywords are case sensitive in Oracle?? ... Hugo Kornelis, SQL Server MVP ...
(comp.databases.ms-sqlserver)
Re: How can I get all records for both tables with the latest begin date if exists?
... I just replied to this question in the original thread. ... anything is stil unclear! ... Hugo Kornelis, SQL Server MVP ...
(comp.databases.ms-sqlserver)