Write SQL Code SQL server management
Budget: $10 – $60 USD
Write the SQL code to create two (2) stored procedures to populate transactional tables.
Write the SQL code to create two (2) business rules leveraging User-Defined Functions (UDF) in addition to a sentence or two to describe the purpose/intent of each business rule.
Write the SQL code to create two (2) computed columns leveraging UDFs.
Write the SQL code to create two (2) different complex queries.
Here is a breakdown of what is expected of you:
Correct use of parameters, variables, error handling, and explicit transaction.
Correct use of User-Defined Function, ALTER TABLE statement.
Correct use of User-Defined Function, parameters, and ALTER TABLE statement.
Correct use of at least three components below:
multiple JOIN statements
leveraging OUTPUT parameters
declaring/populating variables
including error-handling
TOP command with ORDER BY
use of subqueries
aggregate function(s)
GROUP BY | HAVING
Write the SQL code to create two (2) business rules leveraging User-Defined Functions (UDF) in addition to a sentence or two to describe the purpose/intent of each business rule.
Write the SQL code to create two (2) computed columns leveraging UDFs.
Write the SQL code to create two (2) different complex queries.
Here is a breakdown of what is expected of you:
Correct use of parameters, variables, error handling, and explicit transaction.
Correct use of User-Defined Function, ALTER TABLE statement.
Correct use of User-Defined Function, parameters, and ALTER TABLE statement.
Correct use of at least three components below:
multiple JOIN statements
leveraging OUTPUT parameters
declaring/populating variables
including error-handling
TOP command with ORDER BY
use of subqueries
aggregate function(s)
GROUP BY | HAVING