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: )

3,245 reads

Blogs

Ethics in Modern Data this Saturday with the South Florida Data Geeks

By

This Saturday Aug 7, Christine and I will present our joint presentation on Ethics...

3 Reasons Why Focusing on Tech Is The Worst Way To Deploy a HA/DR Solution

By

This past Thursday, Edwin Sarmiento presented a session for our Microsoft Data Platform Continuity...

The PowerBI Volleyball Report – Organizing Data To Start

By

One of my goals this year was to build a report that I can...

Read the latest Blogs

Forums

Minimun Role Permissions Needed

By Lou

Hi Friends, Please some guidance, To import a bacpac file in a MI instance,...

Need counts of payment amounts per week grouped by week

By joewhite

Hello, I have a code that suppose to give me weekly(summed) payments, but instead,...

Import CSV Data Into Existing Tables

By VSCurtis

Hi Guys, I am having issues trying to import data from CSV files into...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers