This is my first post. I program for a large hospital. Been a programmer for 30+ years! But I'm a Cobol/MVS/CICS/etc.. programmer who works on some servers as well (Report2Web and now Linux!)
Well we have some super applications coming up and need SQL skills.
I have Microsoft SQL Server Management Express Studio on my pc and I've made tables for ICD9 and ICD10 comparison.
Now the question... besides scripts to load and run on the server via the Server Management Studio is there any way to compile these and run as modules? How would I set up ways for users to run their own reports I've developed?
I've done this with Freebasic and bat files but never on a SQL database and I know of no way to get a bat file to execute SQL scripts!
Couple of things you may want to look up that would be useful:
1. SQLCMD - this lets you run SQL commands from a Windows command line. If you were to go this route, you should create stored procedures that have the queries you want to run and then invoke the stored procedure via using SQLCMD. http://msdn.microsoft.com/en-us/library/ms165702(v=SQL.90).aspx Stored procedures are "compiled" and the execution plans are reused: http://msdn.microsoft.com/en-us/library/ms345415.aspx
What sort of reports are they? One method I've used quite a lot recently - but this is for daily reports to DBAs - is running Powershell scripts , which manage the connection to the database, execute the code , and then output the report to a html and email them. To create this method - does require some Powershell knowledge.
Running Sql Applications
Posted - 06/08/2012 : 10:47:36
