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.

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 b tree index?

520


In how many ways you can invoke ssrs reports?

103


What is a view in sql?

582


How do triggers work?

542


What is query processing?

547






What is sparse columns of sql server 2008?

605


What does the not null constraint do?

583


What is trigger explain with program?

540


What are the steps to insert a table?

541


What are the types of database schema? : sql server analysis services, ssas

601


What is subreport?

100


What is create command?

526


Where is my database stored on the hard disk in ms sql server?

596


Explain magic tables in sql server?

555


What does REVERT do in SQL Server 2005?

569