Microsoft SQL training exercises | Dynamic SQL

Showing exercises 1-2 (out of 2)

Category: SQL
Topic: Dynamic SQL
Level: Average difficulty
Course: Advanced SQL
Exercise: Create a query which selects whatever columns, sort order and table you pass in as parameters, using dynamic SQL.

Go to exercise ...

Category: SQL
Topic: Dynamic SQL
Level: Average difficulty
Course: Advanced SQL
Exercise: Write a procedure using EXEC which varies the sort column according to the parameter value passed.

Go to exercise ...

This page has 0 threads Add post