What is subquery? Subquery is just a query inside of a query. Why Subquery? Break down complex logic Simplify reading Subqueries can be replaced by joins. But some times Joins can be complex. Other thing is we are not allowed to put aggregates in WHERE. But we can put it aggreagates inside subquery . Where to Use? We can put sub queries in three main places in query. SELECT FROM WHERE Using in SELECT Access informations from tables withing select query Query must return a single(scalar) value Creates a dynamic table. Useful for breaking down queries. Query must be aliased. Note : I have used Adventureworks 2012 database for following queries Using with FROM With WHERE Useful for comparing values from other tables Predicates used with subqueries IN Confirm column value exist in subquery Similar to inner join EXISTS Returns true if subquery returns value Used with correlated queries Correlated subquery Pass outer query column into subquery ALL Compares column
Client side form validation increases User friendliness. User doesn’t want to wait for page refresh and see form validation errors.
So Bootstrap has great drop down UI control. How about improve it. So I just created a code pen to enhance some UI features of bootstrap drop down. So I have added some animations using Animate.css and some custom CSS. Code pen
Dependency Injection It is a software design pattern that implements the Inversion of control. Dependency injection is vital for loosely coupled software development. More about DI So I just created a video to Show you guys How to implement Unity Dependency Injection in ASP.NET MVC Watch video Download Source Code
So I got this error while working It says no permission on object sp_delete_database_backuphistory. I get it fixed from granting execution permission to above object
Things can go wrong in sql operation. So how we handle Errors in sql server. We can detect errors in
Concurrency and locks in sql server
Why transactions. We generally works with multiple tables in one operation. May be we want to insert data to order
How to create Ionic sliding menu
My One of Clients came with a new requirement. It is creating Mobile app for his business. Actually It was mobile CRM application. So in that moment I didn’t have any mobile application development experience. But Actually I wanted to experience Mobile application development. So I experienced some technologies. After doing some researches I came up with Ionic framework. More about Ionic It was very easy to learn and I did quick learn and I could deliver perfect app for my client. So I thought it is good to do some post about Ionic. So I created a Video on How to create sample Ionic Tabview app. Watch video download source code I thought it may help some one.