in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » script (RSS)

Browse by Tags

  • How to Generate Script along with Data?

    One of the new features available in SQL Server 2008 is scripting the tables along with data (in the form of INSERT statements). Here are the useful links that can help you generating script with data SQL Server 2008 http://www.kodyaz.com/articles/sql-server-script-data-with-generate-script-wizard.aspx...
    Posted to Madhivanan (Weblog) by Madhivanan on Fri, Aug 21 2009

  • Sql release builder

    For a number of weeks, we have been regularly releasing code to our UAT database. The release process of database code differs slightly from releasing binary code because the release has to take into account existing data and schema in the database. With binary code (as in C# application) usually old...
    Posted to Piotr Rodak (Weblog) by Piotr Rodak on Mon, Jul 20 2009

  • Script out Procedures and Functions - Part 2

    Part 1 uses information_Schema.routines view and this is based on sp_helptext declare @sps table ( texts varchar ( 8000 )) insert into @sps select 'sp_helptext ''' + name + '''' from sysobjects where xtype in ( 'p' , 'fn' ) order by xtype , name create table scripts ( sps varchar ( 8000 )) declare @texts...
    Posted to Madhivanan (Weblog) by Madhivanan on Thu, Dec 13 2007

  • HTTP Authenticatoin Download of File in SSIS to XML file

    Recently I posted a script that allows you to download a CSV file to SSIS through HTTP Authentication, today, I'm posting a slightly different script that uses some XML references in order to download an XML file. You can probably use the other way that I wrote for the CSV file, but since I had both...
    Posted to greenmtnsun (Weblog) by greenmtnsun on Fri, Sep 7 2007

  • HTTP Authenticatoin Download of File in SSIS to CSV file

    I recently needed to perform a download of a CSV file with HTTP Authentication in SSIS to a CSV file. Its possible, but I needed a script to do it. I couldn't use an HTTP connection because nothing in SSIS would consume it. Nothing, including the File System, WMI and execute process tasks would work...
    Posted to greenmtnsun (Weblog) by greenmtnsun on Thu, Sep 6 2007

  • Generate SQL Script

    --This procedure will generate the structure of the table Create Procedure GenerateScript ( @tableName varchar(100)) as If exists (Select * from Information_Schema.COLUMNS where Table_Name= @tableName) Begin declare @sql varchar(8000) declare @table varchar(100) declare @cols table (datatype varchar...
    Posted to Madhivanan (Weblog) by Madhivanan on Mon, Aug 27 2007

  • Scripts Stored Procedures and Functions through query

    This query will script the Procedures and Functions All you have to do is replace DBname by the actual Database Name exec master..xp_cmdshell 'bcp "Select routine_definition from DBname.information_Schema.routines order by routine_name" queryout "C:\scripts.sql" -c' After it runs successfully, the file...
    Posted to Madhivanan (Weblog) by Madhivanan on Mon, Aug 27 2007

  • VSTA SSIS c# Script

    Posted to Blog Images (Gallery) by simonsabin on Mon, Jun 4 2007
Page 2 of 2 (18 items) < Previous 1 2
Powered by Community Server (Commercial Edition), by Telligent Systems