写个存储过程。。if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[#tmp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[#tmp]
GOCREATE TABLE [dbo].[#tmp] (
[a] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ac] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
drop table [dbo].[#tmp]
GOCREATE TABLE [dbo].[#tmp] (
[a] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ac] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
解决方案 »
- org.apache.jasper.JasperException: Unable to compile class for JSP:
- Oracle service bus 有人会吗?
- 跪拜求救:was not processed by flush()
- web传参问题
- 求一个正则表达式,只包含"-,数字"这3个。
- 连动下拉框的问题
- struts中用smartupload上传文件问题--死循环
- 忽忽学校选专业课(关于我一生的大事)都进来帮忙拿主意蛤
- 如何获取一个url多次跳转之后的url
- 使用了ResourceBundle后springboot的配置不生效
- 作MailingList请指教!!!在线等待!
- db2可以输入中文吗?
drop table [dbo].[#tmp]
GOCREATE TABLE [dbo].[#tmp] (
[a] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ac] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
drop table [dbo].[#tmp]
GOCREATE TABLE [dbo].[#tmp] (
[a] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ac] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO