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 app...

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 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 »

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 »