SQL Stored Procedures - How to run from vbscript w/variables?
Posted on 2011-05-12
This may be a relatively easy question for you guys to answer, but I'm stuck on the concept in what to do with connecting to SQL via VBScript and doing the following:
I need to have computers that run a VBScript, send a couple of variables up to a SQL Server.
I then need SQL server to run a query based off of the variable it receives from the computer.
All records that are returned in SQL need to be passed back to the original computer as VBScript variables.
I have the DB already defined with tables/views. I don't have any stored procedures built yet.
I can't run the query on the computer itself... Only have it send variables, and then receive replies from SQL (If this makes sense).
Is this possible? Thanks for any information you can provide.