Let’s say the table in the database is named as TBL

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.

Question Posted / raghu_113

2 Answers
5001 Views
Techno Solutions, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Let’s say the table in the database is named as TBL_Register. The fields in this table include: ..

Answer / suresh

insert into TBL_Register values
(@Username,@UserTeleNo,getdate())

Is This Answer Correct ?

8 Yes

0 No

Let’s say the table in the database is named as TBL_Register. The fields in this table include: ..

Answer / sachin rathi

insert into TBL_Register values
(@Username,@UserTeleNo,current_timestamp)

Is This Answer Correct ?

2 Yes

1 No

Post New Answer

More SQL Server Interview Questions

What is standby servers? Explain types of standby servers.

0 Answers

What are relationships and mention different types of relationships in the dbms

0 Answers

What is the ‘fillfactor’?

0 Answers

Explain different types of self contained sub query?

0 Answers

How to select some specific rows from a table in ms sql server?

0 Answers

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

0 Answers Amdocs, Apps Associates,

what are the critical issues you have resloved in your company

0 Answers Wipro,

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers

Write a SQL command to insert and update only a particular field?

0 Answers ADITI,

What are the advantages of using cte?

0 Answers

What are four major operators that can be used to combine conditions on a where clause?

0 Answers

What is difference between commit and rollback when used in transactions?

0 Answers

For more SQL Server Interview Questions Click Here