Viewing 11 posts - 1 through 11 (of 11 total)
As one of those "wallflowers" I have to agree with Phil. I have enjoyed reading the newsletter and various articles for over 5 years, but only answered about 3...
November 28, 2008 at 1:22 am
Searching Word Docs:
1. Create two columns e.g:
DocumentData Image
FileExtension varchar(4)
Store the document in the DocData column and it's file...
November 6, 2006 at 3:00 am
OR (@SpreadSelect = 0 AND SpreadFile <...
October 13, 2006 at 4:30 am
I've always managed to avoid cursors in an actual application, however I have used them for altering table design. Someone gave me a database with several table that had lots...
November 24, 2004 at 3:43 am
You might be able to reduce the time a little more by using an 'exists' instead of the join on the code table.
November 17, 2004 at 2:32 am
Extract from BOL
| status | tinyint | Bitmap used to describe a property of the column or the parameter: 0x08 = Column allows null values. 0x10 = ANSI... |
September 22, 2004 at 2:51 am
Have you tried re-creating the ADP? I would have said it was some sort of connection issue casued by network changes, but the fact that they can connect manually implies...
September 20, 2004 at 10:01 am
Take a look at what you can do with triggers. if you add an insert trigger to the parent table you can (probably) write all the child records in one...
August 11, 2004 at 4:17 am
There shouldn't be any data issues, but check http://www.microsoft.com/sql/evaluation/features/choosing.asp to make sure you are not useing any Enterprise only features.
August 3, 2004 at 2:33 am
Or use the isnull function...
where isnull(column, '') <> ''
August 3, 2004 at 2:24 am
To save putting isnull around all your feld names you might want to look at SET CONCAT_NULL_YIELDS_NULL.
July 29, 2004 at 2:21 am
Viewing 11 posts - 1 through 11 (of 11 total)