patternMinor
Are there tools for SQL-Server helping to add the semicolons?
Viewed 0 times
helpingthearesqltoolsforservertheresemicolonsadd
Problem
Earlier versions of SQL-Server didn't recommend the use of semicolons to terminate sql-statements.
Beginning with sql-server-2008 examples show, that now Microsoft recommends terminating with semicolons.
There are some formating tools which format sql queries and add the semicolons. I think the basic function is somewhere in SMO.
The only problem is that these tools remove all the comments.
Any ideas how to preserve all comments and how to add all recommend semicolons?
Beginning with sql-server-2008 examples show, that now Microsoft recommends terminating with semicolons.
There are some formating tools which format sql queries and add the semicolons. I think the basic function is somewhere in SMO.
The only problem is that these tools remove all the comments.
Any ideas how to preserve all comments and how to add all recommend semicolons?
Solution
Start typing and don't trust code generators.
As you bring up procedures and code to edit it for other reasons, just add the semi-colon in then. You wouldn't want to deploy all your stored procedures in one batch just to add in the semi-colons only.
As you bring up procedures and code to edit it for other reasons, just add the semi-colon in then. You wouldn't want to deploy all your stored procedures in one batch just to add in the semi-colons only.
Context
StackExchange Database Administrators Q#146, answer score: 4
Revisions (0)
No revisions yet.