Confused Results
JDS
Posts: 25
Not sure if there is anything can be done about this but if the following query is executed
IF db_name() = '10063'
select 4,5,6
select 1,2,3
I get these results back
Results 1
DBCLUS1VSQL1\PROD01 10048 1 2 3
DBCLUS1VSQL1\PROD01 master 1 2 3
DBCLUS1VSQL2\PROD02 10063 4 5 6
Results2
DBCLUS1VSQL2\PROD02 10063 1 2 3
IF db_name() = '10063'
select 4,5,6
select 1,2,3
I get these results back
Results 1
DBCLUS1VSQL1\PROD01 10048 1 2 3
DBCLUS1VSQL1\PROD01 master 1 2 3
DBCLUS1VSQL2\PROD02 10063 4 5 6
Results2
DBCLUS1VSQL2\PROD02 10063 1 2 3
Comments
I've run this script in both SQL Multi Script and SMMS. Both return the result you stated.
What results were you expecting to see?
Cheers,
--
Daniel