Geeks With Blogs
Gaurav Taneja Great dreams... never even get out of the box. It takes an uncommon amount of guts to put your dreams on the line, to hold them up and say, "How good or how bad am I?" That's where courage comes in. October 2008 Entries
sp_xml_preparedocument
Example displaying when data is sent in form of xml document CREATE PROCEDURE XMLINSERT @intShowVersion INT =0, @strClassName varchar(250), @strLang varchar(10), @strXml text='', @intError int output AS SET NOCOUNT ON /* @intShowVersion INTEGER =0, @strCreatedBy VARCHAR(20) = '' , @intTemplateID INTEGER = 0, @dtClientCreatedOn DATETIME = '' , @strUpdatedBy VARCHAR(20) = '' , @dtClientUpdatedOn DATETIME = '' , @strXml text='', SET DATEFORMAT dmy IF (@intShowVersion = 1 ) BEGIN SELECT VERSION='$Revision: ......

Posted On Tuesday, October 14, 2008 12:17 AM

Copyright © Gaurav Taneja | Powered by: GeeksWithBlogs.net