gaurav verma


{ City } delhi
< Country > india
* Profession * software developer
User No # 52856
Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 9
Users Marked my Answers as Wrong # 8
Questions / { gaurav verma }
Questions Answers Category Views Company eMail




Answers / { gaurav verma }

Question { IBM, 15100 }

How can we insert 100 records @ a time without using for loop into the databse


Answer

To make insert query and with the excel sheet you can also
insert the record at a time.

Is This Answer Correct ?    1 Yes 2 No

Question { 8211 }

How to get last system shutdown time in Sql server when
restarted system?


Answer

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.

Is This Answer Correct ?    8 Yes 6 No