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,

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

Does full backup break log chain?

0 Answers  

---

What happens if you add a new index to large table?

0 Answers  

---

Tell me the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---

what is isolation level at dead lock?

0 Answers   Verizon,

---

Tell me what are the advantages of using stored procedures?

0 Answers  

---

Can we do dml on views?

0 Answers  

---

How self join is different from outer join?

0 Answers   Blue Star,

---

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

0 Answers  

---

How to create a Master database in SQL server ?

0 Answers   MCN Solutions,

---

Explain filestream storage of sql server 2008?

0 Answers  

---