Hi Tony,

Let me explain the problem with your cases and additional case.

the two cases -

-1) Create a table from scratch, *don't* insert a new record, execute a DELETE for...

Hai Tony,

Thanks for your Valuable suggestion,

This works fine,

But my problem is if the table contains no record ,in that case the id starts from 2 if we try to use...

Hi,

Actually i wrote a query which uses insert datas into a table,

But Before inserting the data every time iam deleting the previous records in the table.

Then I am Reseeding Identity...

The problem is when i reseed to 1 ,

the identity value starts from 2

Rajesh

Hi John,

/****** Object: Table [dbo].[DiscountTable] Script Date: 04/24/2008 16:14:20 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[DiscountTable](

[DiscountPID] [smallint] IDENTITY(1,1) NOT NULL,

[Code] [varchar](50) NULL,

CONSTRAINT [PK_DiscountTable]...

Hi Karthick,

I think the problem with your code is you have assigned age like a value for the @Nm, not Age as like a column containing the values

I tried and...

Hi,

Look into this website .This might Help you,

http://vyaskn.tripod.com/watch_your_timeouts.htm

Best Regards,

Rajesh

Hi Oana Schuster,

Thanks a lot ,Your Query Worked Fine .

One Small Request ,the query will look much powerful if we reseed the identity columns in the tables to 0 once...

Thanks Krishna,

Your Idea Worked fine.

I have transferred the values from one to other database

Best Regards,

Rajesh

Hai Alex,

I have a similar problem ,where i want to fire a trigger if a particular column in a table is updated.

Let us consider the following

I Have a table with...

Hi Girish,

Thanks for your Kind Information.

Well i tried to use the simple Insert into Query ,but i didn't get the things .

For Eg:

I have two tables with same name...

Hi Karl,

Thanks a lot ,Updating the variable using GetDate() is very useful to me to sort out the problem.

BestRegards,

Rajesh