Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

how i can check wether a value is there or not in a stored procedure

4 Posts 2 Posters 0 Views 1 Watching

J Offline
J Offline
jagan123

wrote on last edited by

#1

iam sending a null value to the stored procedure .how i can check in if loop of the stored procedure wheter the send value is null or something
Y 1 Reply Last reply

0
J jagan123

iam sending a null value to the stored procedure .how i can check in if loop of the stored procedure wheter the send value is null or something
Y Offline
Y Offline
YeHtut

wrote on last edited by

#2

IF @Value IS NULL -- print 'This is null value' ElSE -- print 'Some Value'
J 1 Reply Last reply

0
Y YeHtut

IF @Value IS NULL -- print 'This is null value' ElSE -- print 'Some Value'
J Offline
J Offline
jagan123

wrote on last edited by

#3

can write is not null if value is there
Y 1 Reply Last reply

0
J jagan123

can write is not null if value is there
Y Offline
Y Offline
YeHtut

wrote on last edited by

#4

Yes, can be write.
1 Reply Last reply

0

Log in to reply