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

How to remove duplicate rows from table except one?

742


What is scd (slowly changing dimension)? : sql server analysis services, ssas

762


What is the difference between dropping a database and taking a database offline?

907


Can we add a cpu to sql server?

703


Which sql server is best?

728






Explain what role entity and relationship play in an ER diagram.

789


How do I trace a query in sql server?

704


What do you mean by the term 'normalization'?

857


What are the different types of data sources in ssrs?

165


What is primary key index?

706


What is the syntax for encrypting a column in SQL Server?

761


explain extended properties

713


What are the different types of sub-queries?

765


Is mysql the same as sql server?

684


How do I start sql server 2016?

688