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.
| Author |
Topic |
|
karthickbabu
Posting Yak Master
151 Posts |
 Posted - 2008-01-19 : 00:46:40
|
| I wrote a stored procedure and pass few parameters.How can i check the input parameter datatype.I want to do display user message if the user pass different parameter datatype than actual parameter datatype defined in sp.Is any function available to check this in sql either server 2005 or sql server 2000================================================When you realize you've made a mistake, take immediate steps to correct it. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-01-19 : 00:56:30
|
| You should do this check at the front end where there are built in functions available, and your applicationa lready has knowledge of the type of parameters.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
karthickbabu
Posting Yak Master
151 Posts |
Posted - 2008-01-19 : 01:13:30
|
| Thank you very much...================================================When you realize you've made a mistake, take immediate steps to correct it. |
|
|
|
|
|
|
Check DataType