Activity overview
Latest activity by Uji2
Syntax coloring for LEAD() and LAG() functions
Can you please add syntax coloring for LEAD() and LAG() functions in SQL Prompt. You have it for all the other windowing functions, but for some reason not these two. It looks really odd when they ...
Now we're talking! Unchecking "ignore white space" did the trick with stored procedures. I was even able to edit the table scripts - it didn't keep the formatting of the actual table definition but it kept the comments at the top and the if exists/drop statement. / comments
Now we're talking! Unchecking "ignore white space" did the trick with stored procedures. I was even able to edit the table scripts - it didn't keep the formatting of the actual table definition bu...
Yeah it will work, but it's a bummer that the scripts themselves can't really be edited. It would be a really cool feature to be able to edit the scripts and have the ability in the commit dialogue to sync the db code with the script. So in the Commit screen where it has the Database Version -> Latest Source Control Version, it would be nice if you could reverse that arrow and push your changes the other way. / comments
Yeah it will work, but it's a bummer that the scripts themselves can't really be edited. It would be a really cool feature to be able to edit the scripts and have the ability in the commit dialogue...
Ok, table scripts I can understand - no problem there. But what about stored procedures? I'm getting the same issue if I edit the generated proc script, compile it, then without committing right clicking on the proc in SSMS and going to Modify. If I compile those changes and THEN try to Commit I get an error "The list of changes to commit is out of date. To update the list, in the Commit tab, click Refresh". I get this error even though the Diff screen shows the proper changes between database and source control version. / comments
Ok, table scripts I can understand - no problem there. But what about stored procedures? I'm getting the same issue if I edit the generated proc script, compile it, then without committing right cl...
Manually edit the auto-generated object scripts without causing commit issues?
I'm working with a test database and using a working folder as the repo. After I performed the first commit, I went into the folder and re-formatted the auto-generated table scripts. I then updated...