Prev: Statistics from DTA
Next: Few confusing things about transactions
From: --CELKO-- on 6 May 2010 09:53
DECLARE @alert_flg CHAR(3);
SET @alert_flg = 'ALL';

then use a CASE expression in your code instead of sticking to a
procedural coding style:

CASE WHEN @alert_flg = 'ALL'
THEN -1 ELSE CAST (@alert_flg AS INTEGER) END

Casting from a string to an integer has problems.
First  |  Prev  | 
Pages: 1 2
Prev: Statistics from DTA
Next: Few confusing things about transactions