Hi
1. Does SqlCommandBuilder.DeriveParameters method internally use
INFORMATION_SCHEMA.PARAMETERS ?
2. I am using this query presently to figure out parameters for a
stored proc ...I wanted to know if i could get into any performance
issues because this query is hitting syscolumns tables (through the
view) and this select may be slower if there are lot of rows in
syscolumns across the databse server..in other words in a given
databse server there may be several databases and each databse may
have several stored procs , Could it be a performance problem in that
case.....
i cache the the parameter information on application side once i
retrive it.
==================query I am using===================
SELECT REPLACE(parameter_name,'@','') as ParamName,
Data_Type as ParamFieldType,
IsNull( Character_maximum_length, IsNull
( Numeric_Precision,IsNull(DateTime_Precision,0) ) ) as ParamSize
FROM INFORMATION_SCHEMA.PARAMETERS WITH (NOLOCK)
WHERE specific_name = 'My_stored_Proc_Name'
ORDER BY ordinal_position ASC
=====================================================================
Thanks
Sidd
|
Similar Threads
