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 are the 10 characteristics of data quality?
What is multi-statement table-value user-defined function?
What are the system database in sql server 2005?
Where do we use trace frag?
How can you fetch alternate records from a table?
How many types of triggers are there?
How do you debug a procedure in sql server?
How to find related tables in sql server?
Indexes are updated automatically is the full-text index also updated automatically?
Explain concepts of analysis services?
What is the largest component inside a field?
Why it is recommended to avoid referencing a floating point column in the where clause?
what is a correlated sub-query? : Sql server database administration
What is tempdb database? : SQL Server Architecture
Where are stored procedures in sql server?