Isn't that already done implicitly by all major database systems?
On Apr 1, 7:20 am, Aman Sharma <[email protected]> wrote: > Thanx Cerebrus. > Actually I need to check them in DB ... I mean in Stored Procedure not in > C#. > I think, checking of parametr's data type in db is wrong approach and I > never did it but I need to do now as it is our client's requirement. Client > wants every check in DB. > > > > On Wed, Apr 1, 2009 at 12:29 AM, Cerebrus <[email protected]> wrote: > > > Use SqlParameters with the DbType set either via constructor or by > > setting the property. > > > On Mar 31, 10:53 pm, Aman Sharma <[email protected]> wrote: > > > Hi, > > > > *MS SqlServer2005 - Stored Procedure* > > > > Is it possible to check for Invalid Data Type in SP? For eg:- String is > > > passed into SP rather Integer.- Hide quoted text - > > - Show quoted text -
