Pass Table value parameter to Stored Procedure in SQL Server

nauna

SOLVED CLOSED ACTIVE ANSWERED
User: nauna
Posted: on Oct 06, 2017 04:30 AM
Forum: SQL Server
Answer: 1
Views: 2204

write a stored procedure called ups_getpricelist with a parameter @sku that stores the skus for which the prices are to be listed. @sku has the table type skunotyp whcih created with this statemet

Create type skuNoType as table (sku int);

complete this partial code for the stored procedure

create procedure usp_getpricelist 
    @skus skuNoType readonly 
as
begin
    declare skucursor Cursor 
    select sku from @skus
end

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 3

Reply
ANSWER
User: dharmendr
Replied: on Oct 09, 2017 06:15 AM
Report

Hi nauna,

I have created as per your explained step and checked.

SQL

Create type skuNoType as table (sku int)
GO
Create procedure usp_getpricelist 
	@skus skuNoType readonly 
as
begin

	--declare skucursor Cursor 
	select sku from @skus
end
GO
declare @mySkus skuNoType
insert into @myskus values (1), (10), (2)
exec usp_getPriceList @mySkus

DROP PROC usp_getpricelist
DROP type skuNoType

OutPut

sku

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Pass Table value parameter to Stored Procedure in SQL Server

Company

Explore

Follow us

Contact Us