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
- 5059 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
Explain what is scheduled job and how to create it?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What is bcp? When does it used?
Mention the differences between substr and charindex in sql server.
What is data set in report?
what is the difference between count(*) and count(1) ?
How do you set a trace flag in sql server?
What objects does the fn_my_permissions function reports on? : sql server security
How will you monitor replication latency in transactional replication? : sql server replication
How can you hide the sql server instances?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
What is difference between clustered and non clustered index?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
What are the properties of primary key?
