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,072 reads

Blogs

Azure SQL Database – Azure Portal Updates

By

A small but useful change has been made to the Azure Portal for Data...

SQL Server Quick Tips

By

Earlier this year I made a series of videos that were played before the...

The 2019 State of DevOps Report–Webinar

By

Tomorrow I get to chat with another giant in the world of DevOps: Jez...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

SQL Cluster with 10 nodes losing network connection.

By AlexSQLForums

Hi Everyone We have a 10 node (win 2016) sql 2016 SP2 CU6 cluster...

Query Help Pivot

By gksharmaajmer

My db version SQL Server 2008. CREATE TABLE [dbo].[exp]( [day] [int] NULL, [budgethead] [int]...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers