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
4985 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 sql server replication? : sql server replication

925

Explain the properties of sub-query in sql server?

956

How can you ensure that the database and sql server based application perform well?

1015

What is the contrast between sql and pl/sql?

1077

What command is used to rename the database?

947

Explain nested join?

926

Can we insert data if clustered index is disabled?

893

What is the simplest way to create a new database in ms sql server?

958

What is snapshot report?

153

What is the return type of executeupdate ()?

859

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

928

Define clusters?

999

Where are stored procedures in sql server?

1010

How to drop existing indexes in ms sql server?

1015

Do I need a report server to run reports in my application?

153