Choosing the index is purely based on how the table is being queried and what is are business requirement that table is addressing.

check out the below link for some considerations:

PRINT IDENT_CURRENT('table')

This will give the most recent IDENTITY value for 'table' - regardless of whether you created it or not

PRINT SCOPE_IDENTITY()

This will give the IDENTITY value last created...

Instead of suign SELECT INTO why don't you try out BCP???

Glad to see your issue is resolved 🙂

Hi The best way to preare is by looking at the official course material for this exam.

Check out the below link

http://www.microsoft.com/learning/en/us/exams/70-431.aspx

If you have any questions on any subjects...

twantoni (4/8/2009)

""Msg 2601, Level 14, State 1, Line 1

Cannot insert duplicate key row in object 'dbo.INVENTDIM' with unique index 'I_698DIMIDX'.

The statement has been terminated.""

How do I get the original value...

CREATE TABLE Employee_Test

(

Emp_ID INT Identity,

Emp_name Varchar(100),

Emp_Sal Decimal (10,2)

)

INSERT INTO Employee_Test VALUES ('Anees',1000);

INSERT INTO Employee_Test VALUES ('Rick',1200);

INSERT INTO Employee_Test VALUES ('John',1100);

INSERT INTO Employee_Test VALUES ('Stephen',1300);

INSERT INTO Employee_Test VALUES ('Maria',1400);

CREATE TABLE Employee_Test_Audit

(

Emp_ID...

Can you tell us about plan and approach...this will help others...

ulile (4/9/2009)

AFIFM (4/7/2009)

From query prespective how is this different...

Inspiring article. Thank you for sharing with us...

The best way to find that is verifying with Consumers who are using your database.

Hi Steve,

I am sure...

Hi Tanya

Global temporary tables are dropped when last session accessing the tables is closed. It is always good practice to drop the temporary tables in the same scope, once we...

In Other words i did exactly same as Flo mentioned in this post.

The way i...