Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

VB.Net support from your SQLServer DBA

By Johan Bijnens,

Once devs are pushed toward using parameters, they get confused as to why their sp is not reused and has many compilations when in use.
The reason is most of the time, that the parameters are defined with a wrong datatypemapping in the application or have different datatypes in a # of applications.

I use this proc the generate the .Net-code to define and use the parameters for a commandobject named sqlcmd. A simple copy/paste helps out in this case.

It is primitive, and it may have some flaws, but it helps out in 90 % ...

Total article views: 239 | Views in the last 30 days: 1
 
Related Articles
FORUM

Parameter to Parameter

Parameter Values

FORUM

Parameter Dependency

Parameter Dependency

FORUM

Parameter issue

Parameter issue

FORUM

Multiple parameters

Multiple parameters

FORUM

Multiple report parameters

Parameter dependency

Tags
miscellaneous    
t-sql    
 
Contribute