Dynamic SQL inside User defined functions

By garvi, 2007/04/18

Total article views: 530 | Views in the last 30 days: 79

(not yet rated) Rate this |

The script details about the workaround for using Dynamic SQL inside T-SQL user defined functions. Basically, T-SQL doesn't allow developers to perform/write any actions/statments which would affect the database's state. As a key note factor for any migration process from oracle to sql server developers need to do a work around on using execute immediate(for framing queries only. Any DDL changes has to be avoided and if so the logic should be redesigned) in user defined functions. So in order to acheive this, we can either frame the queries dynamically and manipulate them by storing the resultant in local variables or we can go for a CTE. The code or script attached talks about one such situation

By garvi, 2007/04/18

Total article views: 530 | Views in the last 30 days: 79

Your response

(not yet rated) Rate this |

Join the discussion |

Briefcase

Related tags

Script to Search SQL Error Log For a String

By pochinej | Category: Miscellaneous

| 1,024 reads

Script to Attach Multiple MDF

By Andy Warren | Category: Miscellaneous

| 827 reads

Find strings in a stored procedure

By jraha | Category: Miscellaneous

| 1,364 reads

Convert Hex value to Signed 32-bit int

By oferb@mail.com | Category: Miscellaneous

| 955 reads

Like this? Try these...

how to start a program like Notepad.exe in a job

By Additional Articles | Category: Maintenance and Management

| 88 reads

Convert binary SID to string

By Todd Engen | Category: SID

| 483 reads

Difference between two dates in weeks

By Alex Dubitskiy

| 655 reads

Already registered?

Free registration required

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Register

E-mail address:
Password:
Password (confirm):

Subscriptions

We ask you to register on the site and subscribe to our newsletters. Subscribing to our newsletters gets you:

ALL of our content (thousands of articles, scripts, and forum postings)
A daily newsletter (example)
A weekly news round up (example)
The opportunity to ask and answer questions in our forums
A daily Question of the Day to test and help you increase your knowledge of SQL Server.

We ask that you give the newsletter a try for a week. Over 200,000 SQL Server Professionals a day find it entertaining and useful. If not, you are welcome to unsubscribe at anytime.

Steve Jones
Editor, SQLServerCentral.com