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 »

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 »