Home > SQL Server > Control current session and specific information – SQL Server – SET Statements

Control current session and specific information – SQL Server – SET Statements


SET statement in SQL Server is used to handle a specific information (such as date format, displaying text length and etc) in the current session by altering the current session’s default set values. Some of the SET statements are already setup by the administrator at SQL instance level. So, when we initiate the session it applies all the default SET options to the user of that session. But, we have an option to alter that default value. Usually, we have to turn the set option ON or OFF and in some cases we have to pass some value to the set option. There are different groups of SET statements available in SQL Server as given below.

pic1I have discussed some of the functions that are related to SET statements in my blog post. Those are given below for reference.

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

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

%d bloggers like this: