Dynamic SQL inside User defined functions

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 […]

3 (2)

2007-04-18 (first published: )

2,956 reads

Blogs

Adding a Check Constraint to a Table–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Azure SQL Database Elasticity – Presentation Notes

By

This blog covers the content and points to the code used to create the...

How To: Create Schema Only Database Copies

By

Have you ever been asked to make a schema only copy of a database?...

Read the latest Blogs

Forums

query

By sankaripr

Hi i have 3 table that need to find out which id missing two...

Joining 2 select results into a single row

By mtz676

select( select name,enabled, case when enabled = 1 then 'active' else 'notactive' end as...

deleted duplicate post

By mtz676

deleted duplicate post

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers