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



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 check status of stored procedure in sql server?

0 Answers  


What is sqlcmd?

0 Answers  


What is SQL Profiler what is the use of it?

2 Answers   247Customer, Steria,


Can you name some of the dml commands in sql?

0 Answers  


What stored by the model?

0 Answers  






What command do we use to rename a db?

5 Answers   IBM,


Tell me what is the significance of null value and why should we avoid permitting null values?

0 Answers  


How to attach adventureworkslt physical files to the server?

0 Answers  


Can we take the full database backup in log shipping?

0 Answers  


What is acid mean in sql server?

0 Answers  


What is the appropriate number of test cases that you can write on a database?

2 Answers   Microsoft,


what is cluster and nin-cluster index?

4 Answers  


Categories