What is the STUFF function and how does it differ from the REPLACE function?,Java, C ,C++, ASP, ASP.net C# ,Struts ,Questions & Answer, Struts2, Ajax, Hibernate, Swing ,JSP , Servlet, J2EE ,Core Java ,Stping, VC++, HTML, DHTML, JAVASCRIPT, VB ,CSS, interview ,questions, and answers, for,experienced, and fresher
What is the STUFF function and how does it differ from the REPLACE function?

REPLACE function is bassically use for replace existing characters of all occurrences. Its mainly syntax REPLACE, It is using string_expression,search_string,replacement_string, where every incidence of search_string found in the string_expression will be replaced with replacement_string.STUFF function is bassically using for the overwrite existing characters. Its Syntax is STUFF , Its Using for string_expression, start,length, replacement_characters, string_expression is the string that will have characters substituted, start is the starting position,length is the number of characters in the string that are substituted,and replacement_characters are the new characters interjected into the string.

More interview questions and answers
What is the clustered index?
What do you mean by A non clustered index?
How to handle form in PHP?
What are the different index configurations a table can have?
What are different types of Collation Sensitivity?
What is OLTP?
What is form validation?What is Client Side and Server Side validation?
What do you mean by TRUNCATE?
What do you mean by DELETE command?
When is the use of UPDATE_STATISTICS command?
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
What are the properties of SUB-QUERY?
What is the difference between constants and variables in PHP?
What are the type of SUB-QUERy?
What is SQL Profiler?
What is Ant?
What is a build tool?
How many types of build tool you know?
What is different between Ant and Make?
What is History of Ant?
Which version of Java is required to run Ant?
What are the authentication modes in SQL Server? How can it be changed?
Why do you call it Ant?
What is SQL Server Agent?
When we used $_GET and $_POST variable?
How you can Prepare a project in ANT?
Why we use $_REQUEST variable?
From where we can download Ant latest version?
Can a stored procedure call itself or recursive stored procedure? How much level SP nesting is possible?
Why we use Date() function in PHP and How?
What is Log Shipping?
Why we used Server Side include function?
What does it mean to have QUOTED_IDENTIFIER ON? What are the implications of having it OFF?
How we use include() and require() function in PHP?
What is the mean of Local temporary table?
How to use File Handling in PHP?
What do u mean by Global temporary table?
What types of modes we use in PHP for File Handling?
How we use fopen(),fclose(),feof(),fgets() and fgetc()in PHP?
How we can set the PATH environment variable of ant?
What you know about Cookie?
What operation we can perform with Cookie?Explain it?
How we Sessions in PHP?
What is the STUFF function and how does it differ from the REPLACE function?
How we handle errors in PHP ?
How we use Simple \"die()\" statements error handling method in PHP?
What is PRIMARY KEY?
How we use Custom errors and error triggers error handling methods in PHP?
What is UNIQUE KEY constraint?
What is FOREIGN KEY?
How we use Error logging method in PHP?
What is CHECK Constraint?
What is NOT NULL Constraint?
What is a Scheduled Jobs or What is a Scheduled Tasks?
What are the advantages of using Stored Procedures?
What do you understand about Exception Handling in PHP?
What is BCP? When does it used?
How to implement one-to-one,one-to-many and many-to-many relationships while designing tables?
What is Filter?How we use them?
Can a java source file hava more than one public classes?
What is an execution plan? When would you use it? How would you view the execution plan?
What do you mean by The master database?
Define The msdb database?
What do u mean by The tempdb?
What is the mean of The model?
Define whats the mean by Resoure Database?
What is Service Broker?
What is .htaccess file and how to use them?
What is Policy Management?
What is the difference b/n \'action\' and \'target\' in form tag?
What is the substitution of submit in PHP?
What is the DDL,DCL and DML?
What is the difference b/w PHP4 and PHP5?
What is Replication and Database Mirroring?
What are Sparse Columns?
What is the difference between $i and $$i?
What does TOP Operator Do?
Write some array sort functions available in php ?
What is CTE?
How to encrypt the password in PHP?
Which pre-defined classes in php?
What is the difference between unlink and unset ?
What is MERGE Statement?
What do you understand about PHP accelerator ?
What is Filtered Index?
How to get path of php.ini with a PHP script?
Output of the code? $objM = new M(); // Where, M is a class $objN = $objM;
What are the Advantages of using CTE?
How to distinguish between PHP and HTML?
What is CLR?
How we use ceil() and floor() function in PHP?
What are synonyms?
What is the significance of destructor in PHP?
What is LINQ?
What is the different b/w session and cookies in php?
What is the answer of following code echo 1< 2 and echo 1 >2 ?
What is Isolation Levels?
What is the difference b/w isset and empty?
What is the EXCEPT clause?
Can i convert PHP code into JAVA code?if yes,how?