Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Dim command As SqlCommand = New SqlCommand("", connection)
- command.CommandText = "SELECT * FROM someTable ORDER BY orderValue @SortOrder"
- Dim sortParam As SqlParameter = New SqlParameter("@SortOrder", SqlDbType.varChar, 3)
- sortParam.Value = "ASC"
- command.Parameters.Add(sortParam)
- command.Prepare()
- reader = command.ExecuteReader()
- declare @fname int,@lname int
- select @fname=1,@lname=0
- select * from [user]
- order by case when @Fname=1 then firstname when @lname=1 then lastname end
- declare @firstSortField int, @secondSortField int
- set @firstSortField = 1
- set @secondSortField = 3
- select firstName, lastName, phoneNumber
- from customers
- order by
- case @firstSortField when 1 then firstName when 2 then lastName when 3 then phoneNumber else null end,
- case @secondSortField when 1 then firstName when 2 then lastName when 3 then phoneNumber else null end
- -- Testcase setup
- DECLARE @OrderASC bit
- SET @OrderASC = 0
- -- Statement required
- SELECT
- Users.*,
- CASE @OrderASC WHEN 1 THEN Users.Alias ELSE null END AS _SortASC,
- CASE @OrderASC WHEN 0 THEN Users.Alias ELSE null END AS _SortDESC
- FROM Users
- ORDER BY _SortASC, _SortDESC DESC
- -- Testcase setup
- DECLARE @OrderASC bit
- SET @OrderASC = 0
- -- Statement required
- SELECT
- Users.*,
- CASE @OrderASC WHEN 1 THEN Users.Alias ELSE null END AS _SortASC,
- CASE @OrderASC WHEN 0 THEN Users.Alias ELSE null END AS _SortDESC
- FROM Users
- ORDER BY _SortASC, _SortDESC DESC
Add Comment
Please, Sign In to add comment