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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Bind variables?

Author  Topic 

JimAmigo
Posting Yak Master

119 Posts

Posted - 2007-08-23 : 09:52:35
My boss wants me to look into a similar use of Oracle "bind variables" on the SQL Server 2000 side to optimize performace.

Does something similar exist on the SQL Server 2000 side and if so do you have a reference or example on how they are used?

Thanks,

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-08-23 : 10:24:44
look at using sp_executesql.

here is the BOL entry on how to use it http://msdn2.microsoft.com/en-us/library/ms188001.aspx




-ec
Go to Top of Page
   

- Advertisement -