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 / suresh
insert into TBL_Register values
(@Username,@UserTeleNo,getdate())
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Can you move the resources after pausing the node? : sql server database administration
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Define Joins?
Mention the different authentication modes in sql server.
Can a table be moved to different filegroup?
If user is owning any SQL Objects, can we drop that user
Can sql servers linked to other servers like oracle?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What are sub reports?
Explain the steps to create and execute a user-defined function in the sql server?
How to rebuild the master database?
What are the differences between triggers and stored procedures?
How to write a query with a full outer join in ms sql server?
Write down the syntax and an example for create, rename and delete index?
What is difference between line feed ( ) and carriage return ( )?