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
Tag Archives: Sql Server
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
Create Excel report from SQL Server database
Want to create Excel report from SQL Server database? Using DBToFile, a native GUI tool, you can generate excel report from SQL Server easily and fast, no need to program, no need learn VBA, just a few mouse clicks! Support Windows, Linux, macOS Here you can download and install ... Read more
Edit Sql Server VARBINARY data
SqlLobEditor is a database tool that can edit SQL Server VARBINARY data directly. Use SqlLobEditor, you can edit SQL Server VARBINARY data visually. And you can save Sql Server VARBINARY data to file and load file data to Sql Server BINARY field. Easy to use Support editing Sql Server binary, ... Read more
Edit Sql Server TEXT, NTEXT data
SqlLobEditor is a database tool that can edit SQL Server TEXT, NTEXT data directly. Use SqlLobEditor, you can edit SQL Server TEXT, NTEXT visually. And you can save TEXT, NTEXT data to file and edit also. Easy to use Edit TEXT, NTEXT data directly. Edit multiple formats TEXT, NTEXT data(text, ... 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
Edit Sql Server IMAGE data
SqlLobEditor is a database tool that can edit SQL Server IMAGE data directly. Use SqlLobEditor, you can edit SQL Server IMAGE visually. And you can save IMAGE data to file and edit also. Easy to use Edit IMAGE data directly. Edit multiple formats IMAGE data(text, RTF, image, hex, html, ... Read more
Edit Sql Server BLOB data
SqlLobEditor is a database tool that can edit SQL Server VARBINARY data directly. Use SqlLobEditor, you can edit SQL Server VARBINARY data visually. And you can save Sql Server VARBINARY data to file and load file data to Sql Server BINARY field. Easy to use Support editing Sql Server binary, ... Read more