SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Using Dynamic SQL (Simple question - hopefully)
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

JacobPressures
Posting Yak Master

112 Posts

Posted - 01/04/2013 :  11:54:10  Show Profile  Reply with Quote
Is it possible to execute a dynamically created SQL statement that is stored in a variable in a regular SQL statement? (I'm considering creating a function but I thought I'd find out just in case.)

I have a tedious Statement that would be better created dynamically rather than manually. I'd like to use it in as a subquery perhaps.

Suppose I had a statement such as (just a simple example i suppose)

SET @SQLstr = 'SELECT UPPER(FName) FROM Person'

Of course something that simple i could just write out but i assume any type of complex string operation would be same regardless.
Thanks

webfred
Flowing Fount of Yak Knowledge

Germany
8765 Posts

Posted - 01/04/2013 :  12:20:15  Show Profile  Visit webfred's Homepage  Reply with Quote
see here:
http://www.sommarskog.se/dynamic_sql.html


Too old to Rock'n'Roll too young to die.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000