1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

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

How to link up the text file to a Database table?

2 Answers   Allianz,

What is a NOLOCK?

3 Answers   NA,

What are the characteristics of modern DBMS?

0 Answers   Ericsson,

What do you understand by hotfixes and patches in sql server?

0 Answers  

What is blocking and how would you troubleshoot it?

3 Answers   HCL,




Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?

3 Answers   Apple,

How to count groups returned with the group by clause in ms sql server?

0 Answers  

Explain the properties of the relational tables?

0 Answers  

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

0 Answers  

What is the default server name for sql server?

0 Answers  

Write down the syntax and an example for create, rename and delete index?

0 Answers  

What is a deadlock and what is a live lock?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories