这段代码在查询分析器内已经通过,为何在Delphi内却报错!
if Exists(Select name from Sysobjects where name='Update_Glass_Stock_Count')
drop procedure Update_Glass_Stock_Count
go
Create Procedure Update_Glass_Stock_Count @aQuantity Float,@aDegree Char(11),@aType Char(20) as
Update Glass_Stock_Count set Count_Quantity=@aQuantity where Count_Degree=@aDegree and Count_Type=@aTypeDelphi中: Create_Procedure[0]:=
' if Exists(Select name from Sysobjects where name=''Update_Glass_Stock_Count'')'+
' drop procedure Update_Glass_Stock_Count '+
' go '+
' Create Procedure Update_Glass_Stock_Count @aQuantity Float,@aDegree Char(11),@aType Char(20) as'+
' Update Glass_Stock_Count set Count_Quantity=@aQuantity where Count_Degree=@aDegree and Count_Type=@aType';
if Exists(Select name from Sysobjects where name='Update_Glass_Stock_Count')
drop procedure Update_Glass_Stock_Count
go
Create Procedure Update_Glass_Stock_Count @aQuantity Float,@aDegree Char(11),@aType Char(20) as
Update Glass_Stock_Count set Count_Quantity=@aQuantity where Count_Degree=@aDegree and Count_Type=@aTypeDelphi中: Create_Procedure[0]:=
' if Exists(Select name from Sysobjects where name=''Update_Glass_Stock_Count'')'+
' drop procedure Update_Glass_Stock_Count '+
' go '+
' Create Procedure Update_Glass_Stock_Count @aQuantity Float,@aDegree Char(11),@aType Char(20) as'+
' Update Glass_Stock_Count set Count_Quantity=@aQuantity where Count_Degree=@aDegree and Count_Type=@aType';
解决方案 »
- 分享一篇CRC校验码生成的源代码
- 随意聊聊,顺便散分,关于企业即时通
- 用SHFileOperation进行文件拷贝,出现了一个小问题,请各位大虾们指教,谢谢!!^-^ ^-^ ^-^
- dxDbGrid中某一个字段设置成下拉框的形式,然后在onChange事件中写代码,但为什么不起作用呢?该怎么解决呢?急啊!
- 这里有温州的程序员吗?那边工作好找不?帮顶有分!
- 请教:SQL语句得写法(关于时间)
- 关于函数映射的问题,请赐教!!!!!
- 请教:触发器中使用取余函数MOD不成功的问题
- 如何取得所有网卡MAC
- 请教几个问题~困扰我很久了。
- dll建了窗体,但把dll窗体放在主程序panel上面不能按照panel的大小适应如何办?
- 100分——难道就没有高手指点我一下:TTS怎么发中文???分不够再加,搞了几天都没搞好!!!
' if Exists(Select name from Sysobjects where
name='+''''+'Update_Glass_Stock_Count='+''''+')'如果这样还不可以,你就用QuotedStr()来加'':
' if Exists(Select name from Sysobjects where
name='+QuotedStr(Update_Glass_Stock_Count)+')'