Search:

Trigger is a event based action.
whenever we perform insert,update and delete actions then it will fires automatically.

Hi,
As you mentioned above it is not possible to create more than one clustered index or unique clustered index.
So,
For creating new one drop the existing one.

select * from sysobjects where type='p'

select cityname, years from <Table_name> where cityname like '%m%

If u want more than one column then use 'OR' clause , 'AND' clause.

select cityname, years from <Table_name> where cityname...

We have three types of Joins in sql.
They are
1. Inner join
2. Outer join
3. Cross join

1. Inner join:
Inner join is the default type of join, it will producesses the result set, which...

We have three types of Joins in sql.
They are
1. Inner join
2. Outer join
3. Cross join

1. Inner join:
Inner join is the default type of join, it will producesses the...