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
What is the purpose of sql profiler in sql server?
What is the purpose of a table?
What is the distinction amongst delete and truncate?
How to convert numeric expression data types using the cast() function?
What is an identity?
How does recursive cte works in sql server?
Explain trigger and its types?
Is BCNF better than 2NF & 3NF? Why?
List types of tables in SQL Azure?
Is foreign key a primary key?
How do you create an execution plan?
How sql server enhances scalability of the database system?
Why use triggers?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
What is bcp? When does it use?