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.

How to Insert multiple rows with a single insert statement?

0 Answers  

---

Mention the 3 ways to get a count of the number of records in a table.

0 Answers  

---

What are logical/boolean operations in ms sql server?

0 Answers  

---

What is the difference between for trigger and after trigger?

0 Answers  

---

What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,

---

How can you check the version of sql server?

0 Answers  

---

What is the use of group by clause?

0 Answers  

---

Is natural join and equi join same?

0 Answers  

---

what is index seek and index scan?

2 Answers  

---

How do you load large data to the SQL server database?

2 Answers  

---

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 Answers  

---

What are the 7 disadvantages to a manual system?

0 Answers  

---