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.

What are the differences between user defined functions and stored procedures?

0 Answers  

---

What is the use of custom fields in report?

0 Answers  

---

How you can minimize the deadlock situation?

0 Answers  

---

What are the 3 types of schema?

0 Answers  

---

What is the purpose of using COLLATE in a query?

1 Answers  

---

What is the difference between clustered and non-clustered indexes in ms sql server?

0 Answers  

---

what is difference between primary key and Unique

8 Answers  

---

What purpose does the model database server?

0 Answers  

---

how can u select the Distinct values in the table, table having 20 columns , i want all columns

2 Answers  

---

What is clustered vs nonclustered index?

0 Answers  

---

When you use @@error and try-catch?

0 Answers  

---

Explain what are various ways to enhance the ssrs report?

0 Answers  

---