SQL Documenting is Not working
I read on the internet that on SQL you can use "--" or "#" for Documenting - to ignore everything that comes after that mark (like ' in VB or // in C). Yeah, cool, but its not working. I opened up an IIS server and built a simple .asp file that contain sql commands and among them this line :
R.Open "Select * from [Test]"
Yup, the asp is worknig. but when i change this line to one of this lines :
R.Open "Select * from [Test]#BLA"
R.Open "Select * from [Test]--BLA"
Its not working.
I tried with spaces etc. Still not working
Why? Any solution?