User Define Function Problems in SQL Server

Hello Friends,

First of all sorry for such a late post it just because I have lot of tension now a days 🙂

So today we start a new topic in which I stuck User Define Functions in SQL Server.

By the name use think User Define function is so easy just like store procedure.

So I will yes it just like sql server but it has some limitaion which I am facing.

These are

1)We can not use try catch Block in User define functions.

2) We can use Execute sp_ExecuteSQL in UDF.

3) we can not use Execute(sqlStatement) in UDF.

4) we can not use getDate() in UDF.

5) we can not call a store procedure however we can call extended store procedures.

6) We can not User Temporary table in UDF.

The solution of it which I used made a CLR function.

If you found another solution than share it with me.

Enjoy programming 🙂

Enjoy Sql Server 🙂

Thanks & Regards

Rajat Jaiswal

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s