<div>
The syntax is <br />
<br />
IF @val1 = 0 and @val2 = 0.0 ...<br />
<br />
or you can just add up absolute values and then check the sum<br />
<br />
IF ( abs(@val1) + abs(@val2) + .... ) = 0.0
</div>


The syntax is

IF @val1 = 0 and @val2 = 0.0 ...

or you can just add up absolute values and then check the sum

IF ( abs(@val1) + abs(@val2) + .... ) = 0.0

<div>
@Jan_Franek:Thanks for the reply.<br />
I need to do this check before updating about 5 million records.<br />
How much time consuming is this process.<br />
Will it increase overall execution time.
</div>


@Jan_Franek:Thanks for the reply.
I need to do this check before updating about 5 million records.
How much time consuming is this process.
Will it increase overall execution time.

<div>
What exactly are you going to check ? Values in database table (5 million times 52 values) ? Or just stored procedure parameters (1 times 52 values) ?
</div>


What exactly are you going to check ? Values in database table (5 million times 52 values) ? Or just stored procedure parameters (1 times 52 values) ?

<div>
@Jan_Franek:Thanks for the reply.<br />
I am going to check &nbsp;values sent to the stored procedure.<br />
Since there are 5 million records I'll have to call the stored procedure &nbsp;(5 million times 52 values).<br />
Please help...
</div>


@Jan_Franek:Thanks for the reply.
I am going to check  values sent to the stored procedure.
Since there are 5 million records I'll have to call the stored procedure  (5 million times 52 values).
Please help...

<div>
<div class="content wysiwyg-content">
Hi Experts...<br />
I have around 52 values among which are half of them are of type int and the other half are float.<br />
I need to check whether all the integer values are 0 and all the float values are 0.0 which in this case i need to update the 52 columns as null.<br />
How can i easily check this condition.<br />
Is the syntax just to compare as follows: if( val==0 &amp;&amp;&nbsp;val2==0.0....and so on).<br />
Is ther an efficient way to do the same.<br />
Can anyone give syntax for the same.<br />
Please help...
</div>
</div>


Hi Experts...
I have around 52 values among which are half of them are of type int and the other half are float.
I need to check whether all the integer values are 0 and all the float values are 0.0 which in this case i need to update the 52 columns as null.
How can i easily check this condition.
Is the syntax just to compare as follows: if( val==0 && val2==0.0....and so on).
Is ther an efficient way to do the same.
Can anyone give syntax for the same.
Please help...

Checking conditions in Sybase Stored Procedure

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.

Sybase Database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.