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.
Answers were Sorted based on User's Feedback
Answer / sachin rathi
insert into TBL_Register values
(@Username,@UserTeleNo,current_timestamp)
Is This Answer Correct ? | 2 Yes | 1 No |
What is the difference between a Local temporary table and a Global temporary table? How is each one used?
What is exporting and importing utility?
How to find the date and time of last updated table?
How important do you consider cursors or while loops for a transactional database?
What is the New in SQL server 2008?
What is dbcc updateusage?
What are the benefits and tasks of object explorer? : sql server management studio
What is RAID and what are different types of RAID configurations?
Explain syntax for disabling triggers?
How to create a new schema in a database?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
Please tell me some knowledge about Clustering and how to add clustering?