Yes we can get it from syscomments table. But my DB having more no of data and its taking more time to execute. can u tell any fatstest method for...

I am 100% sure that this is not a code level problem as I havent find any locks or any code level blockings there. More over as its online transaction...

Let me explain the question briefly,

For example assume I have table

table 1 and it is having columns name,id,date (only the date values I have to insert)

I have 2 tables...

Thank you very much Mr.Thomas. I came across the same issue ie non- identity to identity type change and your article has helped a me a lot.

But when I have...

You can use the following code also.

DECLARE @DateTimeValue varchar(32),

@DateValue char(8),

...

Yes I can also think the different ways of approaching a problem. As I am new to SQL I hope this website will teach me a lot and correct my...

Just try this code. I have tried in a very straight way. I dont know is there is any tricky things are there to do. If you know also please...

Thank you very much for all your replies. I start to concentrate on administration part of sql server.