-
db parameter
I've got a VB app that is going against a "Great Plain" accounting system database. Each company within a group of companies has it's own SQL Server database with the exact table structure under it. From my app, I choose the company I wish to preform an action on. Based on that choice, I need to have a stored procedure that pulls in customer data for that company(one of the tables). I need my stored procedure to take database NAME as a parameter so that I can avoid hard coding the database choices within the program. I've already set up a table that contains the valid companies with their associated SQL Server database name. I just need to know how to have the stored proc take db name as a parameter. I know that this is semi OT, so if you don't just happen to know <g>, could you direct me to a SQL Server Listserve. I don't konw of one, but I'm sure that there are probably 10 of them out there.
Thanks,
Brian
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|