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 ... Read more
Tag Archives: Sql Server
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 ... Read more
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', ... Read more
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, ... Read more
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 ... Read more
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, ... Read more