Withdata software has announced mssqltodb2 1.3, a data conversion tool that convert SQL Server data to DB2 database. Version 1.3 add “Task Schedule”, add support to DB2 XML type field, improve importing performance, and fix “division by zero” bug in importing ... Read more
Tag Archives: Sql Server
Withdata Software Released DB2ToMsSql Version 1.3
Withdata software has announced db2tomssql 1.3, a data conversion tool that convert DB2 data to SQL Server database. Version 1.3 add “Task Schedule”, add support to DB2 XML type field, improve importing performance, and fix “division by zero” bug in importing ... Read more
Withdata Software Released MsSqlToAccess Version 2.2
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
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
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