Withdata Software

Tag: Sql Server

  • Withdata Software Released MsSqlToDB2 Version 1.2

    Withdata software has announced mssqltodb2 1.2, a data conversion tool that convert SQL Server data to DB2 database. Version 1.2 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. MsSqlToDB2 – Convert SQL Server data to DB2 MsSqlToDB2 is convenient: 1. Easy visually config, just click on the mouse. 2.…

  • Withdata Software Released MsSqlToAccess Version 2.1

    Withdata software has announced mssqltoaccess 2.1, a data conversion tool that export ms SQL Server data to access. MsSqlToAccess 2.1 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. MsSqlToAccess, Better tool for export SQL Server to Access MsSqlToAccess is convenient: 1. Easy visually config, just click on the mouse.…

  • Withdata Software Released DB2ToMsSql Version 1.2

    Withdata software has announced db2tomssql 1.2, a data conversion tool that convert DB2 data to SQL Server database. Version 1.2 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. DB2ToMsSql – Convert DB2 data to SQL Server DB2ToMsSql is convenient: 1. Easy visually config, just click on the mouse. 2.…

  • Withdata Software Released AccessToMsSql Version 2.1

    Withdata software has announced accesstomssql 2.1, a data conversion tool that import Access data to ms SQL server. AccessToMsSql 2.1 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. AccessToMsSql, Better way to import Access to SQL Server AccessToMsSql is convenient: 1. Easy visually config, just click on the mouse.…

  • Replace (Update/Insert) a row into SQL Server table

    In MySQL,  we use “ON DUPLICATE KEY UPDATE” to either updates or inserts a row in a table. How to do it in SQL Server? Just like this: if not exists (select 1 from employees where employee_id = 1) insert into employees (employee_id,last_name,first_name) values ( 1,’smith’, ‘bob’ ) else update employees set last_name=’smith’ , first_name=’bob’ where…

  • Remove duplicate rows in SQL Server

    Assuming no nulls, you GROUP BY the unique columns (eg. col_1, col_2, col_3), and SELECT the MIN (or MAX) Row ID (eg. row_id) as the row to keep. Then, delete everything that didn’t have a row id: DELETE my_table FROM my_table LEFT OUTER JOIN ( SELECT MIN(row_id) as row_id, col_1, col_2, col_3 FROM my_table GROUP…

  • How to get column names from Sql Server table

    SELECT [name] AS [Column Name] FROM syscolumns WHERE id = (SELECT id FROM sysobjects WHERE type = ‘U’ AND [Name] = ‘My_Table_Name’) Type = ‘V’ for views Type = ‘U’ for tables For SQL Server 2008, we can use information_schema.columns for getting column information: SELECT * FROM information_schema.columns WHERE table_name = ‘My_Table_Name’ ORDER BY ordinal_position…

  • Edit Sql Server LOB data

    SqlLobEditor is a database tool that can edit SQL Server LOB data directly. Use SqlLobEditor, you can edit SQL Server LOB visually. And you can save LOB data to file and edit also. Easy to use Edit LOB (LOB, CLOB) data directly. Edit multiple formats LOB data(text, RTF, image, hex, html, xml…). Save LOB data…

  • Wizard For Importing CSV Data To Sql Server

    First, you need and install TxtToSql. TxtToSql is a tool to import CSV data to Sql Server database. Using TxtToSql you can import CSV data to Sql Server easily and fast.   Wizard for importing txt (csv) data to Sql Server Click “Wizard – Import From File” at task dialog. then show the wizard. 1.…

  • Sql Server Export Text File

    First, you need and install SqlToTxt. SqlToTxt is a tool to export Sql Server data to text file. Using SqlToTxt you can export Sql Server data to text file easily and fast.   Export Sql Server data to TXT – 2 steps Click “Export Table” button. then show the Export Single Table form. 1. Select…