SQLServer Tip's - Procedure, rename table, xml, dynamic SQL

1. Introduction

I'm just gathering references to well done post and documentation about SQLServer.

2. References

2.1. Stored Procedure - with parameters

IF EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND name = 'sp_edi_transf_dummy')

DROP PROCEDURE sp_edi_transf_dummy 

GO

CREATE PROCEDURE sp_edi_transf_dummy

  @pIdLoteEdi int 

AS 

    SET NOCOUNT ON;

    INSERT INTO coc_param_proc_lote_edi ( id_lote_edi, param, id )

    VALUES (@pIdLoteEdi, 'proc_transf_dummy', @pIdLoteEdi);

GO

2.2. Rename Table Column

sp_RENAME 'my_table_name.old_column_name', 'new_column_name' , 'COLUMN'

2.3. Oracle equivalents in SQLServer

• http://jopinblog.wordpress.com/2007/04/24/oracle-plsql-equivalents-for-ms-sql-server-t-sql-constructs/

2.4. String, Date and Time conversion in SQLServer

• http://sqlusa.com/bestpractices2005/sqlserverstringtodate/
• http://www.sqlusa.com/bestpractices/datetimeconversion/
• http://www.karaszi.com/sqlserver/info_datetime.asp

2.5. String and Int conversion in SQLServer

• http://blog.sqlauthority.com/2007/07/07/sql-server-convert-text-to-numbers-integer-cast-and-convert/

2.6. Dynamic SQL

• http://www.mssqltips.com/sqlservertip/1160/execute-dynamic-sql-commands-in-sql-server/
• http://www.codeproject.com/Articles/20815/Building-Dynamic-SQL-In-a-Stored-Procedure
• http://stackoverflow.com/questions/3840730/getting-result-of-dynamic-sql-into-a-variable
• http://www.sqlservercentral.com/Forums/Topic817615-8-1.aspx

2.7. XML

• http://social.msdn.microsoft.com/Forums/sqlserver/en-US/688d3044-2072-4912-b5ba-907c2660ba16/exporting-a-table-to-an-xml-file-and-getting-the-xml-schema-for-the-table
• http://stackoverflow.com/questions/11699914/concatenate-xml-without-type-casting-to-string