Join Multiple OPENXML queries

If you ever wanted to run multiple openxml queries and join them give this a go:
DECLARE @idoc intDECLARE @idoc1 intDECLARE @doc varchar(1000)DECLARE @doc1 varchar(1000)SET @doc =’<ROOT><Customer CustomerID=”1″ ContactName=”Balaji Ramesh” /></ROOT>’SET @doc1 =’<ROOT><Customer CustomerID=”1″ ContactNumber=”1234567890″ /></ROOT>’–Create an internal representation of the XML document.EXEC sp_xml_preparedocument @idoc OUTPUT, @docEXEC sp_xml_preparedocument @idoc1 OUTPUT, @doc1– Execute a SELECT statement that [...]

View contents of a Stored Procedure (quickly)

I am currently working on a SQL Server 2005 database that has over 500 stored procedures on it. And finding them on the object explorer has been tedious if i just need to view its contents. So i prefer typing in ‘SP_HELPTEXT <procname>’ to view the contents of the procedure. But SQL Server management studio [...]

Bypass Compulsory Registrations

Ever wanted to read an article and was frustrated to find out that the site that hosts the article requires you to register and login to view the content? If you frequent that website then it makes sense to register. But if its just a one time sneak peek then give this a try: http://www.bugmenot.com [...]