Important SQL Query

<div dir="ltr" style="text-align: left;" trbidi="on"> Here are some important and necessary SQL server queries.<br> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-SWCddeCn8G3pLZuSvBCjtNNrv_VfdPZk0wSbCA2jqSPRrUBCkmY8MTgEpX51kTzqYfyZCNncRxQca3JznDbLQV2dfvQMhLTGp-7s1iYtoDHba9s0Ru7LX3FnrGQWwyHOdRWQ2CLswqMW/s1600/Microsoft-SQL-Server.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-SWCddeCn8G3pLZuSvBCjtNNrv_VfdPZk0wSbCA2jqSPRrUBCkmY8MTgEpX51kTzqYfyZCNncRxQca3JznDbLQV2dfvQMhLTGp-7s1iYtoDHba9s0Ru7LX3FnrGQWwyHOdRWQ2CLswqMW/s1600/Microsoft-SQL-Server.jpg"></a></div> <br> </div>

Here are some important and necessary SQL server queries.

Read more »

How to upload data from excel using Sql Query

<div dir="ltr" style="text-align: left;" trbidi="on"> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgT7G1eJcqZz28rSyRExVdmjMlNLvZhJBDVVxBpjLKnJ1hyHZzpbLWEIv9H6n3lmu70UIibNvie7tED43uSfrMmhp_o4hI17vObHHws-foXt6yHatjBeB3r0iWpfn-LDfPNBgWTQBAzgvdH/s1600/excel_sqlserver.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgT7G1eJcqZz28rSyRExVdmjMlNLvZhJBDVVxBpjLKnJ1hyHZzpbLWEIv9H6n3lmu70UIibNvie7tED43uSfrMmhp_o4hI17vObHHws-foXt6yHatjBeB3r0iWpfn-LDfPNBgWTQBAzgvdH/s1600/excel_sqlserver.jpg" width="320"></a></div> <br> Today i will show you here how to upload data from excel using Sql Query.<br>  First run the following code after running SQL SERVER as admin<br> <br> </div>

Today i will show you here how to upload data from excel using Sql Query.  First run the following code after running SQL SERVER as adm...

Read more »

MVC 5 step by step:1

<div dir="ltr" style="text-align: left;" trbidi="on"> <div style="background-color: white; color: #111111; font-family: 'Segoe UI', Arial, sans-serif; font-size: 14px;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFN1rhN5arXM4FggJfd4nMOGtpPLHrzA6bBvwdPYGceQX2I12fHm0msD34qquczPdkQJTl9wifWPZ9dU79Iykt4zBuWfu3XIuBFZn4oWgDCNRPxDCdT9nw61ll0adNwXeMnOc9L-vjVda3/s1600/download.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFN1rhN5arXM4FggJfd4nMOGtpPLHrzA6bBvwdPYGceQX2I12fHm0msD34qquczPdkQJTl9wifWPZ9dU79Iykt4zBuWfu3XIuBFZn4oWgDCNRPxDCdT9nw61ll0adNwXeMnOc9L-vjVda3/s1600/download.jpg"></a>As the title promises “Learn MVC in 7 days” , so this article will have 7 articles i.e. 1 article for each day. So start reading this tutorial series with a nice Monday and become a MVC guy till the end of the week.</div> <div style="background-color: white; color: #111111; font-family: 'Segoe UI', Arial, sans-serif; font-size: 14px;"> Day 1 is kind of a warm up. In this first day we will understand Why Asp.Net MVC over Webforms ? , Issues with Webforms and we will do two Lab’s one around controller and the around views.</div> <br> </div>

As the title promises “Learn MVC in 7 days” , so this article will have 7 articles i.e. 1 article for each day. So start reading this tuto...

Read more »

Knockout built-in Bindings Quick Reference

<div dir="ltr" style="text-align: left;" trbidi="on"> <div style="clear: both;"> <div class="firstpara"> You can learn about Knockout by using the link <a class="link" href="http://knockoutjs.com/documentation/introduction.html" target="_blank">Knockout Documentation</a>. There is a pretty good guide about Knockout. In this article, I am going to share a handy and a really concise quick reference about the binding with syntax in Knockout.<br> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvWdPNoeK3ndE_16UeqAV2AOT5M4GU6P0WyV8W6rrVfIM0EokTW04kAapFOknXZg3kM6-DOFaq8YYtyAz3sejOMomtgGhskn5FPwnW6flzu5w9hywdsMx9gw2-XNVwo2Dl9QKAB4sWj2j8/s1600/download.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvWdPNoeK3ndE_16UeqAV2AOT5M4GU6P0WyV8W6rrVfIM0EokTW04kAapFOknXZg3kM6-DOFaq8YYtyAz3sejOMomtgGhskn5FPwnW6flzu5w9hywdsMx9gw2-XNVwo2Dl9QKAB4sWj2j8/s1600/download.jpg"></a></div> <br></div> </div></div>

You can learn about Knockout by using the link Knockout Documentation . There is a pretty good guide about Knockout. In this article, I ...

Read more »

Knockout Binding Context Variable

