Answer Posted / hokar
stored procedure is a set of sql statements that are stored
in the database on a server rather than storing it in the
database.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How many databases can we create in a single server?
What are the difference between primary key and unique key? : sql server database administration
How to handle error or exception in sql?
What is a partition function in sql server?
What are trace flags?
What is use of dbcc commands?
Explain the difference between delete,drop and truncate in SQL Server?
Can we write ddl in trigger?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
How to use group functions in the select clause in ms sql server?
Explain acid?
Explain what is the difference between a local and a global temporary table?
Define the one-to-one relationship while designing tables.
Differentiate between a having clause and a where clause.
what are the three command line utilities and what are their primary functions?