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,

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

0 Answers   United Healthcare,

---

Tell me in brief how sql server enhances scalability of the database system?

0 Answers  

---

how many no of arguments can be passed in procedures and functions

1 Answers   ABC,

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

0 Answers  

---

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

Define clusters?

0 Answers  

---

What is sql server agent and what are the two modes of authentication in sql server?

0 Answers  

---

Differentiate between a having clause and a where clause.

0 Answers  

---

Can we shrink data file in sql server?

0 Answers  

---

How to invoke a trigger on demand?

0 Answers  

---