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
- 4136 Views
- Techno Solutions, I also Faced
- E-Mail Answers
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
What is snapshot replication?
What are data regions?
How to delete existing rows in a table?
Do you know what is user defined datatypes and when you should go for them?
How to disconnect from a sql server using mssql_close()?
What are rest-style architecture's?
Does sql server 2000 full-text search support clustering?
Can we add an identity column to decimal datatype?
What are different types of replication in sql server?
How do I open port 1433?
what are the reporting service components in SSRS?
How will you optimize a stored procedure optimization?
How to change the ownership of a schema in ms sql server?
What are sub reports and how to create them?
Difference between primary key and clustered index?
