Sql Server & SSRS Tips

GO /****** Object:  StoredProcedure [dbo].[sp_generate_inserts]    Script Date: 12/13/2011 17:22:07 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO --sp_generate_inserts @table_name='address_type',@WhereClause = 'where cityid = 6' ALTER PROCEDURE [dbo].[sp_generate_inserts] ( @table_name varchar(776),   -- The table/view for which the INSERT statements will be generated using the existing data @target_table varchar(776) = NULL, -- Use this parameter to specify a different table name into which the data will be inserted @include_column_list bit = 1, -- Use this parameter to include/ommit column list in the generated INSERT statement @from varchar(800) = NULL, -- Use this parameter to filter the rows based on a filter condition (using WHERE) @include_timestamp bit = 0, -- Specify 1 for this parameter, if you want to include the TIMESTAMP/ROWVERSION column's data in the INSERT statement @debug_mode bit = 0, -- If @debug_mod...

SQL Server 2008 R2 version information The following table lists the major releases of SQL Server 2008 R2. Release Product version SQL Server 2008 R2 Service Pack 1 10.50.2500.0 SQL Server 2008 R2 RTM 10.50.1600.1 SQL Server 2008 version information The following table lists the major releases of SQL Server 2008. Release Product version SQL Server 2008 Service Pack 3 10.00.5500.00 SQL Server 2008 Service Pack 2 10.00.4000.00 SQL Server 2008 Service Pack 1 10.00.2531.00 SQL Server 2008 RTM 10.00.1600.22 SQL Server 2005 version information The following table lists the major releases of SQL Server 2005. Release Product version SQL Server 2005 Service Pack 4 9.00.5000.00 SQL Server 2005 Service Pack 3 9.00.4035 SQL Server 2005 Service Pack 2 9.00.3042 SQL Server 2005 Service Pack 1 9.00.2047 SQL Server 2005 RTM 9.00.1399 SQL Server 2000 version information The following table lists version number of the Sqlservr.exe file.  Release Product version SQL ...