类似于这样
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FA_Report]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[FA_Report]
else
print 'Not Exists'
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FA_Report]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[FA_Report]
else
print 'Not Exists'
那个东西非常有用,不只是解决你现在这个问题!!
SELECT * into #t
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source=c:\t1.xls;User ID=Admin;Password=;Extended properties=Excel 5.0')...[Sheet1$]
t1.xls中只有一列,,我想在#t中可以多个列
比如:ID VALUE STATE
把t1.xls中那一列放到VALUE中,,其他的ID,STATE是自动或者默认
value as value,-- t1.xls中的那一列
null as state -- 纯粹是占位
into #t
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source=c:\t1.xls;User ID=Admin;Password=;Extended properties=Excel 5.0')...[Sheet1$]
这样写好象有错误哦!!
identity(1,1) as ID和value as value这里会不会有错误!!
as Value 是别名!!你试验一下!!
select type='33'
和
select '33' as type
有什么区别
select identity(int,1,1) as id into t1
和
select id=identity(int,1,1) into t1
的区别