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 / suresh

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

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you move the resources after pausing the node? : sql server database administration

1042


what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

955


Define Joins?

975


Mention the different authentication modes in sql server.

962


Can a table be moved to different filegroup?

918


If user is owning any SQL Objects, can we drop that user

2008


Can sql servers linked to other servers like oracle?

902


When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1050


What are sub reports?

186


Explain the steps to create and execute a user-defined function in the sql server?

919


How to rebuild the master database?

1011


What are the differences between triggers and stored procedures?

990


How to write a query with a full outer join in ms sql server?

999


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

924


What is difference between line feed ( ) and carriage return ( )?

853