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
5071 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

Describe the left outer join & right outer join. : sql server database administration

988

How to create a view on an existing table in ms sql server?

1117

What is the recommended total size of your memory optimized tables?

959

Do you know how to store and query spatial data?

1034

how to create a scrollable cursor with the scroll option? : Sql server database administration

1072

‘Order by’ is not allowed in a view how can you sort information from a view?

1074

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1132

Is mysql the same as sql server?

968

Can we use pragma autonomous_transaction in trigger?

951

can a database be shrunk with users active? : Sql server administration

993

Explain important index characteristics?

1023

What is the use of custom fields in report?

988

Explain about Normalization?

1053

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

2054

What is user-defined scalar function?

956