Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Long Sql statement and concatenation

Author  Topic 

Pinto
Aged Yak Warrior

590 Posts

Posted - 2005-04-01 : 05:13:05
I expect this is so basic I am embarassed to ask......

If I want to show a long sql statement on more than one line in asp.net how do I concatenate the lines ? I have tried this and it says I have a syntax error.

Dim mySQL as string = "SELECT Id,Status, Name from tblPeople "_
+ "WHERE Name = 'Jones' "_
+ "and Status = 5 "_
+" ORDER BY Id"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-04-01 : 05:34:15
instead of _ try & _

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -