Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Deaf Smith
Starting Member
3 Posts |
 Posted - 2012-06-08 : 10:47:36
|
| Hello,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!Thanks for any help!Deaf |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-06-08 : 11:08:28
|
| 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.aspx2. SQL Server Reporting Services - You mentioned running reports. SSRS may be appropriate if you are trying to generate complex reports: http://technet.microsoft.com/en-us/library/ms365166(SQL.105).aspx |
 |
|
|
Deaf Smith
Starting Member
3 Posts |
Posted - 2012-06-08 : 11:33:56
|
| Ok.What about SQLite? WOuld that work for alot of training and testing as well as small applications?Thanks!Deaf |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-06-09 : 07:51:05
|
quote:
Originally posted by Deaf Smith
Ok.What about SQLite? WOuld that work for alot of training and testing as well as small applications?Thanks!Deaf
I am not familiar with SQLite - and I suspect many people on this forum are not. This forum is exclusively Microsoft SQL Server. If you are still in the process of selecting a RDBMS, you could post to dbforums.com or a similar site where you are likely to get better responses. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-06-09 : 11:13:59
|
| 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. Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Running Sql Applications