SET ANSI_WARNINGS ON

This is a small example to understand the behaviour of SET ANSI_WARININGS option.
----Here SET ANSI_WARNINGS is ON
SET ANSI_WARNINGS ON
IF EXISTS(SELECT * FROM SYS.OBJECTS WHERE TYPE='U' AND [Name]='AnsiWarningsOn')
BEGIN
DROP TABLE AnsiWarningsOn
END
CREATE TABLE AnsiWarningsOn
([Name] VARCHAR(2))
INSERT INTO AnsiWarningsOn
VALUES('Ramesh Mamillapalli')

-----SET ANSI_WARNINGS is OFF
SET ANSI_WARNINGS OFF
IF EXISTS(SELECT * FROM SYS.OBJECTS WHERE TYPE='U' AND [Name]='AnsiWarningsOn')
BEGIN
DROP TABLE AnsiWarningsOn
END
CREATE TABLE AnsiWarningsOn
([Name] VARCHAR(2))
INSERT INTO AnsiWarningsOn
VALUES('Ramesh Mamillapalli')
SELECT * FROM AnsiWarningsOn

Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server