MSSQL Articles

  • cursor to loop through records in mssql database
    user Murugan Andezuthu Dharmaratnam | created on12 December 2023 | views644

    While working with a SQL database you want to create a cursor to loop through records in a table. Here is an example for the same. lets loop though a table named Country with columns Name and ModifiedBy, the sample code below can help you get started. … CONTINUE READING

  • mssql stored procedure create read update delete into database table
    user Murugan Andezuthu Dharmaratnam | created on11 May 2023 | views685

    sample mssql stored procedure create read update delete into database table. Stored procedures in MSSQL for CRUD operations are not just about performing basic database functions. They are about ensuring that these operations are performed in a way that is efficient, secure, and in line with the best practices of database management. As businesses continue to rely heavily on data, the importance of well-crafted stored procedures in managing this data cannot be overstated. … CONTINUE READING

  • mssql create temp table
    user Murugan Andezuthu Dharmaratnam | created on23 September 2020 | views2683

    Creating a temporary table in mssql is one of the easiest things to do. You can use the same syntax as creating a table, the only difference prepend a # to the table name … CONTINUE READING

  • mssql depth of a tree
    user Murugan Andezuthu Dharmaratnam | created on10 September 2020 | views2813

    we will write a function to find the depth of a tree. Depth of node N in the tree is the length of the path from the root of the tree to node N … CONTINUE READING