Create PROCEDURE dbo.GetPaggingOnProc ( @startRowIndex int, @maximumRows int ) AS select RowRank,Column1,Column2,Column3 FROM ( select Column1,Column2,Column3 , ROW_NUMBER() OVER (ORDER BY SADShiftCtrl) AS RowRank from tblTestABC ) AS tblTestABCWithRowNumbers WHERE RowRank > @startRowIndex AND RowRank <= (@startRowIndex + @maximumRows)
Question 1. What Is Attribute In C#? Answer : An attributes is a declarative tag that is used to convey information about the behaviors of various elements (classes, methods, assemblies, structures, enumerators, etc). it is access at compile time or run-time. Attributes are declare with a square brackets [] which is places above the elements. [Obsolete(“Don’t use Old method, please use New method”, true)] For example consider the bellow class. If we call the old method it will through error message. public class myClass { [Obsolete("Don't use Old method, please use New method", true)] public string Old() { return "Old"; } public string New() { return "New"; } } myClass omyClass = new myClass(); omyClass.Old(); Question 2. Why Attributes Are Used? Answer : In a program the attributes are used for adding metadata, like compiler instruction or other information (comments, description, etc). C#. NET Inter...