Withdata software has announced mssqltoaccess 2.2, a data conversion tool that export ms SQL Server data to access. MsSqlToAccess 2.2 add “Task Schedule”, improve importing performance, and fix “division by zero” bug in importing process. MsSqlToAccess, Better tool for ... Read more
Tag Archives: Sql Server
Withdata Software Released AccessToMsSql Version 2.2
Withdata software has announced accesstomssql 2.2, a data conversion tool that import Access data to ms SQL server. AccessToMsSql 2.2 add “Task Schedule”, improve importing performance, and fix “division by zero” bug in importing process. AccessToMsSql, Better way to ... Read more
How to View PDF stored in SQL Server image field or varbinary(MAX) field
Some time you need view pdf stored in SQL Server image field or varbinary(max) field, how to do it? I suggest you try SqlLobEditor, you can download it form here: http://www.withdata.com/down/SqlLobEditor.exe . Run SqlLobEditor, execute query, and click the “BLOB” grid that contains ... Read more
Withdata Software Released Withdata MsSqlToExcel 1.9
Withdata software has announced withdata mssqltoexcel 1.9, a data conversion tool that export ms SQL Server data to excel. Withdata MsSqlToExcel 1.9 add “Task Schedule”, improve export performance, and fix “division by zero” bug in importing process. Withdata MsSqlToExcel ... Read more
Withdata Software Released SqlToTxt Version 2.5
Withdata software has announced sqltotxt 2.5, a data conversion tool that export SQL Server data to flat file (csv, xml, html, sql) and excel. SqlToTxt 2.5 add “Task Schedule”, improve export performance, and fix “division by zero” bug in importing process. SqlToTxt ... Read more
Withdata Software Released XlsToSql Version 2.4
Withdata software has announced xlstosql 2.4, a data conversion tool that import Excel data to ms SQL Server database. XlsToSql 2.4 add “Task Schedule”, improve import performance, and fix “division by zero” bug in importing process. XlsToSql – A Better way to import ... Read more
Withdata Software Released TxtToSql Version 2.5
Withdata software has announced txttosql 2.5, a data conversion tool that import csv(txt) data to SQL Server database. TxtToSql 2.5 add “Task Schedule”, improve import performance, and fix “division by zero” bug in importing process. TxtToSql – A better way to import ... Read more
How to create a user in SQL Server Express database
Create a SQL Authenticated login first with CREATE LOGIN, then add a user associated with that login to your database by using CREATE USER. USE [master] GO CREATE LOGIN [YourUsername] WITH PASSWORD=N'YourPassword', DEFAULT_DATABASE=[YourDB], CHECK_EXPIRATION=OFF, ... Read more
The SQL Server equivalent for the MySQL Limit
In MySQL, you can use “Limit n,m”, like this: select * from sometable order by name limit 20,10 And in SQL Server, use this query: SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (ORDER BY name) as rowNum FROM sometable ) sub WHERE rowNum > 20 AND ... Read more
Withdata Software Released SqlLobEditor 2.1
Withdata software has announced sqllobeditor 2.1, a tool that helps you edit SQL Server lob(text,ntext,image) data directly. SqlLobEditor 2.1 add PDF View, add “Execute Sql from Command line”, improve logon form, improve “Check update”, and fix bug on “Execute from ... Read more