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.

How do I debug a stored procedure in sql server?

0 Answers  

---

Explain the flow of creating a cube? : sql server analysis services, ssas

0 Answers  

---

Where sql server usernames and passwords are stored in a sql server?

0 Answers  

---

What are the features of Embedded SQL

0 Answers   HCL,

---

What are the different types of collation sensitivity?

0 Answers  

---

---

Difference between group by clause and having clause in SQL?

0 Answers   Flextronics,

---

two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?

5 Answers   CSE,

---

How do I view a procedure in sql server?

0 Answers  

---

Tell me what do you understand by a view? What does the with check option clause for a view do?

0 Answers  

---

What is SQL server agent?

2 Answers   HCL, SAP Labs,

---

Explain various On-Delete options in a DB table. Which is the default option?

0 Answers   Akamai Technologies,

---

How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.

1 Answers  

---