passing multiple parameters with table valued parameter to stored procedure

Question

0.00/5 (No votes)

See more:

, +

Can we Pass table valued parameters and normal params like integer,varchar etc..to a single stored procedure?If we can then how to pass them? I currently have the following

ALTER PROCEDURE InsertData
(
@slno nvarchar(255),
@OrderNo nvarchar(255),
@M3 M3 READONLY
)

when i pass params from front end it gives me error " String or binary data would be truncated.The data for table-valued parameter "@M3" doesn't conform to the table type of the parameter.The statement has been terminated."

Posted 5-Feb-14 19:53pm

pwavell

Updated 9-Jun-20 5:29am

Add a Solution

Comments

Dnyaneshwar Kondbale 6-Feb-14 2:10am

@slno and @OrderNo you defined as nvarchar(255), kindly check the length of the both it may be more than 255 ,or you defined M3 as type on your database kindly check the value pass for M3 having more length more than you defined.

" String or binary data would be truncated " Error occured when you try to pass or assing value
to some parameter with more than length defined for that parameter.

pwavell 6-Feb-14 2:17am

@slno and @OrderNo length is ok.and M3 is a table type.actuly the syntax is ( @M3 M3 READONLY )and i have wriiten slno and orderno inside braces becoz if written outside braces the procedure doesnt compile.Is that the issue?

Dnyaneshwar Kondbale 6-Feb-14 2:24am

no thats not issue.. I jst want to know you defined Type M3 in your Database , so at the time time of M3 defination you write like a as varchar(30).. n all.. I think issue you get is in M3 defination and value passed for the M3.

Saurabh_Tiwari 9-Jun-20 13:56pm

@pwavell Could you please share the table type definition and the C# code used to call the stored procedure.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Er. Ajay Chauhan · Answer 1 · 2014-02-05T20:05:00

Solution 1

what is @M3 M3 READONLY here...??

Posted 5-Feb-14 20:05pm

Er. Ajay Chauhan

Comments

pwavell 6-Feb-14 2:12am

M3 is a table type and @M3 is its instance.Its a table valued parameter.i m sending @M3 from front end.

Er. Ajay Chauhan 6-Feb-14 2:23am

is M3 supported by SQl Server....?? as far as I knew that there is no datatype of M3 in SQl Server....

pwavell 6-Feb-14 4:17am

its a user defined type