标题: 为什么用记事本打开罗斯文的那个SQL文档会出现这样子，红色部份正常吗?因为这样，所 [打印本页] 作者: ququ 时间: 2004-3-13 19:33 标题: 为什么用记事本打开罗斯文的那个SQL文档会出现这样子，红色部份正常吗?因为这样，所 Create Procedure "各年销售额"
@起始日期 datetime, @终止日期 datetime
AS
SELECT 订单.发货日期, 订单.订单ID, 订单小计.小计,
DATENAME(yy,发货日期) AS 年份
FROM 订单 INNER JOIN 订单小计 ON 订单.订单ID = 订单小计.订单ID
WHERE 订单.发货日期 Is Not Null And 订单.发货日期 Between @起始日期 And @终止日期
GO
GRANT EXECUTE ON "dbo"."十种最贵的产品" TO "public"
GO
GRANT EXECUTE ON "dbo"."各国雇员销售额" TO "public"
GO
GRANT EXECUTE ON "dbo"."各年销售额" TO "public"
GO
set quoted_identifier on
go
set identity_insert "dtproperties" on
go
ALTER TABLE "dtproperties" NOCHECK CONSTRAINT ALL
go
INSERT "dtproperties"("id","objectid","property","value","lvalue","version") VALUES( 1, 1,'DtgSchemaOBJECT',NULL,NULL, 0)
go
INSERT "dtproperties"("id","objectid","property","value","lvalue","version") VALUES( 2, 1,'DtgSchemaGUID','{EA3E6268-D998-11CE-9454-00AA00A3F36E}',NULL, 0)
go
INSERT "dtproperties"("id","objectid","property","value","lvalue","version") VALUES( 3, 1,'DtgSchemaNAME','关系',NULL, 0)
go
INSERT "dtproperties"("id","objectid","property","value","lvalue","version") VALUES( 4, 1,'DtgDSRefBYTES','704',NULL, 0)
go
INSERT "dtproperties"("id","objectid","property","value","lvalue","version") VALUES( 5, 1,'DtgDSRefDATA',NULL,0xDBE6B0E91C81D011AD5100A0C90F5739000002008050E5C4B34DBE01020200001048050000000000000000000000000000000000A2010000500072006F00760069006400650072003D00530051004C004F004C004500440042002E0031003B0055007300650072002000490044003D00730061003B0049006E0069007400690061006C00200043006100740061006C006F0067003D004E006F00720074006800770069006E006400430053003B004400610074006100200053006F0075007200630065003D007000720063006100630063003B004C006F00630061006C00650020004900640065006E007400690066006900650072003D0032003000350032003B0043006F006E006E006500630074002000540069006D0065006F00750074003D00310035003B005500730065002000500072006F00630065006400750072006500200066006F007200200050007200650070006100720065003D0031003B004100750074006F0020005400720061006E0073006C006100740065003D0054007200750065003B005000610063006B00650074002000530069007A0065003D0034003000390036003B0057006F0072006B00730074006100740069006F006E002000490044003D0050005200430041004300430031003700000000800500060000007351FB7C000000022600080000009B4F945E4655000008000000640062006F00000000022600060000007B7C2B52000008000000640062006F0000000002260006000000A74EC154000008000000640062006F000000000226000A000000A28B55530E66C67E000008000000640062006F0000000002260006000000C7965854000008000000640062006F0000000002260006000000A28B5553000008000000640062006F0000000002260006000000A25B3762000008000000640062006F0000000002240008000000D08F278D4655000008000000640062006F000000, 0)
go
INSERT "dtproperties"("id","objectid","property","value","lvalue","version") VALUES( 6, 1,'DtgSchemaBYTES','13312',NULL, 0)
go
INSERT "dtproperties"("id","objectid","property","value","lvalue","version") VALUES( 7, 1,'DtgSchemaDATA',NULL,0xD0CF11E0A1B11AE1000000000000000000000000000000003E000300FEFF0900060000000000000000000000010000000100000000000000001000000200000001000000FEFFFFFF0000000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFDFFFFFF14000000FEFFFFFF0400000005000000060000001500000008000000090000000A0000000B0000000C0000000D0000000E0000000F0000001000000作者: zhuyiwen 时间: 2004-3-14 06:26
这些是二进制数据,应该是没问题的作者: ququ 时间: 2004-3-14 21:59 标题: 出错这种情况是哪里错了? [attach]3888[/attach]作者: zhengjialon 时间: 2004-3-15 16:10
代码是正常的，超过64K的只能通过ADO来操作。作者: hualonglan 时间: 2008-10-23 06:16
看看，学习学习作者: sheandme0 时间: 2008-10-23 19:30
哦？？？