Re: sqlexec

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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: Exec Procedure within a View
    ... used like a view but can include commands, such as stored procedure calls. ... Hugo Kornelis, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • 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)