none
SQLServer Cursor migration from sybase RRS feed

  • Question

  • In SQLServer CURSORs are declared as STATIC and DYNAMIC, what criteria was taken under consideration to convert the CURSORs from SYBASE to SQLSERVER as STATIC and DYNAMIC because in SYBASE CURSORs are declared without specific keywords for static and dynamic. 

    For example 

    1) STATIC CURSOR CONVERSION: 

    In SYBASE procedure the CURSOR is declared as 

    DECLARE cursor_name CURSOR FOR .... 
    ---- 
    In SQLSERVER CURSOR is Declared as STATIC. 

    DECLARE 
    Cursor_name CURSOR LOCAL FORWARD_ONLY STATIC FOR .... 
    ------------------------------------------------- 

    2) DYNAMIC CURSOR Conversion: 

    In SYBASE CURSOR is Declared as 

    DECLARE hist CURSOR FOR ..... 
    --- 
    In SQLServer  CURSOR Declared as 

    DECLARE 
    Cursor_name CURSOR LOCAL FORWARD_ONLY DYNAMIC FOR 
    ------------------------------------------------- 

    What criteria were taken under consideration to convert the CURSORs from SYBASE to SQLSERVER as STATIC and DYNAMIC ? 
    Were in-flight transactions considered for the CURSORs declared as static? 

    SQL Server DBA

    Tuesday, October 4, 2016 7:15 AM

Answers