Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5102 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
Why it is recommended to avoid referencing a floating point column in the where clause?
What are the steps to process a single select statement?
What is constraints and its types?
How to manipulate data from one table to another table ?
what type of index will get created after executing the above statement? : Sql server database administration
How to defragment indexes with alter index ... Reorganize?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
What is a result set object returned by odbc_exec()?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
What is enhanced database mirroring in sql server 2008?
What area unit the various kinds of info compression introduced in sql server 2008?
How will you hide an attribute? : sql server analysis services, ssas
What is the difference between cartesian product and cross join?
‘Order by’ is not allowed in a view how can you sort information from a view?
How to delete duplicate records based on single column from a table?
