Answer / gaurav.verma4210

SELECT * from
sys.databases
is used for find the id of database.
SELECT create_date
FROM sys.databases
WHERE database_id = 2
Tempdb db is recreated each time SQL Server is restarted so
the created date time of TEMPDB will also give you the date
and time of the last restart of the instance.

Wht is Stuff in sql ser

2 Answers  

---

Is null vs coalesce?

0 Answers  

---

What type of Index will get created after executing the above statement?

0 Answers  

---

What are the options which must be set to allow the usage of optimistic models?

0 Answers  

---

How do I start sql server?

0 Answers  

---

---

Selet all the data from table where last name is n of employee

2 Answers  

---

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

how many instance use in sql server 2005

4 Answers   EFI, HCL,

---

Explain error handling in ssis?

0 Answers  

---

Explain various data region available in ssrs with their use?

0 Answers  

---

What is difference between table aliases and column aliases? Do they affect performance?

0 Answers  

---

How to encrypt Strored Procedure in SQL SERVER?

0 Answers  

---