Without running these queries can you find out the query that would throw an error? 1 select 7*-2&.3 2 select 7|2&-3 3 select 7+-(.2)%(+3) 4 select ((7&2%3))
Run this code select $k You will get following error Msg 126, Level 15, State 1, Line 1 Invalid pseudocolumn "$k". What is the pseudocolumn in SQL Server?
Brent Ozar , a SQL Server MCM and MVP, posted about Top 10 SQL Server DBA Interview Questions . The question no 10 is about solving FizzBuzz problem. The FizzBuzz problem is described as Write a program that prints the numbers from 1 to 100. But for multiples of three print “Fizz” instead...
Moved to : http://beyondrelational.com/modules/19/tsql-beginners/326/tsql-beginners-challenge-13-validate-guid-values-and-perform-a-horizontal-and-vertical-count.aspx?tab=info
Moved to http://beyondrelational.com/modules/19/tsql-beginners/323/tsql-beginners-challenge-11-find-three-most-recent-builds-of-each-application-from-xml-log.aspx?tab=info
The first draft of the performance testing data for TSQL Challenge 24 is available now. You can find the scripts here . Please note that this is under draft mode and we invite your comments and suggestions on the scripts posted.
Moved to http://beyondrelational.com/modules/19/tsql-beginners/322/tsql-beginners-challenge-10-clean-up-alphanumeric-strings-by-splitting-digits-and-letters.aspx?tab=info
It is another weekend and we have completed the evaluation of TSQL Challenge 23 . We are very excited that we are able to achieve the goal of ‘completing a challenge every week’ since the last 3 weeks. We aim to complete TSQL Challenge 24 next week and in a few weeks we will be able to clear all the...
Moved to http://beyondrelational.com/modules/19/tsql-beginners/309/tsql-beginners-challenge-9-find-the-parents-and-adjacent-members-of-the-node.aspx?tab=info
Submit A Solution What is new with TSQL Challenges ‘ TSQL Challenges Team’ is working very hard to take this series to the next level. As part of this process, we have redefined the goal and structure of TSQL Challenges. Goal The goal of TSQL Challenges is to help people enhance their SET based query...
Submit A Solution The context For this challenge, you will have to analyse logs on the web server of your company. Here is the sample data you have to work with: ID VisitDate Page NbVisitors --------- -- ----------------------- --------------- ----------- 1 2009-03-23 00:00:00.000 Home 10 2 2009-03-24...
Yesterday, we saw the solution for TSQL Challenge 4 by Leonid Koyfman . Another winner of TSQL Challenge 4 is my MVP friend Pinal Dave . Pinal used a very interesting logic in his solution. What I find very interesting with these challenges is that, it helps every time to see and learn different logic...
After scanning through the entries whole night, I have identified the best solutions for TSQL Challenge 4 . Since the challenge is to write the shortest TSQL Code, I have identified the entries that produced the correct result and sorted them by the length of the code. Leonid Koyfman wrote the shortest...