Simple Cursor Example in SQL

    DECLARE @Pram int

    DECLARE aCursor CURSOR
    FOR
        SELECT
            *

        FROM
            TableName

    OPEN aCursor


    FETCH NEXT FROM aCursor INTO
        @Pram

    WHILE @@FETCH_STATUS = 0
        BEGIN
            --'what you want to do hear'
            FETCH NEXT FROM aCursor INTO
                @Pram
        END
    CLOSE aCursor
    DEALLOCATE aCursor

Comments

Tata Punch: A Compact SUV That Packs a Punch

Pass Values Between ASP.NET Web Pages without Session or any State Management

If the source page and target page are both ASP.NET Web pages in the same Web application, and if you transfer execution from the source page to the target page on the server by using the transfer method, the target page can access public properties in the source page. Page One <asp:TextBox ID="textCity" runat="server" Text="Brjesh"></asp:TextBox> <asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" /> public String CurrentCity { get { return textCity.Text; } } public List<String> Current ...

Message Helper for MVC Application

Message Helper for MVC Application public static class MessageExtensions { public enum MessageType { Success = 0, Info = 1, Warning = 2, Error = 3 } public static void ShowMessage( this Controller controller, MessageType messageType, string message, bool showAfterRedirect = false ) { string messageTypeKey = messageType.ToString(); if (showAfterRedirect) { controller.TempData[messageTypeKey] = message; } else { controller.ViewData[messageTypeKey] = message; } } public static HtmlString RenderMessages( this HtmlHelper htmlHelper, bool clearMessage = true ) { string messages = String .Empty; foreach ( string messageType in Enum .GetNames( t...

ASP.Net

Search This Blog