SQLServerCentral Article

SQL Server Stored Procedures and SET options

SET options on stored Procedures work a bit different when compared with ad-hoc queries. These differences in behavior are often overlooked when developing the procedures and generating deployment scripts. This mistake can lead to undesired behavior in the application.

4.25 (36)

2015-10-02 (first published: )

18,975 reads

Blogs

Daily Coping 23 Sep 2022

By

Today’s coping tip is to notice what you are feeling without any judgment. Today...

Snowflake – Where is the explain/execution plan?

By

Whatever your database background is you will have heard of an execution / explain...

Daily Coping 22 Sep 2022

By

Today’s coping tip is to ask a trusted friend to tell you what strengths...

Read the latest Blogs

Forums

When use sql graph on sql server 2019 ?

By ahmed_elbarbary.2010

I working on sql server 2019 . i read more about sql graph but...

how to change hard coded dates to ytd please

By asita

Dear Helpers, Below query is working fine giving me what i needed but if...

Couldn't allocate new page for database alert even the Database has free space

By ramana3327

Hi, We have a database. We received the alert Could not allocate new page...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers