Answer Posted / supriya gupta
SQL Server is a relational database management system
(RDBMS) from Microsoft that's designed for the enterprise
environment. SQL Server runs on T-SQL (Transact -SQL), a set
of programming extensions from Sybase and Microsoft that
add several features to standard SQL, including transaction
control, exception and error handling, row processing, and
declared variables.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What do you understand by a view? What does the with check option clause for a view do?
What is collation sensitivity? Explain different types.
What are the advantages of user defined function?
Do you know what are the reporting services components?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Why do you need a sql server?
Why do we use stored procedures in sql server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What stored by the master? : sql server database administration
How to create a view on an existing table in ms sql server?
How to insert multiple rows with one insert statement in ms sql server?
What is the difference between stored procedure and functions?
What are various aggregate functions that are available?
How to convert binary strings into integers in ms sql server?
How can we rewrite sub-queries into simple select statements or with joins?