حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

Pass (Send) parameter to IN operator in stored procedure in SQL Server

SajidHus...

SOLVED CLOSED ACTIVE ANSWERED
User: SajidHussa
Posted: on Aug 24, 2021 03:15 AM
Forum: SQL Server
Answer: 1
Views: 1861

pass IN Query in SQL Procedure not work

create procedure usp_get_item
@sid varchar(100),
@ccount int
as
select pid,count(*) from test
where sid in(@sid)
group by pid
having count(*)=@ccount
go

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

dharmend...

0 2

Reply
ANSWER
User: dharmendr
Replied: on Aug 24, 2021 03:50 AM
Report

Refer below article.

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

Contact Us

Email: webmaster@aspsnippets.com
Address:
ASPSNIPPETS PRIVATE LIMITED
G-110, SHAGUN ARCADE,
MALAD (EAST),
MUMBAI, MAHARASHTRA,
INDIA 400097.

Pass (Send) parameter to IN operator in stored procedure in SQL Server

Pass comma separated (delimited) values as Parameter to Stored Procedure in SQL Server

Company

Explore

Follow us

Contact Us