If Object_id('tempdb.dbo.#Compat') Is Not Null Drop Table #Compat Create Table #Compat (dbname sysname, dbsize nvarchar(13) null, owner sysname, dbid smallint, created nvarchar(11), dbdesc nvarchar(600) null, cmptlevel tinyint) Insert #Compat Exec sp_helpdb Set @ActualCmptLevel = (Select cmptlevel From #compat Where dbname = @dbname) If @ActualCmptLevel Is Not Null And @ActualCmptLevel <> 80 Insert @Options values(@dbname,'CmptLevel', '80', @ActualCmptLevel)第一行是正解 又涨知识了 :)
-- Create table basic template
-- =============================================
IF EXISTS(SELECT name
FROM sysobjects
WHERE name = N'<table_name, sysname, test_table>'
AND type = 'U')
DROP TABLE <table_name, sysname, test_table>
GOCREATE TABLE <table_name, sysname, test_table> (
<column_1, sysname, c1> <datatype_for_column_1, , int> NULL,
<column_2, sysname, c2> <datatype_for_column_2, , int> NOT NULL)
GO
CREATE TABLE (#TableName or ##TableName) (
<column_1, sysname, c1> <datatype_for_column_1, , int> NULL,
<column_2, sysname, c2> <datatype_for_column_2, , int> NOT NULL)
Create Table #Compat (dbname sysname, dbsize nvarchar(13) null, owner sysname, dbid smallint, created nvarchar(11), dbdesc nvarchar(600) null, cmptlevel tinyint)
Insert #Compat
Exec sp_helpdb
Set @ActualCmptLevel = (Select cmptlevel From #compat Where dbname = @dbname)
If @ActualCmptLevel Is Not Null And @ActualCmptLevel <> 80
Insert @Options values(@dbname,'CmptLevel', '80', @ActualCmptLevel)第一行是正解 又涨知识了 :)
http://community.csdn.net/Expert/topic/3097/3097330.xml?temp=.2570154