alter database necinfo
set ANSI_NULLS ON,
CONCAT_NULL_YIELDS_NULL ON,
ANSI_WARNINGS on,
ARITHABORT on,
ANSI_PADDING on
select DATABASEPROPERTYEX( 'necinfo' , 'IsAnsiPaddingEnabled' ) as IsAnsiPaddingEnabled
select DATABASEPROPERTYEX( 'necinfo' , 'IsAnsiPaddingEnabled' ) as IsAnsiPaddingEnabled
select DATABASEPROPERTYEX( 'necinfo' , 'IsNullConcat' ) as IsNullConcat
select DATABASEPROPERTYEX( 'necinfo' , 'IsAnsiWarningsEnabled' ) as IsAnsiWarningsEnabled
select DATABASEPROPERTYEX( 'necinfo' , 'IsAnsiPaddingEnabled ' ) as IsAnsiPaddingEnabled
1. sp_dboption [ [ @dbname = ] 'database' ]
[ , [ @optname = ] 'option_name' ]
[ , [ @optvalue = ] 'value' ]
2.alter database
set <sql_option> on/off这样可以用DATABASEPROPERTYEX( database , property )这个函数来查看设置的值.
alter database necinfo
set ANSI_NULLS ON,
CONCAT_NULL_YIELDS_NULL ON,
ANSI_WARNINGS on,
ARITHABORT on,
ANSI_PADDING on