what is the purpose of creating view is sql server 2000

13 Answers   Wipro,

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   HCL,

---

What are the new features in SQL Server 2005?

3 Answers   Emphasis,

---

How to query multiple tables jointly?

0 Answers  

---

How many categories of data types used by sql server?

0 Answers  

---

New concepts of sql server 2005 use in your project.

0 Answers   TCS,

---

What is data integrity? Explain constraints?

1 Answers   Thinksoft,

---

What is sql server locking?

0 Answers  

---

1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

12 Answers   Accenture,

---

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 Answers  

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

0 Answers  

---

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

---