摘要:
SELECT 'EXEC sys.sp_addextendedproperty @name=N'||chr(39) ||'MS_Description'||chr(39) ||', @value=N'||chr(39)||COMMENTS||chr(39)||', @level0type=N'||c... 阅读全文
摘要:
if exists ( select * from dbo.sysobjects where id = object_id(N'[dbo].[TableSpace]') and objectproperty(id, N'IsUserTable') = 1 ) drop table [dbo].[T... 阅读全文
摘要:
--查询相同数据select [字段名]或[*]from [表名称1]intersectselect [字段名]或[*]from [表名称2]--查询不同数据select [字段名]或[*]from [表名称1]exceptselect [字段名2]或[*]from [表名称] 阅读全文