一个简单的删除数据的存储过程问题，对您不能，对我很难，帮帮我吧！！！

[czh157]

我在删除数据时编写了如下存储过程：
CREATE PROCEDURE zj_DelChildrenLink @ID int
AS
delete * from zj_friendlink where id=@ID
return
GO
但程序老是说语法错误

小弟困惑之极

还望各路高手能指点迷津

感激不尽！

[helodd]

有什么错呢？

[sdhdy]

就你写的而言，应该没什么错误！

[Mansan]

应该是delete from zj_friendlink where id=@ID 吧

[51study]

这又不是DOS,不能用delete * from..，只能用的delete from zj_friendlink where id=@ID.
再说“delete * from zj_friendlink where id=@ID“,逻辑也不对，既然是delete *，怎么还会有where条件选择。

[westbulls]

delete * from zj_friendlink where id=@ID

改为:
delete zj_friendlink where id=@id

[cloudchen]

delete * from 是access

sql用delete from

[47522341]

同意，

delete from zj_friendlink where id=@id

[meigo]

借问一下:为什么要用return呢

[srz007]

delete 和from之间加表名试一下呢?

[lovecsdndog]

delete from 就行了吧。各位，搞那么麻烦干嘛？

[chenyang157]

delete from zj_friendlink where id=@id

没意见！

[playyuer]

没 *
delete * from t 是 Access (Jet SQL) 语法!

[dgljf]

是:
delete from zj_friendlink where id=@id

delete * from t 是不是也是 VFP 语法呢?

[angelgundam]

阁下的原意是要删除全部符合条件id=@ID的内容吧，可是通配符*不能用在delete语句里，您可能误解了。没错，在查询语句select中要查询全部符合某种条件的时候，它的语法是：
select *
from <表名1>，<表名2>，……
[where <条件>]
但是，若要删除符合某种条件的记录，你只需要这样写：
delete
from <表名1>,<表名2>,……
[where <条件>]
就可以了。
所以只需要将您代码改成这样：
delete
from zj_friendlink
where id=@ID
就可以了。

[maoyesky]

CREATE PROCEDURE zj_DelChildrenLink @ID int
AS
delete zj_friendlink where id=@ID

或

CREATE PROCEDURE zj_DelChildrenLink @ID int
AS
delete from zj_friendlink where id=@ID

[cyw359764840]

*号不要加上去啊 不错才怪