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
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
Can you tell me some of the common replication dmv's and their use? : sql server replication
What is change data capture (cdc) feature?
explain extended properties
Explain insert into select statement?
What structure can you implement for the database to speed up table reads?
What is the use of keyword with encryption. Create a store procedure with encryption?
What are the filtered indexes?
What are the different index configurations a table can have?
What is a data collection table?
How to assign null values to variables or columns?
What is precedence constraint?
How to use "begin ... End" statement structures in ms sql server?
Why is normalisation important?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration