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.

How to check if stored procedure is running in sql server?

0 Answers  

---

Write an sql query to find first weekday of the month?

0 Answers  

---

How can I track the changes or identify the latest insert-update-delete from a table?

0 Answers  

---

What is tabulation?

0 Answers  

---

Write down the syntax and an example for create, rename and delete index?

0 Answers  

---

What is the standby server?

0 Answers  

---

What is ddl and dml commands?

0 Answers  

---

What does it mean if @@cursor_row returns a negative number?

0 Answers  

---

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 Answers  

---

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

0 Answers  

---

Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s

6 Answers   Broadridge,

---

find 2nd highest salary of person using cursor concept?

6 Answers   HCL,

---