insert into TBL_Register values (@Username,@UserTeleNo,getdate())

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.

Question Posted / suresh

2 Answers
5163 Views
Techno Solutions, I also Faced
E-Mail Answers

Answer Posted / suresh

insert into TBL_Register values
(@Username,@UserTeleNo,getdate())

Is This Answer Correct ?

8 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are page splits?

1047

What is difference between count (*) and count column?

948

What is tablesample?

1172

What is ms sql server reporting services?

1119

How can a database be repaired?

1032

What are the limitations in ssrs on sql server express edition?

193

What is built-in function?

1053

Can you explain important index characteristics?

1029

What is the difference between dbcc indexdefrag and dbcc reindex?

1031

What is a partitioned view?

1049

what is denormalization and when would you go for it? : Sql server database administration

1256

How to Update from select query in sql server?

1111

What is the use of keyword with encryption.

1081

Explain how you can configure a running aggregate in SSRS?

169

How exceptions can be handled in sql server programming?

1069