Where clause to search names between A and J can be written in the following ways: 1.SELECT * FROM TableName WHERE name LIKE '[A-J]%' 2.SELECT * FROM TableName WHERE PATINDEX('[A-J]%',name)>0 3.SELECT * FROM TableName WHERE name >='A' AND name ...

**Identity:** is a sql server generated number on a table column based on the seed and increment.Seed is the starting value the column should start with.Increment is the incremental or decremental factor by which the column would be assigned the val...

Hi All, Instead of trigger was created on the first table due to which the first table was not updated. Trigger is a stored piece of Transact SQL code that performs some pre-defined task when an event occurs. There are 3 types of triggers: 1.Data ...

Hi Madhivanan, can you please elaborate on why 2 is being added? Thanks, Sreelekha...

Hi Madhivanan, can you please elaborate on why 2 is being added? Thanks, Sreelekha...