You can use TEXT which can hold upto 3GB of data.

Cheers,

Crispin

Thanks Mike.

Why do you say I might end up with worse performance?

If IO is only done for pages then a 8k cluster would be best(?)

Although, having a 64k cluster would...

quote:

---

Crispin -

I don't have numbers to back this up. But I found better performance when I formatted my SAN with 64k...

Gabor, thanks for the info.

quote:

---

You can create a table having a larger row size as 8060 but you will have an error...

http://www.sqlservercentral.com/scripts/contributions/622.asp will do it.

Cheers,

Crispin

Thanks!

Cheers,

Crispin

Thanks!

Cheers,

Crispin

Select Convert(Decimal(10, 2), 12.23653)

You can replace the number with the coulmn name.

Cheers,

Crispin

From a cost point of view, I would not roll out Enterprise edition to clients.

Have a look at MSDE which is on the Office 2000 CD.

This is a brokendown version...

Thanks. Will have a look

Cheers,

Crispin

-- Use the specifically named INDEX.

USE pubs

SELECT au_lname, au_fname, phone

FROM authors WITH (INDEX(aunmind))

WHERE au_lname = 'Smith'

See BOL: Select > Examples.

Why would you want to force it? Does the optimiser not...

Create Table Test (

Col1Varchar(200),

)

Go

Alter Table Test Add Col2 Varchar(200)

Go

See "ALTER TABLE" in BOL for more options. ie NULL, NOT NULL, DEFAULT etc etc

Cheers,

Crispin

Edited by - crappy on 11/18/2003 10:27:46...

Credit to Neil.

http://www.sqlservercentral.com/scripts/contributions/660.asp

Cheers,

Crispin

Not that I am aware of.

I am assuming you are calling the function from a proc.

Could you not insert the row into the table from within the proc, use the...

I sort of misread your post.

No, procs cannot be called from within a function.

Yes, functions can call functions.

Functions can call extended procs.

To get this to work, either copy the code...