SELECT * FROM Posts WHERE Title=’SQL Tricks You Must Know’

SQL is an essential language for you if you are developing data-driven applications. This post will bring you Microsoft SQL tricks that many of you might not have thought were possible. 1. Limit length of text: Use this to cut short a longer text and limit the result to specified number of characters ('Description' is your column name): SELECT ...

ASP.NET: What is the Difference Between a Web Site and a Web Project?

You might have noticed two types of web-based solutions in Visual Studio- ASP.Net Project and ASP.Net Web Site. Why do we have these two different project types? Which should you prefer? Why would I choose one over the other? I'll try to answer these questions in this post. The Major Difference The biggest difference is that with the ...