SSMS access and code formatting
-
Thank you Mark.
My 2 last quick questions:
1-if I build a SQL process and I needed a user to run the code (process) on demand not Thru a SQL job. Is there a good/easy way to do that without building an invasive web interface and purchase another VS license?
2- I don't see a good way to organize the SQL code in SSMS in Separate folders (like HR Code, Finance Code, Etc..). I can certainly prefix the solution/project names with Hr_ or Fin_ to differentiate but organizing the code in folders/sub folders seems missing.
Thanks a lot everyone..
-
1 SSMS is free. They can download that. Set up the appropriate privileges so that they have db_datareader with execute of stored procedure as an addition.
2 This should go hand in hand with your search for a version control system
- oneteabag wrote:
2- I don't see a good way to organize the SQL code in SSMS in Separate folders (like HR Code, Finance Code, Etc..). I can certainly prefix the solution/project names with Hr_ or Fin_ to differentiate but organizing the code in folders/sub folders seems missing.
Thanks a lot everyone..
(Many, but not all, people work as follows...)
Your database code should be developed within one or more 'database projects', using SSDT (which is a cut-down version of Visual Studio). The code in these projects should be checked in to a VCS.
A tool like Octopus Deploy or TeamCity can be used to automate the deployment of checked-in code from your VCS to one or more target databases.
This is a big topic and if it's all new, you have some reading and investigations ahead of you.
Database projects allow you to organise your database objects in folders.
-
In the past, we've found a lot of problems with automated deployments that can be described by one, single, four letter word...
"Oops".
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Make Sense Jeff.
Now I have to go and play with SSDT..Thanks Phil for the info.
Viewing 5 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply