Technical Article

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)

You rated this post out of 5. Change rating

2007-04-18 (first published: )

3,889 reads

Blogs

Becoming Kristyna Ferris <3

By

Hey folks, fun personal post today. A few weeks ago, I got married! My...

What I Love About My Job

By

In June this year I took redundancy from the company I’d worked at for...

TryHackMe Advent of Cyber

By

I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...

Read the latest Blogs

Forums

SQL Replication - Disconnected from Azure Storage with OS result code: 0

By DanielP

Hello, We had a few errors with replication for SQL Managed Instance stopped working...

Provider not found in SSMS

By cphite

I am trying to setup a linked server and per the documentation it needs...

Ola hallengren backup not deleting old backup files for SQL 2016 Clusters

By PJ_SQL

Ola hallengren stopped deleting older files for SQL Server 2016 which are on cluster....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers