Nakul Vachhrajani

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

16,377 reads

Blogs

Microsoft Tools That Help Query Tuning

By

Query tuning is not easy. In fact, for a lot of people, you shouldn’t...

Author of the Year 2019 Nomination at MSSQLTips

By

This year I’ve been nominated again for the Author of the Year award at...

Extended Events Misperceptions: Profiler is Easier

By

I know, I know, I’m on #teamexevents so I think that Extended Events can...

Read the latest Blogs

Forums

how to create query based on optional field on temp table ?

By ahmed_elbarbary.2010

problem how to create query based on optional field on temp table ? I...

how to create query based on optional field on temp table ?

By ahmed_elbarbary.2010

problem how to create query based on optional field on temp table ? I...

SQL Transaction Replication on a large DB

By ARPRINCE

I want to create a transaction replication (SVR-A to SVR-B) from scratch on one...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers