2008导出脚本在2000运行出错 是一个创建表的脚本 我直接用2008导出的在2000出错 怎么办 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 例如USE [xxx]GO/****** Object: Table [dbo].[test] Script Date: 12/15/2010 09:09:19 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[test]( [id] [int] IDENTITY(1,1) NOT NULL, CONSTRAINT [PK_test] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GO WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]这个问题 但像这些也不行EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'mall_bill', @level2type=N'COLUMN',@level2name=N'f_order'GO 一个很菜鸟的问题 大家好 下面是我总结出的有关SQL SERVER的所有语句 希望大家能给于修改 请多多指教 多表连接,有些表有记录,有些表无记录,都要显示。 扩库,设备建好了,现在想换设备的路径,怎么改 如何用SQL写出明细交易对帐单报表?谢谢了。!! 求一简单触发器!在线等待 数据表的关系问题 SQL语句中含有单引号怎么办? 请问TOP后面怎么样加变量? 求教。怎样删除一个SQL SERVER文件 sql查询 如何提取一个字段的备注信息
GO/****** Object: Table [dbo].[test] Script Date: 12/15/2010 09:09:19 ******/
SET ANSI_NULLS ON
GOSET QUOTED_IDENTIFIER ON
GOCREATE TABLE [dbo].[test](
[id] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PK_test] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]GO
GO