June 22, 2006 at 10:59 am
If you run theis query, you get what you expect..
SELECT constid,
id,
colid,
status,
error
FROM Sysconstraints
If you run this query, you expect an error !!!. But guess what ..
SELECT constid,
id,
colid,
status
error
FROM Sysconstraints
I have removed the ',' after the 'Status' column. This should produce an Error. It does not. It does produce a data column shift.
Be Careful out there !!!
June 22, 2006 at 12:18 pm
results are the same in SQL Server 2000 and 2K5
June 23, 2006 at 7:12 am
SELECT constid,
id,
colid,
status
error
FROM Sysconstraints
is the same as:
SELECT constid,
id,
colid,
status AS error
FROM Sysconstraints
here error is treated as the alias of column of status.
September 24, 2006 at 1:53 am
This is not a Bug...if you are using 2 field names without comma (,) sql server assumes that second field is the ALIAS name of the first field
Philip
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply