Hi Martin,

I am also having a problem with this 32 cascading level. looking forward for a solution.

MCP MCSE MCSD MCDBA

Hi 549,

You are correct. You can have a faster query by searching integer rather than string. I agreed. But What I wanted to show is the way.

And in my...

Hi Cooper,

Ok, let me explain why the first example is not deterministic. As per BOL, given four criteria should be met in order to mark the function as deterministic....

As I think, this is depend on cost and familirity. I read the page what you have mentioned but can't agree to all like partitioning, triggers, external file accessing....

I wonder why the cost of Oracle developer so high. Because of Orcal DBA has wide knowledge than SQL DBA or besoming Oracle DBA is too difficult and too...

This code can be run without any problem because I have used CREATE SCHEMA AUTHORIZATION dbo. So, I do not need to create and alter tables.

My Question is by...

Hi all,

I received an email from Oracle expert saying it is not so much cost as I have mentioned. As per him, by using only Oracle Express, you can...

Ok. let's say we created tables like below. Is it possible to do insertion.

font=Verdana]CREATE SCHEMA AUTHORIZATION dbo

CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 INT REFERENCES t2(c1) NOT NULL)

CREATE...

You can do this by exporting all records into temporary table with identity column. But there are two major problems. One is if you have already used an identity...

If the result of @@version is 8.00.534, still your server with SP2. If it is updated with sp3, it should be 8.00.760. If you have installed a patch, then...

I had a same problem with SQL 2000 when I restored one of my DBs in different server which had same logins because of UIDS mismatch. But this can...

Hi Andy,

Why can’t we run this insertion process within a transaction?

Dinesh Priyankara

Edited by - Dinesh on 03/06/2003 9:17:45 PM

Hi Mike,

Actually what we want is, reuse removed identities. So, whatever the method, whether TOP 1 or MIN, you get desired result. But if you consider about performance,...

Hi kmsonti,

Thanks for comment.

Though we can easily find the SP through EM, I always like this way as I am T-SQL junkie.

Anyway, thank you very much because...

Hi Jeremy,

I agree with you if the OrderHeader table has no index created with IDENTITY column. But as a general rule, we always create clustered or nonclustered unique index.

If...