Hi, everyone!We have just upgraded our SQL server from 7.0 to 2000, and we have stumbled into some conversion problems in COM++ object.1. We are using variant as input variable in the function header in our COM class (VB6).2. Then we use as adDouble for the parameter when executing the stored procedure.This works fine in SQL 7 […]
2005-01-19
I also think that there may be a flaw in your @acno logic. see the belowIF ((@acno IS NOT NULL OR @acno <>'') AND (@actype IS NOT NULL OR @actype <>'')) IF ((@acno IS NULL OR @acno = '') AND (@actype IS NOT NULL OR @actype <> '')Try this IF ISNULL(@acno, '') <> '' AND […]
2004-12-08
Recently I was involved with an off-site D/R. I spend almost 24 hours of sleepless hours there just doing simple restore from backup that my 12 years old son can do, too. This make me start think why DBA need on the D/R site to do this boring job while you may be more prodctive in […]
2004-11-22
2 reads
Okay, makes sense, but does not explain why the text suddenly appears when I remove the photo field...?? As I mentioned above it works fine when the text datatype is VARCHAR - what confuses me is that I have used the same datatypes on earlier websites with no problems... Luckily the propertyDescription will not be […]
2004-11-09
You have to have SQLAgentMail configured before you can send emails or pages to the operators you've setup. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-05-14
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers