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 is for xml in sql server?

0 Answers  

---

If user is owning any SQL Objects, can we drop that user

0 Answers  

---

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha

7 Answers  

---

Explain multiserver query

0 Answers  

---

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

0 Answers  

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

---

How do I view a stored procedure in sql server query?

0 Answers  

---

What is use of @@ spid in sql server?

0 Answers  

---

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  

---

What is fill factor and pad index?

0 Answers  

---

Comment,Datatypes are unlimited

0 Answers   IBM,

---

What does ss stand for sexually?

0 Answers  

---