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 »

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 »