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 admin …

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 tutorial series with a nice Monday and become a MVC guy till the end of the week. 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. …

Read more »