Answer / rajendra prasad reddy penumall

'Like' operator is a pattren matching operator.

Eg;
select name from class where name like 'a%'

selecting names starting with letter 'a' and any length

select name from class where name like '_a%'
selecting names starting with second with letter 'a' and
any length.
select name from class where name like '[abc]%'
selecting names starting with first letter 'a'or 'b'
or 'c' and any length.

select name from class where name like '[^abc]%'
selecting names except starting with first letter with
letter 'a'or 'b' or 'c' and any length.

Answer / deepak

Pattern matching is used to get the information without
mentioning the full name and by just using the LIKE operator
and just mention the starting letter.

Can two tables have the same primary key?

0 Answers  

---

What happens if you insert a duplicate key for the primary key column in ms sql server?

0 Answers  

---

what is cluster and nin-cluster index?

4 Answers  

---

How many types of cursors are there in SQL Server?

5 Answers   247Customer, CarrizalSoft Technologies,

---

What is similarity and difference between truncate and delete in sql?

0 Answers  

---

Describe in brief databases and sql server databases architecture.

0 Answers  

---

What stored by the master? : sql server database administration

0 Answers  

---

How to change server name in sql server?

0 Answers  

---

What is transactional replication?

0 Answers  

---

How check triggers in sql server?

0 Answers  

---

What are the different types of joins and what does each do?

2 Answers  

---

Can you tell me about the concept of ER diagrams?

0 Answers  

---