Answer / gautam k panjikar

getdate()

Answer / rajkumar v

select convert(varchar,getdate(),105)

Answer / anto

select getdate()

Answer / mt

select getdate();

What is a field in a table?

0 Answers  

---

what are different types of backups available in sql server? : Sql server database administration

0 Answers  

---

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,

---

How do I view views in sql server?

0 Answers  

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,

---

How do I completely remove sql server instance?

0 Answers  

---

What happens if time-only values are provided as date and time literals?

0 Answers  

---

Difference Between varchar and nvarchar datatype?

3 Answers   Satyam,

---

what is Constraint? How many types of constraints in SQL ?

38 Answers   HCL, IBM, NIIT, Wipro,

---

If any stored procedure is encrypted, then can we see its definition in activity monitor?

0 Answers  

---

How maney row would be print after join if A table have 100 rows and B table have 50 rows...

9 Answers   Hewitt,

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---