Subscribe to this blog
Archives: July 2010
The Killer Backslash in TSQL
--it is
quite startling to see that this, in TSQL, executes.
Select \
/*
---------------------
0.00
(1
row(s) affected)
so does
this....
*/
Select null /\/\/\/\/\/\/\/\/\/\/\/ Read more
7 comments, 1,398 reads
Posted in Phil Factor's Phrenetic Phoughts: The SQL on 29 July 2010
Ambiguities and the wild object.oriented brigades
--Whilst trying to design a more effective way of detecting dependencies in a SQL Server database, I was mulling over the cruelty of SQL Server's parser in allowing this to compile and run..
create schema int
create table int.int (int int)
select int.int. Read more
0 comments, 679 reads
Posted in Phil Factor's Phrenetic Phoughts: The SQL on 29 July 2010