insert into TBL_Register values (@Username,@UserTeleNo,current

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 / sachin rathi

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

Answer Posted / sachin rathi

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

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is collation sensitivity?

1039

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

969

How to create user defined functions with parameters?

1207

What are the common performance issues in sql server?

899

Do you know what are different types of replication in sql server?

1075

What are the different Topologies in which Replication can be configured?

1165

What are distributed partitioned views?

1050

How can I tell if sql server is 32 or 64 bit?

937

Define Joins?

1011

According to you what goes into making the best database administrator? : sql server database administration

964

What are the steps you should follow to start sql server in single-user mode?

879

Explain active/passive and active/active cluster configurations?

1047

Why do we backup Active Directory ?

1029

What is the maximum length of an alert name?

997

Explain the microsoft sql server delete command?

999