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.

Diffrence between DTS vs SSIS

2 Answers   IBM, Infosys,

---

What you can do to delete a table without the delete trigger firing?

0 Answers  

---

What is the dbcc command and why is it used?

0 Answers  

---

Different types of keys in SQL?

0 Answers   Infosys,

---

Can we shrink data file in sql server?

0 Answers  

---

What are the steps you must follow to hide sql server instances?

0 Answers  

---

How to achieve Paging of records in SQL SERVER?

0 Answers   Petranics Solutions,

---

What are the different acid properties?

0 Answers  

---

Explain what is the use of custom fields in report?

0 Answers  

---

How can we call UDF(User Define Function) using C# code in ASP.net ?

1 Answers  

---

why we use cursor?

4 Answers   CarrizalSoft Technologies, Melstar, TCS,

---

Can you tell me about the concept of ER diagrams?

0 Answers  

---