谁能帮我将以下SQL代码写成存储过程 马上送上100分！

[coollele]

SELECT ID, u_no, u_name, b_tel3, u_tel1, u_tel2, U_bank1, U_bank2, U_bank3, u_del, u_del1, u_del2, U_qc, U_fw
FROM huiyuan
WHERE (U_cs = 0) AND (u_del = 0)
ORDER BY u_no

[tcmakebest]

没见过如此没有技术含量的问题.

create procedure xxx
as 
SELECT     ID, u_no, u_name, b_tel3, u_tel1, u_tel2, U_bank1, U_bank2, U_bank3, u_del, u_del1, u_del2, U_qc, U_fw
FROM         huiyuan
WHERE     (U_cs = 0) AND (u_del = 0)
ORDER BY u_no

[还在加载中灬]

CREATE PROC PROCNAME
AS
SELECT     ID, u_no, u_name, b_tel3, u_tel1, u_tel2, U_bank1, U_bank2, U_bank3, u_del, u_del1, u_del2, U_qc, U_fw
FROM         huiyuan
WHERE     (U_cs = 0) AND (u_del = 0)
ORDER BY u_no 

我也来凑凑热闹

[卖水果的net]

-- 把那两个做成参数吧。
create procedure xxx(@U_cs int , @u_del int)
as 
SELECT     ID, u_no, u_name, b_tel3, u_tel1, u_tel2, U_bank1, U_bank2, U_bank3, u_del, u_del1, u_del2, U_qc, U_fw
FROM         huiyuan
WHERE     (U_cs = @U_cs) AND (u_del = @u_del )
ORDER BY u_no

[还在加载中灬]

CREATE PROC PROCNAME
AS
SELECT     ID, u_no, u_name, b_tel3, u_tel1, u_tel2, U_bank1, U_bank2, U_bank3, u_del, u_del1, u_del2, U_qc, U_fw
FROM         huiyuan
WHERE     (U_cs = 0) AND (u_del = 0)
ORDER BY u_no 

我也来凑凑热闹

[t101lian]

create procedure Pro_select_huiyuan(@U_cs int , @u_del int)
as 
SELECT     ID, u_no, u_name, b_tel3, u_tel1, u_tel2, U_bank1, U_bank2, U_bank3, u_del, u_del1, u_del2, U_qc, U_fw
FROM         huiyuan
WHERE     (U_cs = @U_cs) AND (u_del = @u_del )
ORDER BY u_no

直接复制过去用 ， 传了两个参数

[sddcs]

学习了

[kobe_lai]

create procedure xxx
	as
	SELECT ID, u_no, u_name, b_tel3, u_tel1, u_tel2, U_bank1, U_bank2, U_bank3, u_del, u_del1, u_del2, U_qc, U_fw
	FROM  huiyuan
	WHERE (U_cs = 0) AND (u_del = 0)
	ORDER BY u_no

[C_B_Lu]

为什么要写成存储过程？ 楼主想达到怎样的效果？

[老张一笑]

有语句的都给分,别给我,给我跟你急;