See if you can utilize this

USE NORTHWIND

GO

DECLARE @myCol VARCHAR(10)

SELECT

 @myCol =  DATA_TYPE

FROM

 INFORMATION_SCHEMA.COLUMNS

WHERE

 TABLE_NAME = 'Orders'

AND

 COLUMN_NAME = 'OrderDate'

SELECT @myCol AS MySearchedDatatpye

MySearchedDatatpye

------------------

datetime

(1 row(s) affected)

Does this help?

UPDATE Islem_ana

set HASBORC=SELECT SUM(HASBORC)  + (@GIRILEN_MIKTAR * @GIRILEN_MILYEM/1000) + (@GIRILEN_MIKTAR * @GIRILENISCILIK)

from Islem_ana where HESAP_NO=@HESAP_NO and fisno=@FISNO and tariH=@TARIH AND satirno=@SATIRNO

Might need some parenthesis...

Here I found it:

http://www.google.de/search?q=Virginia+Arrests+Man+for+Spam+&hl=de&lr=&start=10&sa=N

Now, if I understand this correct:

UPDATE MYTABLE set LASTDEBT=LASTDEBT + (@ENTERED_QTY* @ENTERED_UNIT/1000) + (@ENTERED_QTY * @ENTEREDISC) from MYTABLE where ACCOUNT_NO=@ACCOUNT_NO and fisno=@FISNO and myDATE=@myDATE AND LINENO=@LINENO

However, this...

Why are you preparing the SQL string to be executed in your client code anyway? Why don't you use a stored procedure here?

Piggy-backing on Habib, this should be interesting:

http://www.karaszi.com/SQLServer/info_datetime.asp

I would be interested to know, where you've read about this 1 TB limitation.

Anyway, see if this links help:

http://www.microsoft.com/technet/community/chats/trans/sql/sql0326.mspx

http://www.microsoft.com/sql/techinfo/administration/2000/scalability.asp

http://www.wintercorp.com/

See if this helps:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx

Personally, and without knowing the background of the question I would be more concerned with what happens in the case of disaster than with some space...

Wasn't there recently a sentence where they send some American to jail for sending Spam?

To piggy-back on this RAID 5 thing, read closely through this: http://www.baarf.com/

Yes, there are definitely more than one way to skin that cat.

Good catch on the temp table method, PW. Have you considered making...

What would the difference between the CreateCustomer proc and the InsertCustomerRecord proc?

Have you read the link I've posted? It doesnt mention a cursor, unless I am mistaken.

Sure, this can be done via a cursor, but why?

http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx

YES, I would like to use the ISO 8601-standard, but HOW?

This might be a start: http://www.google.com/search?q=ISO%208601 

the ubiquitous Frank and I were talking ...

It doesn't look that way at my home