How to declare arrray inside storedprocedure

Posted by Oswaldlily under ASP.NET on 6/4/2012 | Points: 10 | Views : 1773 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

How to declare arrry inside storedprocedure

In codebehind
function.Storedprocedure1(_invoiceNo, _pNo[], _Query[],_flag);

In StoredProcedure

Alter Procedure Storedprocedure1
(
_invoiceNo as nvarchar(20),
_pNo as ? ,
_Query as ? ,
_flag as nvarchar(20)
)

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Ndebata on: 6/4/2012 [Member] Starter | Points: 25

0	if you using SQL Server 2008 and above , you can pass a data table to store procedure. 1st create a table type in sql server Then use this new type as a readonly parameter. and you can use this parameter. and from dot not pass a datatable Oswaldlily, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts

How to get the exact property name while getting error (0)
PDB file is not showing Line Number in dot net application hosted on server (0)
Both Strings morethan 5 letters in length end of the words one vowel and one consonent is different (0)
how to check Any adjacent letters transposed between two strings(ex: JOHN, JHON) (1)
can't receive data after success login ? (1)
Implement Multi-Tenant in Azure Logic Apps (0)
Why ASP.Net Core 7.0 Web API showing as Connection refused? (0)
Iterating over columns of dataframe and print as rows in Python Django (0)
More ...