Answer / Bhanu Pratap Sharma

The system databases in SQL Server 2008 include 'master', 'model', 'msdb', and 'tempdb'. Each of these databases serves a specific purpose, such as storing server-level metadata (master), defining the model for user databases (model), storing system-related data (msdb), and providing temporary storage space (tempdb).

How to get a list of columns in a view using the "sp_help" stored procedure?

1 Answers  

---

what is difference between Enterprise Manager and Query Analyer

6 Answers   CTS,

---

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,

---

How to execute a sql statement using odbc_exec()?

1 Answers  

---

Explain the working of sql privileges?

1 Answers  

---

What do you understand by coalesce in sql server?

1 Answers  

---

What happens when transaction log is full?

1 Answers  

---

Explain the difference between HTTP and HTTPS in database?

1 Answers   Wipro,

---

Which data type columns are the best candidates for full-text indexing?

1 Answers  

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

What are the restrictions applicable while creating views? : SQL Server Architecture

1 Answers  

---

What is factless fact table? : sql server analysis services, ssas

1 Answers  

---