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

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.

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. 

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.

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.