<div dir="ltr" style="text-align: left;" trbidi="on"> <div style="clear: both;"> <div class="firstpara"> Basically, binding context is an object that holds data, which is referenced from your view-model bindings. While applying bindings, Knockout automatically creates and manages a hierarchy of binding contexts. Let's have a look on different types of binding context with example.<br> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvWdPNoeK3ndE_16UeqAV2AOT5M4GU6P0WyV8W6rrVfIM0EokTW04kAapFOknXZg3kM6-DOFaq8YYtyAz3sejOMomtgGhskn5FPwnW6flzu5w9hywdsMx9gw2-XNVwo2Dl9QKAB4sWj2j8/s1600/download.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvWdPNoeK3ndE_16UeqAV2AOT5M4GU6P0WyV8W6rrVfIM0EokTW04kAapFOknXZg3kM6-DOFaq8YYtyAz3sejOMomtgGhskn5FPwnW6flzu5w9hywdsMx9gw2-XNVwo2Dl9QKAB4sWj2j8/s1600/download.jpg"></a></div> <br></div> </div></div>

Basically, binding context is an object that holds data, which is referenced from your view-model bindings. While applying bindings, Kn...

Read more »

Knockout CRUD Operations using MVC4

<div dir="ltr" style="text-align: left;" trbidi="on"> <div class="firstpara"> As you know Knockout is a javascript library that allow you to bind html elements to any data model. You can also use Knockout for Insert, Update, Delete and Retrieve operations. This article will demonstrate, how to use Knockout with MVC4 for CRUD (Create, Read, Update, Delete) Operations.<br> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvWdPNoeK3ndE_16UeqAV2AOT5M4GU6P0WyV8W6rrVfIM0EokTW04kAapFOknXZg3kM6-DOFaq8YYtyAz3sejOMomtgGhskn5FPwnW6flzu5w9hywdsMx9gw2-XNVwo2Dl9QKAB4sWj2j8/s1600/download.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvWdPNoeK3ndE_16UeqAV2AOT5M4GU6P0WyV8W6rrVfIM0EokTW04kAapFOknXZg3kM6-DOFaq8YYtyAz3sejOMomtgGhskn5FPwnW6flzu5w9hywdsMx9gw2-XNVwo2Dl9QKAB4sWj2j8/s1600/download.jpg"></a></div> <br></div> </div>

As you know Knockout is a javascript library that allow you to bind html elements to any data model. You can also use Knockout for Inser...

Read more »

Different Types of SQL Server Functions

<div dir="ltr" style="text-align: left;" trbidi="on"> <div style="clear: both;"> <div class="firstpara"> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZf6uSZL7E6G_PYpTGc0lDsIMMrCOVnhaHvq1kjfNu4O6wAuKwOjuCUCswvZAWXd5sM9n3jcCJQBgsMgn-MOnFuJ_dGDicFSBApe2wNntnwIU9uJzf9wCiucQ-14refzmhvp7FMAgMHuqc/s1600/images.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZf6uSZL7E6G_PYpTGc0lDsIMMrCOVnhaHvq1kjfNu4O6wAuKwOjuCUCswvZAWXd5sM9n3jcCJQBgsMgn-MOnFuJ_dGDicFSBApe2wNntnwIU9uJzf9wCiucQ-14refzmhvp7FMAgMHuqc/s1600/images.jpg"></a></div> <br> Function is a database object in Sql Server. Basically it is a set of sql statements that accepts only input parameters, perform actions and return the result. Function can return only single value or a table. We can’t use function to Insert, Update, Delete records in the database table(s).</div> </div></div>

Function is a database object in Sql Server. Basically it is a set of sql statements that accepts only input parameters, perform act...

Read more »

SQL SERVER -1:Store Procedures

<div dir="ltr" style="text-align: left;" trbidi="on"> <h3 style="text-align: left;"> When you need to store or retrieve data that is accessing and manipulating data within a database is a rather straightforward operation in SQL server database, and so we will go for T-SQL with four simple commands – <code>SELECT</code>, <code>INSERT</code>, <code>DELETE</code>, and <code>UPDATE</code>, and perform all the required tasks. The skill in working with databases lies in being able to not just work with these commands, but also complete each unit of work efficiently. </h3> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZf6uSZL7E6G_PYpTGc0lDsIMMrCOVnhaHvq1kjfNu4O6wAuKwOjuCUCswvZAWXd5sM9n3jcCJQBgsMgn-MOnFuJ_dGDicFSBApe2wNntnwIU9uJzf9wCiucQ-14refzmhvp7FMAgMHuqc/s1600/images.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZf6uSZL7E6G_PYpTGc0lDsIMMrCOVnhaHvq1kjfNu4O6wAuKwOjuCUCswvZAWXd5sM9n3jcCJQBgsMgn-MOnFuJ_dGDicFSBApe2wNntnwIU9uJzf9wCiucQ-14refzmhvp7FMAgMHuqc/s1600/images.jpg"></a></div> <h3 style="text-align: left;"> <br>  </h3></div>

When you need to store or retrieve data that is accessing and manipulating data within a database is a rather straightforward operation ...

Read more »