March 14, 2011 at 11:27 pm
We have Stored Procedure which connects to AS400 system and retrieve or insert/update data in the AS400 files using linked server.
Right now we have hardcoded the linked server name, AS400 catalog name, library name and file name in SP. We are using SQL server management studio for the development.
We got to know that rather than hardcoding we can use variable reference for the changing variables as per the target environment using
Visual Studio 2008 Database Professional GDR 2.
Can anyone assist on this? We need to know how to use Visual Studio 2008 Database Professional GDR 2 for adding variable references and using them in stored procedures.
Thanks
March 15, 2011 at 6:37 am
You're confusing two sets of functionality. The variables in Visual Studio are just part of the build and deployment, not a part of coding. All they really are is SQLCMD mode variables that are run with the scripts. They won't be an existing part of the stored procedures.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply