In SQL Server Books Online (SSBOL), positioning sp_dbcmptlevel. then find described 6.0,6.5 and 7.0 compatibility between versions of the data sheet “97. You can take note SQL INSERT statement has the following syntax shown.

INSERT X
SELECT select_list INTO Y

Early SQL Server database (version 6.0 or 6.5) can accurately analysis and the words, but the new SQL Server database (version 7.0 or 8.0) can not be the correct analysis. Although the syntax of Y in any compatible setup required to do under the receiver operating inserted, but the old database This also allows for the existence of grammar. This syntax of the new databases are more stringent because of a syntax check and can not be enforced, however, “stringent requirements” while the preparation of the code users more stability.

Following is in a SQL Server 7.0 or 2000 to run a simple script Note that the above script syntax how old database but not pass the test of the new database checks.

SET NOCOUNT OFF
GO
USE pubs
GO
IF EXISTS (SELECT * FROM sysobjects WHERE type =
‘U’ AND name = ‘test’)
BEGIN
DROP TABLE test
END
GO
CREATE TABLE test (INT NULL col1, col2 INT NULL)
GO
EXEC sp_dbcmptlevel pubs, 65
GO
INSERT test
SELECT a, a INTO y
GO
EXEC sp_dbcmptlevel pubs, 70
GO
INSERT test
SELECT 2, a INTO y
GO