Difference between Stuff and Partial update clause write

SQLServerCentral is supported by Red Gate Software Ltd.

Home Tags Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Michael Coles » Difference between Stuff and Partial update...

Difference between Stuff and Partial update clause write

Rate Topic

Display Mode

Topic Options

Author

Message

ezhil-649633

Posted Thursday, July 30, 2009 11:29 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, February 13, 2010 2:23 AM
Points: 129, Visits: 236

Hi,
Can any body tell me the main difference between the partial update clause WRITE and the STUFF() function.

Thanks
Ezhil

Post #762901

Jeff Moden

Posted Friday, July 31, 2009 8:08 PM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:56 PM
Points: 20,164, Visits: 13,699

Yes... one works on the TEXT datatype and the other doesn't. Please refer to Books Online for details.... Books Online comes free with SQL Server.

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #763486

« Prev Topic | Next Topic »

Permissions