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
How to convert numeric expression data types by assignment operations?
What is table value parameters (tvp)?
Write a query for primary key constraint with identity key word?
What is filtered index?
How many triggers are possible per table?
How to list all stored procedures in the current database using ms sql server?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
What are the types of database schema? : sql server analysis services, ssas
What are the steps you must follow to hide sql server instances?
Explain what are various ways to enhance the ssrs report?
Explain what are page splits? : SQL Server Architecture
what is unique and xaml nonclustered index
What are temporal tables in sql server 2016?
What is a filestream?
What does the update command do?