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.

Why we use functions in sql server?

0 Answers  

---

What are Sql Reporting Services and analysis services? Can u Explain

1 Answers  

---

where do you use Isolations?give me some exmpale?

1 Answers  

---

How to run queries with sql server management studio express?

0 Answers  

---

how to find the second salary?

10 Answers   HCL, Prithvi,

---

How to create a store procedure with encryption?

0 Answers  

---

What is the default value of CHAR type?

10 Answers   Bosch,

---

What is difference between count (*) and count 1?

0 Answers  

---

hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju

4 Answers  

---

How to delete duplicate records based on single column from a table?

0 Answers   Petranics Solutions,

---

statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance

1 Answers  

---

Do you know what are various aggregate functions that are available?

0 Answers  

---