Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
... flagging an error ...
Insert Into @Temp Values('Jane', 'Purple')
Declare @SortBy VarChar(20)
Declare @SortDirection VarChar(10)
Set @SortBy = 'Name'
Set @SortDirection = 'Desc'
If @SortDirection = 'DESC'
Select *
From @Temp
Order By Case When @SortBy = 'Name'
Then Name
Else FavoriteColor
End [!]DESC[/!]
Else
Select *
From @Temp
Order By Case When @SortBy = 'Name'
Then Name
Else FavoriteColor
End [!]Asc[/!]