生成创建数据库的的sql语句,其中一部分如何下ALTER DATABASE [DB_Comment] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [DB_Comment] SET ANSI_NULLS OFF
GO
ALTER DATABASE [DB_Comment] SET ANSI_PADDING OFF
GO我想使用declare @dbName nvarchar(100) set @dbName = 'DBComment'去替代上面代码的数据库名字,然后还要能够执行他们,代码怎么写?
谢谢!
GO
ALTER DATABASE [DB_Comment] SET ANSI_NULLS OFF
GO
ALTER DATABASE [DB_Comment] SET ANSI_PADDING OFF
GO我想使用declare @dbName nvarchar(100) set @dbName = 'DBComment'去替代上面代码的数据库名字,然后还要能够执行他们,代码怎么写?
谢谢!
,@cmd nvarchar(4000)set @cmd='ALTER DATABASE ['+@dbName+'] SET ANSI_NULL_DEFAULT OFF
ALTER DATABASE ['+@dbName+'] SET ANSI_NULLS OFF
ALTER DATABASE ['+@dbName+'] SET ANSI_PADDING OFF
'
exec (@cmd)