problem with comments using sql server studio 2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

problem with comments using sql server studio 2005

> Is it possible that
> the WHERE Clause
> ”where customer_number is null”
> is not satisfied,,, and the id was not updated ,,,, and the id Happened
to
> be 12345????
>
>
> On 8/4/07, wendyelizabeth via sql-server-l wrote:
> >
> >
> >
> > Andrew J. Kelly:
> >
> > I do not get an error message, the lines that are commented out are
> > executed.
> >
> > For example I have the following code:
> >
> > Update trans
> > set id = 1
> > where
> > customer_number is null
> >
> > — Update trans
> > — set id = 12345
> > — where
> > — customer_number is null
> >
> > After the sql statements are executed, the value for id = 12345.
> > Thus the lines of commented code are executed. They should not be.
> > The T-SQL experienced people at my company, noticed this problem on my
> > workstation before I did. They said the did not know what to do.
> >
> >
> > I can do the following: /* and */ and this area is commented out.
> >
> > Can you explain why the commented out code is executed?

Even I have tried and commented code is not executed, what edition of SQL you are running?

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |