Tags

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,


SQL Server String Puzzles

Here I come with cunning SQL Server String Puzzles / Queries which are frequently asked in SQL / Database / MSBI / SQL BI interviews from developer to Architect level. All the questions below seems easy but it would be complex situation when you face these query in Interview time.

If you have any puzzle in mind or if you want me to solve some puzzle or if you have difficulty in solving business problem please email me @ pawankkmr@gmail.com. I would be happy to help.

This would be best for you to go through following SQL SERVER String Interview questions / puzzles before attend any technical interview. Please visit Complete list of SQL SERVER Puzzles @ below- SQL SERVER Puzzles

Sr No SQL Server String Puzzle
1 SQL Puzzle | The String Puzzle – Combine data by one column and then another one using comma
2 SQL Puzzle | [ Count Spaces in a string Puzzle ]
3 SQL Puzzle | Convert a string into a table n number of times ( n = length of the string )
4 SQL Puzzle | Convert each character of a string into a table without any delimiter
5 SQL Puzzle | Split String Puzzle – II (Linked In)
6 SQL Puzzle | [ Replace 6 or more Consecutive Digits with x from a string Puzzle ]
7 SQL Puzzle | [ Multiple Ways to Split a String Puzzle ]
8 SQL Puzzle | [ Count Spaces in a string Puzzle ]
9 SQL Puzzle | Get Last 4 Characters from a String without Left & Right Function
10 SQL Puzzle | Count different type of characters from a string Puzzle
11 SQL Puzzle | Find Strings that contains % Character
12 SQL Puzzle | The ASCII Puzzle – II
13 SQL Puzzle | REVERSE a String Without Using Reverse Function / Recursive CTE / While Loop

Add a comment if you have any  SQL puzzle in mind. I would love to learn it. We all need to learn.

Enjoy !!! Keep Learning

Pawan Khowal 

Http://MSBISkills.com

Advertisements