Calling CLR stored procedure

Question

Possible Duplicate:
Invoking CLR stored procedures

Does anybody know how to call a CLR stored procedure using select statement?

have a look at MSDN (http://msdn.microsoft.com/en-us/library/ms123401.aspx) — lboshuizen, Oct 18 '12 at 11:59
http://stackoverflow.com/q/1641833/1731716 hope this will help you! — Saasu Ganesan, Oct 18 '12 at 12:01
You don't `SELECT` from a stored procedure - T-SQL or CLR; stored procedure are meant to be **executed** using `EXEC` or `sp_execute` .... — marc_s, Oct 18 '12 at 12:01

score 3 · Accepted Answer · answered Oct 18 '12 at 11:56

3

As far as I know it's not possible without OPENQUERY or OPENROWSET, you'd better use CLR table function. If you need to insert data from stored procedure

insert into Table
exec <your CLR procedure>

answered Oct 18 '12 at 11:56

Roman Pekar

107,110
28
195
197

The SP accepts 2 parameters and inserts some values into a table. When I excute, it is returning 0 and not inserting into table. So pls let me know how to call it. – Shami C Oct 18 '12 at 12:12
well your table schema should be exactly the same that schema of rowset returned by stored procedure. you can pass parameters into procedure by `exec = value ` – Roman Pekar Oct 18 '12 at 12:15

Calling CLR stored procedure

1 Answers1