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
4970 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 is the purpose of a table?

905

What are the different types of backups that exist?

1108

What are data files?

981

What is partition, how will you implement it? : sql server analysis services, ssas

990

What is normalization and its types?

959

Can we use having clause without group by?

929

What is the difference between row_number and dense_rank?

825

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

854

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

911

Explain something about security and SQL Azure?

110

Give an example of SQL injection attack ?

924

Does an index slow down updates on indexed columns?

906

What is a full text index?

871

How many tables can be joined in SQL Server?

1002

What are parameterized reports?

191