In SQL Server 2008, I know I can declare variables as follows:
DECLARE @var INT = 1;
DECLARE @var INT;
SET @var = 1;
Is the first example ANSI compliant? just wondering in case we ever have to port some code. Also, since this is really the first time I've had to concern myself with ANSI SQL standards, what's the best way to stay informed of them?
Kind of a noob question, I know, but your input is appreciated. Clint
View Complete Post