In the SQL server diff between delete truncate and drop functions.what is stored procedure and it's advantages.diff between function and stored procedure.

Question

Accepted Answer

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 output parameters
Advantages of stored procedures include improved performance, security, and easier maintenance
Examples of stored procedures include ones for inserting, updating, and deleting data

In the SQL server diff between delete truncate and drop functions.what is stored procedure and it's advantages.diff between function and stored procedure.

Popular interview questions of Software Programmer

Top HR questions asked in VHS Consulting Software Programmer