Yes,Local variables can store single value at a time.But just for example i explained to him how inserted table get affected within a trigger.

Create Table Emp

(

Eno int,

age Int

)

Create Clustered index id1 on Emp(Eno)

or you can use Alter Table statement to create clustered index.

Anyway come to the point.

Now you have a insert trigger on...

Grant,

A littel late here.Sorry!.They are all looking in different part of INDIA.

Thanks for your interest.

Thanks HumbleDBA.

Thanks Jeff. I didn't check it. I will check it and get back to you.

Thanks Gila and Jeff.

From our discussion,The following points should be kept in mind when we use NULL.

1. We should avoid comparison of NULL with relational operator.

i.e...

I am having 1400000(Normaly we say it as 14 Lakhs Records)records in a table. Now i want to create Sequnece number for these records.

Sorry,if my question confused you.I asked about the below formula.

My math may be really rusty, but I don't understand how this formula works.

Future usage = current usage x (1 +...

Yes.

This year should bring all success and improvement to this site.

WISH YOU ALL A HAPPY & PROSPEROUS NEW YEAR.:)

Also i have improved my written skill.

he has 6 years of IT experience. He did very well. Eventhough he did not selected.

Is there any on-line training centre available ?

I am a SQL Developer.

Slowly i started to think SetBased logic.

I have read some posts and articles regarding Setbased and RBAR logic in this site very Recently.

In future,I never use while loop to generate...