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

Postback Page using Javascript in ASP.net

Postback Page using Javascript in ASP.net For Calling Function: __doPostBack('__Page', ''); Function: function __doPostBack(eventTarget, eventArgument) { if (!theForm.onsubmit || (theForm.onsubmit() != false)) { theForm.__EVENTTARGET.value = eventTarget; theForm.__EVENTARGUMENT.value = eventArgument; theForm.submit(); } }

Highest salary query in sql server

DECLARE @dtDepartment TABLE ( Id int, Name varchar(100) ) DECLARE @dtEmployee TABLE ( Id int, Name varchar(100), DeptId int ) DECLARE @dtEmpSalary TABLE ( Id int, EmpId int, Salary int ) INSERT INTO @dtDepartment VALUES(1,'.NET') INSERT INTO @dtDepartment VALUES(2,'Java') INSERT INTO @dtEmployee VALUES(1,'Brijesh',1) INSERT INTO @dtEmployee VALUES(2,'Parth',1) INSERT INTO @dtEmployee VALUES(3,'Ruchir 1',1) INSERT INTO @dtEmployee VALUES(4,'Jainik 1',1) INSERT INTO @dtEmployee VALUES(5,'Ruchir',2) INSERT INTO @dtEmployee VALUES(6,'Jainik',2) INSERT INTO @dtEmployee VALUES(7,'Jainik',2) INSERT INTO @dtEmployee VALUES(8,'Jainik',2) INSERT INTO @dtEmpSalary VALUES(1,1,10000) INSERT INTO @dtEmpSalary VALUES(2,2,15000) INSERT INTO @dtEmpSalary VALUES(3,3,12000) INSERT INTO @dtEmpSalary VALUES(4,4,12000) INSERT INTO @dtEmpSalary VALUES(5,5,12000) INSERT INTO @dtEmpSa...

ASP.Net

Search This Blog