创建一个名称为cour_name的存储过程,可以查询任意课程名的课程的详细信息,使用( )语句。
A.
create proc cour_name @name as select * from course where cname=@name go
B.
create proc cour_name name varchar(10) as select * from course where cname=name go
C.
create proc cour_name @name varchar(10) as select * from course where cname=@name go
D.
create proc cour_name @name int as select * from course where cname=@name go