Hai,
I was trying a couple of queries and the result in the rowcount is very confusing.
The queries I were trying are the following:-
1> select * from Ir_lot_track
2> where ir_nbr=14401 and sterile_batch_nbr=null
3> and status_code=9
4> go
ir_nbr sterile_batch_nbr item lot_nbr ops_seq ops_nbr
ops_station date_time_in assoc_code_in
date_time_out assoc_code_out time_delay status_code
qty_in qty_out
comments
assoc_code_upd date_time_upd
----------- ----------------- ---------------- ---------- ------- -------
----------- -------------------------- -------------
------ -------------- --------------------------
(0 rows affected)
Second query:-
3> where ir_nbr=14401 and sterile_batch_nbr=null
4> and status_code=9
5> go
(1 row affected)
2> go
-----------
1
(1 row affected)
Basically, both my queries are same except for the fact that I am
introducing a variable in the second query. However, my second
query seems to be returning " I row affected" which I think might be
due to the using of a variable. I guess its returning null as a row
affected. Can someone please explain whats happening here?
If I dont want this to hapen
IS there a way to explicitly say in the where clause that the
value to be checked " is numeric or something similar" and null is not be
counted while doing the checking?
Thankyou. Any suggestions or comments will be very helpful
vishu
--
The road to success is presently under construction.