General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2005
>>In SQL 20005 Mangement Studio, I can right click on a database and create a new query. ...
>>
>>Is there a way to automatically format a SQL statement into a multiple lines. With the Selec one 1 line, then where on the next etc...
>
>Hi Evan,
>
>No, it's not available. I think it's on the list of developer-requested improvements though.
Thanks for letting me know.
>Try writing your query inside a Text...EndText block and you can easily paste back and forth between Fox and SSMS.
I can't tell from the VFP help, but if I use TEXT/ENDTEXT how do I insert string variables inline? Right now, my SQL statements will look like this in VFP.
lcSQL = "SELECT * FROM customers WHERE id = " + str(lncustid) + " ORDER BY name "
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only