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 »