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.
- SET IDENTITY_INSERT