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.

where do you use Isolations?give me some exmpale?

1 Answers  

---

How to execute a sql statement using mssql_query()?

0 Answers  

---

Explain difference between control flow and data flow?

0 Answers  

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  

---

What do you understand by coalesce in sql server?

0 Answers  

---

---

How to rebuild master databse?

0 Answers  

---

Explain raiserror in sql server?

0 Answers  

---

What structure can you implement for the database to speed up table reads?

0 Answers  

---

What do you mean by SQL injection attack?

0 Answers   Ittiam Systems,

---

Is index a datbase objects in sql server?

2 Answers  

---

1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?

10 Answers   Perot Systems,

---

Tell me what is difference between view and materialized view?

0 Answers  

---