Structured Query Language Blog Posts

  • FETCH_STATUS function in sql server@@FETCH_STATUS function determines whether FETCH keyword has successfully retrieved a row from the current cursor. The value of @@FETCH_STATUS is undefined before any fetches have occurred on the... SQL is a standard interactive and programming lang...
  • CURSOR_ROWS function in Sql Server@@CURSOR_ROWS function returns number of rows currently in the last opened cursor. The number returned by @@CURSOR_ROWS is negative if the last cursor was opened asynchronously. Keyset-driver or... SQL is a standard interactive and programming langu...
  • NULLIF FunctionNULLIF function in sql server with examples. NULLIF function returns null value if the two specified expressions are equivalent. NULLIF is equivalent to a searched CASE function in... SQL is a standard interactive and programming lang...
  • REPLICATE FunctionREPLICATE function of sql server with examples. REPLICATE is used to repeat a string with specified number of times.  Syntax of REPLICATE Function : REPLICATE (... SQL is a standard interactive and programming language for querying a...
  • CASE Expression
    on Aug 7, 2012 in Sql Server CASE Expression
    CASE expression in sql server with examples. CASE expression enables many forms of conditional processing to be placed into a SQL statement. By using CASE, more logic can be placed into SQL... SQL is a standard interactive and programming langua...
  • FILE_ID Function
    on Aug 7, 2012 in Sql Server FILE_ID Function
    FILE_ID function in sql server with examples. FILE_ID function is used to get file identification number for logical file name in the current database. Syntax of FILE_ID Function : FILE_ID (... SQL is a standard interactive and programming lan...
  • SQL Wildcards
    on Jun 13, 2012 in SQL Wildcards
      SQL wildcards can substitute for one or more characters when searching for data in a database. SQL wildcards must be used with the SQL LIKE operator. With SQL, the following... SQL is a standard interactive and programming language...
  • SQL TOP Clause
    on Mar 28, 2012 in TOP Clause SQL SQL TOP Clause
    The TOP clause is used to specify the number of records to return.The TOP clause can be very useful on large tables with thousands of records. Returning a large number of records can impact on... SQL is a standard interactive and programming languag...
  • SQL TOP Clause
    on Mar 2, 2012 in TOP Clause SQL SQL TOP Clause
    Now we want to select only the two first records in the table above. We use the following SELECT statement: SELECT TOP 2 * FROM Persons Now we want to select only 50% of the records in the table above.
  • Integration Services
    on Feb 16, 2011 in Integration Services
    SQL Server Integration Services (SSIS) is Microsoft’s new enterprise class data Extract, Transform, and Load (ETL) tool. SSIS is a completely new product built from the ashes of SQL Server 2000’s Data Transformation Services (DTS). SSIS offers a...
  • Integration Services
    on Feb 16, 2011 in Integration Services
    SQL Server Integration Services (SSIS) is Microsoft’s new enterprise class data Extract, Transform, and Load (ETL) tool. SSIS is a completely new product built from the ashes of SQL Server 2000’s... SQL is a standard interactive and programming...
  • Analysis Services
    on Jan 21, 2011 in Analysis Services
    Analysis Services delivers Online Analytical Processing (OLAP) and Data Mining functionality for business intelligence applications. As its name suggests, Analysis Services provides a very robust environment for the detailed analysis of data. It do...
  • Reporting Services
    on Jan 21, 2011 in Reporting Services
    Reporting Services is a Web service–based solution for designing, deploying, and managing flexible, dynamic Web-based reports, as well as traditional paper reports. These reports can contain information from virtually any data source. Because Rep...
  • Analysis Services
    on Jan 21, 2011 in Analysis Services
    Analysis Services delivers Online Analytical Processing (OLAP) and Data Mining functionality for business intelligence applications. As its name suggests, Analysis Services provides a very robust... SQL is a standard interactive and programming lang...
  • Integration Services
    on Jan 21, 2011 in Integration Services
    SQL Server Integration Services (SSIS) is Microsoft’s new enterprise class data Extract, Transform, and Load (ETL) tool. SSIS is a completely new product built from the ashes of SQL Server 2000’s Data Transformation Services (DTS). SSIS offers a...
  • Reporting Services
    on Jan 21, 2011 in Reporting Services
    Reporting Services is a Web service–based solution for designing, deploying, and managing flexible, dynamic Web-based reports, as well as traditional paper reports. These reports can contain... SQL is a standard interactive and programming languag...
  • Reporting Services
    on Jan 21, 2011 in Reporting Services
    Reporting Services is a Web service–based solution for designing, deploying, and managing flexible, dynamic Web-based reports, as well as traditional paper reports. These reports can contain information from virtually any data source. Because Rep...
  • Analysis Services
    on Jan 21, 2011 in Analysis Services
    Analysis Services delivers Online Analytical Processing (OLAP) and Data Mining functionality for business intelligence applications. As its name suggests, Analysis Services provides a very robust environment for the detailed analysis of data. It do...
  • SQL Server 2008’s Database Engine
    on Jan 13, 2011 in SQL Server 2008 Database Engine
    The Database Engine is the primary component of SQL Server 2008. It is the Online Transaction Processing (OLTP) engine for SQL Server, and has been improved and enhanced tremendously in this version. The Database Engine is a high-performance componen...
  • SQL Server 2008’s Database Engine
    on Jan 13, 2011 in SQL Server 2008 Database Engine
    The Database Engine is the primary component of SQL Server 2008. It is the Online Transaction Processing (OLTP) engine for SQL Server, and has been improved and enhanced tremendously in this version. The Database Engine is a high-performance componen...
Close