SQL Query to get days name of a year Specially Holiday in Bangladesh

<div dir="ltr" style="text-align: left;" trbidi="on"> <br> <br>   Here is a sql query to find Friday and Saturday in a year. Hope this will help all of us..<br> <br> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFBuqR9Gu5rbqbpLZJWkWFsjwOWD5iXt8cLW17aaEyHo7gnPpY3NQC2qG-8y2MYa7y001QFtbtFqNeYu0zatjW6ourFQQH6YtFSrizJcJkzAU7-SI55s94jN40BLc6pdTzKRNO5CjE2pgV/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/AVvXsEhFBuqR9Gu5rbqbpLZJWkWFsjwOWD5iXt8cLW17aaEyHo7gnPpY3NQC2qG-8y2MYa7y001QFtbtFqNeYu0zatjW6ourFQQH6YtFSrizJcJkzAU7-SI55s94jN40BLc6pdTzKRNO5CjE2pgV/s1600/Microsoft-SQL-Server.jpg"></a></div>   <br> </div>

  Here is a sql query to find Friday and Saturday in a year. Hope this will help all of us..   …

Read more »

Using Cursor in Sql server

<div dir="ltr" style="text-align: left;" trbidi="on"> <span style="background-color: white; color: #111111; font-family: 'Segoe UI', Arial, sans-serif; font-size: 14px;">A cursor is a set of rows together with a pointer that identifies a current row.</span><br> <br style="background-color: white; color: #111111; font-family: 'Segoe UI', Arial, sans-serif; font-size: 14px;"> <span style="background-color: white; color: #111111; font-family: 'Segoe UI', Arial, sans-serif; font-size: 14px;">In other word, </span><code style="background-color: white; border: 0px; color: #990000; font-family: Consolas, 'Courier New', Courier, mono; font-size: 11pt; font-stretch: normal; margin: 0px; padding: 0px;">Cursor</code><span style="background-color: white; color: #111111; font-family: 'Segoe UI', Arial, sans-serif; font-size: 14px;"> is a database object used by applications to manipulate data in a set on a row-by-row basis, it's like recordset in C#.</span><br> <div class="separator" style="clear: both; text-align: center;"> </div> <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> <span style="background-color: white; color: #111111; font-family: 'Segoe UI', Arial, sans-serif; font-size: 14px;"><br></span> <br> </div>

A cursor is a set of rows together with a pointer that identifies a current row. In other word, Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, it's like recordset in C#. …

Read more »

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 »