Skip to content

Instantly share code, notes, and snippets.

@theorigin
Created September 27, 2013 09:39
Show Gist options
  • Save theorigin/6726253 to your computer and use it in GitHub Desktop.
Save theorigin/6726253 to your computer and use it in GitHub Desktop.
SQL table types - example of passing them to an SP
declare @p2 dbo.Dictionary
insert into @p2 values(N'orderReference',N'654')
insert into @p2 values(N'earliestRequestedDeliveryDate',N'2013-09-02')
insert into @p2 values(N'transactionId',N'123')
declare @p3 dbo.IndexedDictionary
insert into @p3 values(1,N'productCode',N'59510')
insert into @p3 values(1,N'orderedQty',N'1')
insert into @p3 values(2,N'productCode',N'62754')
insert into @p3 values(2,N'orderedQty',N'3')
insert into @p3 values(3,N'productCode',N'62754')
insert into @p3 values(3,N'orderedQty',N'200')
insert into @p3 values(4,N'productCode',N'62754')
insert into @p3 values(4,N'orderedQty',N'700')
insert into @p3 values(5,N'productCode',N'62754')
insert into @p3 values(5,N'orderedQty',N'95')
insert into @p3 values(6,N'productCode',N'62794')
insert into @p3 values(6,N'orderedQty',N'16')
exec Orders_CreateOrUpdate @OrderId='18C002FB-45A7-4301-9D01-D24983684B03',@OrderHeader=@p2,@OrderLines=@p3,@Username=N'WebApi'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment