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...

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.

Answer Posted / sachin rathi

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

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1083


Can you tell me some of the common replication dmv's and their use? : sql server replication

972


What is change data capture (cdc) feature?

1121


explain extended properties

1034


Explain insert into select statement?

998


What structure can you implement for the database to speed up table reads?

1231


What is the use of keyword with encryption. Create a store procedure with encryption?

994


What are the filtered indexes?

1091


What are the different index configurations a table can have?

1007


What is a data collection table?

1046


How to assign null values to variables or columns?

1025


What is precedence constraint?

1031


How to use "begin ... End" statement structures in ms sql server?

1114


Why is normalisation important?

987


what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1055