IF EXISTS (SELECT name FROM sys.sysdatabases WHERE name = 'dba')
BEGIN
use dba
end当dba不存在时,提示错误
Could not locate entry in sysdatabases for database 'shangchao'. No entry found with that name. Make sure that the name is entered correctly.
为什么提示这个啊? 请大家不吝赐教啊。
BEGIN
use dba
end当dba不存在时,提示错误
Could not locate entry in sysdatabases for database 'shangchao'. No entry found with that name. Make sure that the name is entered correctly.
为什么提示这个啊? 请大家不吝赐教啊。
IF EXISTS (SELECT name FROM sys.sysdatabases WHERE name = 'dba')
这不是已经做判断了,为什么还执行 use dba
呢
搞不好 是 Transact-SQL你跟他讲 mysql
或者mssql
Transact-SQL还不知道是什么呵呵
BEGIN
execute(N'use dba')
end
上面有例子 没啥问题