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.
- 2 Answers
- 4316 Views
- Techno Solutions, I also Faced
- E-Mail Answers
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
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
What are diverse clauses that form a part of sql?
What is difference between sql and sql server?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What is page in sql server?
What are the basic features of a trigger in ms sql server?
What is difference between inner join and join?
What is an index in a database?
How to transfer a table from one schema to another?
What are the differences between decimal and float in ms sql server?
What is wrong with sql server client libarary dll, ntwdblib.dll?
Which tcp/ip port does sql server run on? How can it be changed?
What is a sql join?
What is an identity?
What is default constraint?
