Yes, i did.

I read

http://databases.aspfaq.com/general/why-do-some-sql-strings-have-an-n-prefix.html

and

http://msdn.microsoft.com/en-us/library/aa933104(v=sql.80).aspx

and

http://msdn.microsoft.com/en-us/library/aa276823(v=sql.80).aspx

it is not the first time i look for the answer. but its the 1st time i ask ppl.

yes, i dont understand the "var" part in varchar....

unicode: the data size is 2 times of the data length

my question is: the comment column sets to nvarchar(200), I think is not big enough, sometime comment is longer than...

:crazy: i double post, my bad

thank ppl to reply the post.

if iam using sql server 2000, does it support nvarchar(max)??

what if iam using nvarchar(200), every filed will take 200Bytes, no...

thank ppl so much to reply the post

i think i got it, let me make sure i understand,

e.g.

nvarchar(max)

"hello world" is 11 Bytes,

"hello" is 5 Bytes,

varchar(max)

"hello world" is 22...

if yes, how it going to help me to set the column size

what is unicode data

thank you ppl reply the post!

I just checked, we are using 2000

Generally when you are inserting...

Thx for ur detail explain tommyh!

something that's stil not clear from my mind.

I know my second insert is not effective, and I understand your code(only check the @clientNumber, not all...

thx ppls to give me help!

I did a test on two different sp (test with 3400 rows),

one is my sp, processing time 46 sec

CREATE procedure [usp_addRecords] (

@id as int, @clientNumber...

I dont get it. clientNumber in tblClientList is primary key.

can you tell me abit more in detail. thx!!

below is my code, i dont know why two insert togeher in the sp will take much longer time to finish the process

CREATE procedure [usp_addRecords] (

@id as int,

@clientNumber...

Paul White NZ (11/16/2010)

Using an (non-materialized) view makes no difference. Such a view is just a description of a query - no...