Answer / veeresh kethari

Schema is a collection of database objects.Using database
objects will manage the data in the database.

Answer / debasish nanda

A schema is a mental structure we use to organize and simplify our knowledge of the world around us. We have schemas about ourselves, other people, mechanical devices, food, and in fact almost everything.
Schemas can be related to one another, sometimes in a hierarchy (so a salesman is a man is a human).
Using it:
Find people's schemas around the area of interest, then either create trust by utilizing their schema or reframe to change their schema.

Answer / a.suresh

initial of the table is called schema.for using the
functions and other database table we are using schemas

Answer / manoj

overall view of database

How to select Distinct columns from the table, table having 20 columns and i want all coulmns

5 Answers   Wipro,

---

How will you know when statistics on a table are obsolete?

0 Answers  

---

how insert selected column only ?

3 Answers   Robert Half,

---

what are file groups?

3 Answers   Evalueserve,

---

What is Data model and how to prepare a data model.?

1 Answers   TCS,

---

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

0 Answers  

---

Explain comment on transactions?

0 Answers  

---

What is the system function to get the current user's user id?

2 Answers   HCL,

---

What is the template in sql?

0 Answers  

---

hi to all teachers,... Friends who write in the query mode Full text Search in Sql Server have experience Who make(Convert) this Stored Procedure as a normal Full text Search, which contains and .. Is used, into Advance of the tips I have thanked all friends perfection. Email : rezaafandi@yahoo.com Create PROCEDURE Sp_student @fname varchar(50), @lname varchar(50), @tel varchar(50), @code varchar(50), @adr varchar(50), @search_operation varchar(50), @totalRowCount bigint output AS begin if @search_operation = 'and' begin SELECT f3,f4,f5,f6,f7 FROM tb_student WHERE( f5 like '%' + @fname + '%' and f4 like '%' + @lname + '%' and f6 like '%' + @tel + '%' and f7 like '%' + @code + '%' and f3 like '%' + @adr +'%' ) select @totalRowCount = @@rowcount end

0 Answers  

---

How to find the last update record in SQL Server?

4 Answers  

---

What is catalog views?

0 Answers  

---