VHS Consulting Software Programmer Interview Questions and Answers

Explaining SQL server functions and stored procedures

• DELETE removes specific rows from a table, TRUNCATE removes all rows from a table, DROP removes a table from the database

• Stored procedures are precompiled SQL statements that can be reused, improving performance and security

• Functions return a single value, while stored procedures can return multiple values or none at all

• Stored procedures can also have input and outpu...read more