Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 table type

Author  Topic 

TajKazi
Posting Yak Master

101 Posts

Posted - 2014-12-05 : 01:00:53
can we retrieve data from table type variable as an array in oracle key values..

eg.

ALTER PROCEDURE prn1( @p_prn as KeyValuePair readonly)
-- proc which having parameter table type as parameter

AS
declare @v_formatted_str varchar(50)
BEGIN
set @v_formatted_str = v_formatted_str + @p_prn(1)(1)
END

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2014-12-05 : 11:54:38
This is a Microsoft SQL Server forum. You are likely to get faster and better responses at an Oracle forum.
Go to Top of Page

TajKazi
Posting Yak Master

101 Posts

Posted - 2014-12-08 : 00:14:43
actually i need this concept in MS SQL Server... means can we have to use table type variabale as any array
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2014-12-22 : 08:14:21
This may help you http://blog.sqlauthority.com/2008/08/31/sql-server-table-valued-parameters-in-sql-server-2008/

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -