SQLParameterCollection's constructor is private - so cannot directly write as -
Dim objSQLParameterCollection as New SQLParameterCollection
If you cannot instantiate object, then how does SQLCommand object create SQLParameterCollection object?
(It returns SQLParameterCollection object with...
DateDiff does not return me correct date difference in years :
Dim dtDate1 AsDate
Dim DOB AsDate
DOB = #12/31/2000#
dtDate1 = #1/1/2005#
datediff(DateInterval.Year,dob,dtdate1) returns 5. It should return 4.
It must be using "Ceil" function internally.
What say?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.