Stickers for tag SQL Server

In SQL Server we make views for security purpose since it restricts the user to view some columns/fields of the table(s). Views show only those columns that are present in the query which is used to make a view.

dotnettricks.... —  dotnettricks.com/le... Add comments

Block

Cursor is a database object to retrieve data from a result set one row at a time, instead of the T-SQL commands that operate on all the rows in the result set at one time. We use a cursor when we need to update records in a database table in singleton fashion means row by row. Life Cycle of Cursor..

dotnettricks.... —  dotnettricks.com/le... Add comments

Block