----查看数据库中是否存在某一数据库CREATE PROCEDURE dbname
@name varchar(50) as
begin
if (
select count(*) as co
from master.dbo.sysdatabases where name=@name
)=1
select 'SQL中存在'+'<'+@name+'>'+'数据库'
else
select 'SQL中不存在'+'<'+@name+'>'+'数据库'end
exec dbname a
@name varchar(50) as
begin
if (
select count(*) as co
from master.dbo.sysdatabases where name=@name
)=1
select 'SQL中存在'+'<'+@name+'>'+'数据库'
else
select 'SQL中不存在'+'<'+@name+'>'+'数据库'end
exec dbname a
into @exist
from sysobjects
where xtype = 'u' and name = 'table-name'if @exist >0 ....
begin
select @where1
exec ('select * into '+ @TableName+' from CDR where 1<>1')
end
如:declare @cSql Varchar(200)
Select @cSql='select * into '+@TableName+'From CDR Where 1<>1'
Exec(@cSql)
to 欧乐:exec ('select * into '+ @TableName+' from CDR where 1<>1') 单独执行没有问题的
@Msg int OUTPUT,
@tablename VARCHAR(50))
AS
IF EXISTS (SELECT name FROM sysobjects
WHERE name = @tablename AND type = 'U')
begin
set @Msg=1
end
else begin
set @Msg=0
end
OBJECTPROPERTY (object_id(@TableName),'ISTABLE') =1
可是当@TableName不存在
OBJECTPROPERTY (object_id(@TableName),'ISTABLE') =0 或<>1 !=1 都得不到结果用old_brother的方法解决了,马上结贴
drop table [dbo].[tabX]
GOCREATE TABLE [dbo].[tabX] (
[dept_no] [varchar] ,
[person_no] [varchar] ,
..................GO