SSMS access and code formatting

Question

SSMS access and code formatting

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

oneteabag SSC Eights! Points: 954 More actions · Answer 1

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..

MarkP Old Hand Points: 305 More actions · Answer 2

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

Phil Parkin SSC Guru Points: 246960 More actions · Answer 3

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.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 4

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)

oneteabag SSC Eights! Points: 954 More actions · Answer 5

Make Sense Jeff.

Now I have to go and play with SSDT..Thanks Phil for the info.