I thought that view object is only the structure and does not contain any real data. Does it take the same system resource as the table object does?

Cheers

Dev

Using 3000 tables or 8000 views which one is better for the performance concern?

Cheers

Dev

thanks for your help, it works great.

Cheers

Dev

My function code looks like the following:

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

function Func as int

begin

...

select @seq=max(substring(id,3,8)) from TB1

set @seq = @seq +1

end

....

return @seq

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

the sql statement is

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

insert into TB1 (F1,id) select V1, Func() from TB2

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

The...

Yes, I create a function to do that. It works fine when the insert number is less than 1000, but over 1000, the problem comes back. The incremantal value only...

Do you mean to use exec() function? Yes, it works, but how can I get the result from the dynamic sql, like select @result=max(id) from @tablename. Could you give me...