Parameter validation in sql server stored procedure

tsakumar...

SOLVED CLOSED ACTIVE ANSWERED
User: tsakumar81
Posted: 7 hours ago
Forum: ASP.Net Web Forms
Answer: 1
Views: 64

I have defined a parameter in sql server stored procedure as @Grade varchar(3) and implemeted validation as

IF len(@Grade)>3
BEGIN 
    SET @ErrMessage = "number of characters cannot be grater than 3" 
END

While executing the stored procedure I pass parameter as @Grade = 'ABCD' but no error message is thrown and 3 characters are inserted into the database.

Please advise how to throw a error message in case if it is more than 3 characters.

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

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: 7 hours ago
Report

Hi tsakumar81,

The DataType is specified as VARCHAR having length 3.

So when you pass characters more than 3, automatically it passed 3 characters by skipping all the others.

LEN function always returns 3 or less than 3. It never returns greater than 3.

So in order to validate you need to check the length from code behind and display the error message.

Once success, pass the value having 3 or less than 3 characters to the Stored procedure.

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

Description

Description is required.

Parameter validation in sql server stored procedure

Company

Explore

Follow us

Contact Us