Answer Posted / 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.

Define Business Edition in SQL Azure?

88

---

How to generate create view script on an existing view?

562

---

Explain “not null constraint” in sql server?

524

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

497

---

Can We Use Data-grids For Our Report In Ssrs?

147

---

---

What are subqueries in sql server?

591

---

What are different backups available in sql server?

601

---

In which files does sql server actually store data?

467

---

How do you test your database? : sql server database administration

521

---

What is the order by used for?

617

---

Explain temporary table vs table variable by using cursor alternative?

517

---

What is BCNF? How is it better than 2NF & 3NF?

597

---

difference between Clustered index and non clustered index ?

570

---

Explain database normalization?

645

---

Explain trigger and trigger types?

553

---