Posts
Sort by recent activity
Using SQL Doc to document view columns
HI all We've got a lot of views (please, don't ask) and we've been asked to document the columns in each view.I'm trying to use SQL Doc to get the columns for the views in a specific schema.I don n...
SQL Compare "oddity"?
Hi allI've just tried using SQL Compare to deploy a changed stored procedure that uses synonyms to go across a linked server.When I tried to use both the "Deploy using SQL Compare" and the "Generat...
Source Control comments and TFS
Hi allI've just enabled the forced comments in Visual Studio for when we commit changes to TFS.This should also work in SSMS for when we make changes to a database and try to commit those changes.U...
Align = in MERGE statement
Hi allWe've been using SQL Prompt styles to give our code a standardised format but there's one small niggle.We can align the "=" in the FROM clause on joins but, when using an MERGE statement, we ...