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 ... Read more
Tag Archives: Sql Server
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 ... Read more
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
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 ... Read more
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 ... Read more
Sql Server Export to Sql File
First, you need and install SqlToTxt. SqlToTxt is a tool to export Sql Server data to sql file. Using SqlToTxt you can export Sql Server data to sql file easily and fast. Export Sql Server data to sql – 2 steps Click “Export Table” button. then show the Export Single ... Read more