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 diffence between replicaion and logshipping?

1 Answers  

---

What should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers  

---

What is Transaction?

2 Answers  

---

How to get number of days in a given year?

4 Answers   ADP,

---

Define ACID properties in a Database?

0 Answers   iNautix,

---

How to stop a loop early with break statements in ms sql server?

0 Answers  

---

What is a with(nolock)?

0 Answers  

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

---

Difference between connected and disconnected database in .net with sql server?

0 Answers   Infosys,

---

What are the advantages of using sql server over ms access or why should one use sql instead of ms access

2 Answers   CMS, Impetus,

---

How many types of objects are there?

0 Answers  

---