Answer / pradeep

Schema is a logical set of data. It contains tables, views,
Packages, constraints. This is treated as a whole database.
This has assigned with a unique id called as SID i.e.
System ID. Because of this ID one can create n number of
DBs on a single DB server. Obviously within the limit of
the hardware of DB server.

Do you know what are the reporting services components?

0 Answers  

---

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

0 Answers  

---

can we call stored Procedure in Function in Sql Server 2000 and vice versa.

3 Answers   C3I, eSoft, iPRO Solutions, Wipro,

---

Can a table be moved to different filegroup?

0 Answers  

---

Do you know what are pages and extents? : SQL Server Architecture

0 Answers  

---

How to return the top 5 rows from a select query in ms sql server?

0 Answers  

---

What is an indice?

0 Answers  

---

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

Tell me what is the significance of null value and why should we avoid permitting null values?

0 Answers  

---

How to delete an existing database user?

0 Answers  

---

what is the difference between procedure and function.

4 Answers   Thomson,

---

Tell me about pre-defined functions of sql?

0 Answers   EXL,

---