Can we pass view as a input paramater in SQL Stored procedur

Question

I want to pass view as a input parameter in stored procedure ? How to pass view as a input parameter in stored procedure ?

Nitin Sontakke · Answer

Natively, for a stored procedure parameter, all sql server really understands is actually String. How big is the table? How many rows? How many columns? Typically, if it is not too much of the data, I just send a twice delimited string and create a table out of it in stored procedure. For example: 1,dddd,45|2,eee,89|3,fff,34 Here comma works as a column separator and pipe works as a row separator.

Sanket Jain · Answer

I want to pass table in SP ,so I used user defined table. But it doesn't work in Linked server. So I write a view where I retreived data thru view and pass as a input parameter . My requirement is : User is sending table and 2 varchar type data as a input parameter in stored procedure. And I want some validation in tables value, if data validate successfully then I want to insert this data into my table.

Nitin Sontakke · Answer

Much better if you tell us what exactly you are trying achieve. You have already decided some solution and asking if it can be done. Instead, please share the problem so a solution can be provided.

Manas Tripathi · Answer

Better option is to use the view(s) based on a parameter. Pass view name in parameter and use it either in case statement or make SQL string.

Chirag Khabaria · Answer

No, I dont think you can pass the view to to the SP. Probably the best way to will be pass the view name and then you can run the dynamic SQL to process the view records.

Can we pass view as a input paramater in SQL Stored procedur

Answers (5)