do you mean using the WITH clause with a Common Table expression, or do you mean where you use the WITH clause to use a hint, like WITH(TABLOCKX)?

a CTE would...

I think you have two choices; raise an error like you were planning, but you could also use an INSTEAD OF trigger, and ignore any changes to the ID column,...

you'd be looking for a DELETE or TRUNCATE command; there's nothing in place to look at where it happened.

the default trace would have information if the table was dropped, but...

here's what i do:

i create a view for any trace i create, so I can easily access it.

here's a code example:

--review all my traces

select * from sys.traces

--find the path to...

excellent. with the table definitions it is REALLY easy for us to help. good job providing us with that.

here's a basic example that works; note the key is to use...

this is known as a "running totals" problem. running totals require a defined ORDER BY...wkether it is a PK, or alphabetically, or whatever...your example so far does not meet the...

here's the first way i thought of: compare the value to the convert(,int) of itself.

declare @number decimal(18,4)

Set @number = 10.0

--here's one way, compare the value to the integer conversion of...

the CONVERT function has a third parameter which has some built in formats for converting datetime to varchar:

char to datetime:

select convert(datetime,'090611',12)

--results:

2009-06-11 00:00:00.000

and going the other way, datetime to char

select convert(varchar,getdate(),12)

--results:

090611

using...

Andras gave you an example; we thought you could extrapolate.

note the assumption that with the data, there is always space and then the two digit state code.

here is a...

that would be normal....if i started an insert or update that was tweaking a million rows, and then tried to cancell it, it certainly might take a while to rollback...

i think you are missing a reference; try adding

Imports System.Collections

to the top of your class. IEnumeration is a member of System.Collections.

Tara (6/10/2009)

---

I am just confused with this 2 processess.

Does sql server roll back the transaction when i cancel an insert query from the query window, does it act as the...

the issue is the way exclusive locks work.

a lock prevents the SELECT,UPDATE/INSERT/DELETE of the table.

it does not prevent the selecting of the current ident value, or reviewing of any other...

why are you selecting @CurrentId from an identity value manually? INSERT into the table and get the Scope_Identity() its the right way to do it. it looks like you are...

andy.gear (6/10/2009)

---

So I have two tables that have two fields that are the same. How do I find pairs in one table that are not in another table? ...