Frank Kalis

Forum Replies Created

Viewing 15 posts - 4,366 through 4,380 (of 5,356 total)

RE: Storing Word Documents in SQL Server

Hi Rob,
quote:
I am currently working on an application for Intensive care. One of the requirements is that the users would like to...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 5, 2003 at 4:56 am

#468602
RE: Identity Function

Hi Mike,
quote:
I'm using the identity function to insert an identity field (as it happens) into a temporary table. I'm seeding the...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 5, 2003 at 4:47 am

#468601
RE: How to get the row count of a table?

Hi Krishnan,
quote:
I am using ADO in VC++ to access my SQL server database. How do I get the number of rows of...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 5, 2003 at 3:41 am

#468597
RE: Image

quote:
If you use a binary large object (BLOB) you can stream the images in/out as you please.
It all depends on the size...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 5, 2003 at 2:42 am

#468589
RE: Cascading Updates/Deletes and Triggers

Hi scking,
quote:
If cascading updates are set on related tables aren't triggers that perform the cascading updates duplicating effort and what is the...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 5, 2003 at 1:22 am

#468578
RE: Loss of Data - Help Needed

Hi Prabhakar,
quote:
How do i read the log file, i should at least be able to find out as to who did it...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 5, 2003 at 12:44 am

#468577
RE: Loss of Data - Help Needed

Hi Prabhakar,
quote:
Today seems to be a bad day....i found that two tables in two databases that i have, have been truncated...... is...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 4, 2003 at 11:59 pm

#468573
RE: Access 2000 front end - system_user, Host_name

Hi nulad,
quote:
The Access code will not accept "System_User" or "Host_Name", it gives an error message of "Variable not defined".
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 4, 2003 at 11:45 pm

#468572

RE: Image

Hi Bruce,

quote:
How can I store an imgage(.Jpg or .bmp file)in my sql server table.Which datatype i should use and how can store...

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 4, 2003 at 11:40 pm

#468571

RE: forms will only display the last record

Hi alicejwz,

isn't this kind of the same question you've asked in another thread?

Anyway, I agree with bobsterboy.

Set the recordsource of your form dynamically like

Form.Recordsource = <your_recordset>

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 4, 2003 at 11:30 pm

#468570

RE: QOD 8-4-2003 Disagree with answer...

quote:
Antares, I think you just tested the limit of the text column we have to store posts :).

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 4, 2003 at 11:24 pm

#468569

RE: QOD 8-4-2003 Disagree with answer...

Hi Scott,

I guess that is one of those things I must not understand.

I've downloaded my SP3 (a?) BOL update from M$ website.

Now, where can I definitely...

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 4, 2003 at 8:53 am

#468450

RE: QOD 8-4-2003 Disagree with answer...

quote:
Do you recall which page you found that section from BOL on? I can't find anything that references parameters like that. I...

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 4, 2003 at 8:31 am

#468446

RE: QOD 8-4-2003 Disagree with answer...

Hi Scott,

first let me say, I was also wrong!

I, too, had to look up BOL, but I've found another page stating this:

quote:
Parameters...

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 4, 2003 at 8:17 am

#468443

RE: Do you think DBA is a desirable job?

Hi Ritch,

quote:
This was in Chapter 6 of 'Management for Dummies', How to Ruin your Project and Disillusion your Customers, Whilst Convincing the...

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

August 4, 2003 at 7:29 am

#468425

Viewing 15 posts - 4,366 through 4,380 (of 5,356 total)