如何调用存储过程

Question

CREATE PROCEDURE cc 
@name nchar(50)
AS
   exec('select '+ @name+' from aa')
GO

Answer 1

create prodedure cc
@name nchar(50)
as
exec('select '+@name+' from aa')
goexec cc @name=a

Answer 2

CREATE PROCEDURE cc 
@name nvarchar(50)
AS
   exec('select  '+@name+' from aa')
GOVB调用：
cmd.commandtext="cc"
cmd.commandtype=adcmdstoredproc
set rs=cmd.execute(,"a")
print rs!a

Answer 3

CREATE PROCEDURE cc 
@name nvarchar(50)
AS
   exec('select  '+@name+' from aa')
GO
asp中调用：
set rs=server.CreateObject("adodb.recordset")
sql="exec cc a"