Frank Kalis

Forum Replies Created

Viewing 15 posts - 3,721 through 3,735 (of 5,356 total)

RE: Mass update of TEXT fields

Hi David,
not long ago I asked this question the other way round
http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=16982&FORUM_ID=8&CAT_ID=1&Topic_Title=REPLACE+on+text+column&Forum_Title=T%2DSQL>
Frank
http://www.insidesql.de

October 21, 2003 at 1:51 am

#478900
RE: NULL vs. Empty String

quote:
Keep it simple and stupid.
are we talking about management ???
Frank
http://www.insidesql.de

October 21, 2003 at 12:52 am

#478898
RE: NULL vs. Empty String

Well, as has been said above, it depends...
you might take a look at
http://www.firstsql.com/inulls.htm
http://www.sqlservercentral.com/columnists/jtravis/understandingthedifferencebetweenisnull.asp
http://www.hughdarwen.freeola.com/TheThirdManifesto.web/Missing-info-without-nulls.pdf
to get further information on NULL
Frank
http://www.insidesql.de
Well, actually no real need to read my last link. Might actually...

October 21, 2003 at 12:37 am

#478896
RE: Wrong Index

Nice references!
Frank
http://www.insidesql.de

October 21, 2003 at 12:28 am

#478895
RE: Wrong Index

I think you've already cleared this 'parameter sniffing' by updating the statistics.
FWIW, here's a part from Inside SQL Server 7 that still is true
quote:

October 20, 2003 at 8:21 am

#478792

RE: Access vs SQL Server

quote:
We're facing situations where there are lots of departments using access databases for their daily functions and they are tasking their own...

October 20, 2003 at 8:15 am

#478791

RE: Incremental SUM

Why can't you use temp tables?

Also, if you are on SQL2K have you considered the table data type?

Frank

http://www.insidesql.de

October 20, 2003 at 6:59 am

#478770

RE: Connecting SQL Server 2000 and Visual Basic 6.0

quote:
Cheers Frank......Basically the VB app is going to be a UI for the database.....does this make a difference to any methods ill...

October 20, 2003 at 6:44 am

#478768

RE: Connecting SQL Server 2000 and Visual Basic 6.0

Hi Andrew,

quote:
Im fairly new to SQL Server but wish to create an application in VB (6.0) with a small SQL Server DB...

October 20, 2003 at 6:39 am

#478766

RE: Incremental SUM

Assuming your column 'margin' is always sorted ascending, this might work



create table #t( f1 int primary key, c INT)

insert #t values(1, 5)

insert #t values(4, 10)

insert...

October 20, 2003 at 6:27 am

#478763

RE: How to prevent exhausted Indentity

Hi,

from BOL

quote:
The main advantage of the uniqueidentifier data type is that the values generated by the Transact-SQL NEWID function or the application...

October 20, 2003 at 4:40 am

#478750

RE: Select records between 2 months/years

Hi,

quote:
I have a table and all records have a date.
I want to select all records between two given months/years.
For example, all records...

October 20, 2003 at 4:25 am

#478749

RE: Wrong Index

quote:
it's as if it knows which to use but deliberately decides not to use it.

you...

October 20, 2003 at 1:28 am

#478743

RE: Frequently Asked Questions

quote:
Nah1 But you can cook Salmon!!!
No Kidding

did someone ever mentioned that...

October 20, 2003 at 12:58 am

#478741

RE: Inserting Images

quote:
Can you insert images into SQL Server?

Have a look at http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part3/c1161.asp

Frank

http://www.insidesql.de

October 20, 2003 at 12:40 am

#478740

Viewing 15 posts - 3,721 through 3,735 (of 5,356 total)