//
archives

Challenges

This category contains 2 posts

Find stored procedure in all databases


Are you looking for a way to find procedure in all databases? In this post you will find a way to search procedure in all databases. There are some other ways to do so but here it will be demonstrated by using dynamic SQL. The attached procedure will prepare a query with respect to all … Continue reading

SQL Challenge 1


Problem: how do I write a query in SQL to do this? I have a table: name mark u 23 h 38 j 20 p 83 and for output we need name mark mark2 u 23 38 h 38 20 j 20 83 p 83 0 Solution: The query to accomplish the task: is ;WITH … Continue reading