Issue Details (XML | Word | Printable)

Key: CORE-2079
Type: New Feature New Feature
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: Jiri Cincura
Votes: 2
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Support for table value parameters (TVPs)

Created: 12/Sep/08 05:44 PM   Updated: 19/Jul/09 04:01 PM
Component/s: Engine
Affects Version/s: None
Fix Version/s: None

Issue Links:
Duplicate
 


 Description  « Hide
MSSQL2k8 introduced neat feature called TVP. It's simply ability to put into variable rows and the work with it. This is extremely useful when you want to pass into and process more rows in SP.

Example:
create type testRow as table (id int, s nvarchar(200), y datetime);

create procedure testSP(@row testRow READONLY)
as
begin
  select id + 1, s from @row;
end

declare @myRow testRow;
insert into @myRow values (10, 'abc', CURRENT_TIMESTAMP);
insert into @myRow values (11, 'abc', CURRENT_TIMESTAMP);
exec testSP @myRow;

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.