Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 get a list of table columns using the "sp_columns" stored procedure in ms sql server?

0 Answers  

which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help

3 Answers  

Will sql server 2005 allow you to reduce the size of a column?

0 Answers  

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

0 Answers  

How to create and drop temp table in sql server?

0 Answers  

why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 Answers  

default databases available in sql server and there uses ?

4 Answers   TCS,

How sql server executes a statement with nested subqueries?

0 Answers  

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

0 Answers   TCS,

what is nonclustered index

0 Answers  

What objects does the fn_my_permissions function reports on? : sql server security

0 Answers  

Do you know how to make remote connection in database?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories