tag:blogger.com,1999:blog-6369017162723772053.post5140587888926244922..comments2017-07-06T12:16:01.626+03:00Comments on The SQL Server and .NET Hub: Using the "GO" Command in SQL ServerArtemakis Artemiou [MVP]http://www.blogger.com/profile/11342421189098310902noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-6369017162723772053.post-34706627562890291372009-09-25T19:41:29.923+03:002009-09-25T19:41:29.923+03:00The behavior of "RETURN" is worth noting...The behavior of "RETURN" is worth noting as well.<br /><br />In SSMS, "RETURN" works within a batch when executing code on screen, but then SSMS will continue executing subsequent batches.<br /><br />I believe this behavior also extends into SQLCMD and the ":R" command, where it becomes a bit more confusing. This is because there may well be more than one "Unknownhttps://www.blogger.com/profile/02967808255432607665noreply@blogger.comtag:blogger.com,1999:blog-6369017162723772053.post-66749102584744673592009-09-14T22:24:16.041+03:002009-09-14T22:24:16.041+03:00Hi Allan,
Unfortunately this is not possible beca...Hi Allan,<br /><br />Unfortunately this is not possible because the GO command is not a T-SQL statement but rather a command which signals the end of a batch of Transact-SQL statements to the SQL Server utilities.<br /><br />From MSDN BOL: "A Transact-SQL statement cannot occupy the same line as a GO command. However, the line can contain comments."<br /><br />Link: http://Artemakis Artemiou [MVP]https://www.blogger.com/profile/11342421189098310902noreply@blogger.comtag:blogger.com,1999:blog-6369017162723772053.post-83795269730118165702009-09-14T19:51:27.781+03:002009-09-14T19:51:27.781+03:00Is it possible to insert some special character in...Is it possible to insert some special character into the SQL Statement to allow for the GO Command to be on a single line?<br /><br />I need to place my sql statements into a single excel cell to have them run properly with an interface I use, and the statements use a go command.Unknownhttps://www.blogger.com/profile/01724283430703236444noreply@blogger.com