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.
- 2 Answers
- 4510 Views
- Techno Solutions, I also Faced
- E-Mail Answers
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 the usage of floor function in sql server.
Why union all is faster than union?
What are the different types of cursor?
What is sql server transaction log file?
What are the advantages of user-defined functions over stored procedures in sql server?
How much space does sql server 2016 take?
What is BCP? When does it used in sql server 2012?
Do you know what is a trace frag? Where do we use it?
Where sql server user names and passwords are stored in sql server? : sql server database administration
Can an automatic recovery be initiated by a user?
How to perform backup for certificates in sql server? : sql server security
What is report rendering ?
What is an identity?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
How to achieve Paging of records in SQL SERVER?
