Test your Sql Query Online

-
Hi Guys i found a good tool to test simple Sql query online the link is as below. This time i used this to test the pivot functionality.

The Pivot Sql Function converts the row wise category data into column wise metrix/pivot kind of data.

http://www.sqlfiddle.com/#!3/b228e/3
another good example is below
http://sqlfiddle.com/#!6/2ba07/131

Comments

Post a Comment

Popular posts from this blog

Authorize.net Integration eCommerce Payment Gateway ( Direct Post Method New! )

-
https://developer.authorize.net/integration/fifteenminutes/csharp These steps assume that your web server is on the public internet and can be accessed via a domain name or IP address. Step 1:Sign up for a Test Account. Sign up for a test account to obtain an API Login ID and Transaction Key. These keys will authenticate requests to the payment gateway. Step 2: Download the Authorize.Net C# SDK and include it in your project Download the SDK Create a new ASP.NET MVC application and add a reference to the AuthorizeNET.dll from the SDK Step 3: Modify web.config. Add the AuthorizeNET.Helpers namespace to the web.config, under system.web/pages: ... Step 4: Create a checkout form that posts directly to Authorize.Net Add the following code to the Home/Index View - this will create a form which will submit a test transaction to Authorize.Net (with hardcoded values). This code uses the SDKs CheckoutFormBuilder to create the form for you - just include your API login and Transa...
Read more

Visual Studio debuggin perfromance Improvement.

-
Solution Improving Visual studio debugging performance. 1. Disable Intellitrace completely 2. Tools -> Options -> IntelliTrace -> [ ] Enable IntelliTrace 3. Delete all the Visual studio breakpoints a. You may need to delete all your breakpoints---note that you need to click the "delete all breakpoints" button (or use Ctrl-Shft-F9), NOT just delete them one by one. If Visual Studio has mangled your solution settings the latter will not work. You may need to add a breakpoint first, in order for this to work (clever, eh?) i. If worst comes to worst, you may need to delete your .suo file and let Visual Studio start a new one from scratch. Note that you will lose your personal solution configuration settings, however (only for this solution, not any others). However, you may want to move/rename the file temporarily until you determine whether or not this is the problem; that way, you can always move it back. I have seen some online resources recommend del...
Read more

How to speed up your system

-
I found very nice artical about how to speed up your system at http://www.howtogeek.com/107280/the-best-tips-for-speeding-up-your-windows-pc/?utm_source=newsletter&utm_medium=email&utm_campaign=040312 The Best Tips for Speeding Up Your Windows PC If your computer has started to slow down, there are many options for speeding it up. Below, we show you some of the best tips for speeding up your PC, some from previous HTG articles and some described here. Turn off Startup Programs When you install a program in Windows, it may add a small program that runs when Windows starts. After installing a lot of software, your boot up process could become slow. If there are programs you don’t use much, they probably don’t need to start every time Windows does. You can disable startup programs manually or use the free tool CCleaner. You can also use Soluto to speed up boot time. Clean Up Unnecessary Files on Your Computer As you use your computer, files collect in all kinds of pla...
Read more