Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---

What is a job?

3 Answers  

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

---

Explain why variables called the most powerful component of ssis?

0 Answers  

---

What is the purpose of UPDATE STATISTICS?

2 Answers  

---

What is a filestream?

0 Answers  

---

What are the aggregate and scalar functions?

0 Answers  

---

How to create function without parameter in sql server?

0 Answers  

---

What gets stored inside msdb database?

0 Answers   Abacus,

---

How to get a list of all tables with "sys.tables" view in ms sql server?

0 Answers  

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

What is the difference between cube operator and rollup operator? : SQL Server Architecture

0 Answers  

---