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

Blogs

Spark .NET - Spark ML TF-IDF

By

Spark ML in .NET for Apache Spark Spark is awesome, .NET is awesome, machine...

Daily Coping 7 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Publish ADF from code to further environments

By

Struggling with #ADF deployment? adf_publish branch doesn’t suit your purposes? Don’t have skills with PowerShell? I have good...

Read the latest Blogs

Forums

Help needed in checking dates spans and status

By dhanekulakalyan

Hello All, I have a requirement where we need to merge spans if the...

List of all OWNERS, not db_owner

By Footage

How can I get a list of all database owners in an instance (not...

Document recovery procedure

By Admingod

Trying to document a process in an event of disaster and different reasons. In...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers