Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • What is STUFF in SQL Server

    @amanpreet.singh
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 573
    Comment on it

    STUFF():-

             STUFF is SQL SERVER function which is used to insert the string in another string. It deletes the specified number of characters from first string and insert the new string in the place of deleted string.

     

    Syntex:-

          

    STUFF ( expression , start , length , replaceWith_expression )

    Where expression can be a variable or column, start is the int values which specifies the deletion and insertion index,length is the integer which specifies the number of characters to be deleted and replaceWith_expression is the values which is to be inserted.

     

    Example:-

     

    In the above example we can see "SQL" string is replaced with "Microsoft"

    SQL Server STUFF
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: