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
Tag Archives: Sql Server
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
How to generate a CREATE TABLE statement for a given table in SQL Server
declare @table varchar(100) set @table = 'my_table' -- set table name here declare @sql table(s varchar(1000), id int identity) -- create statement insert into @sql(s) values ('create table [' + @table + '] (') -- column list insert into @sql(s) select ' ['+column_name+'] ' + ... Read more
Withdata Software Released Withdata MsSqlToExcel 1.8
Withdata software has announced withdata mssqltoexcel 1.8, a data conversion tool that export ms SQL Server data to excel. Withdata MsSqlToExcel 1.8 add “Execute Sql from Command line”, add “Check Update” to menu,and fix “Execute update sql error”. Withdata ... Read more
Withdata Software Released SqlToTxt Version 2.4
Withdata software has announced sqltotxt 2.4, a data conversion tool that export SQL Server data to flat file (csv, xml, html, sql) and excel. SqlToTxt 2.4 add “Execute Sql from Command line”, add “Check Update” to menu,and fix “Execute update sql ... Read more
Withdata Software Released OracleToMsSql Version 1.2
Withdata software has announced oracletomssql 1.2, a data conversion tool that convert Oracle data to SQL Server database. Version 1.2 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. OracleToMsSql – convert Oracle data ... Read more
Withdata Software Released MysqlToMsSql Version 1.2
Withdata software has announced mysqltomssql 1.2, a data conversion tool that convert MySQL data to SQL Server database. Version 1.2 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. MysqlToMsSql – convert Mysql data to ... Read more
Withdata Software Released MsSqlToOracle Version 1.2
Withdata software has announced mssqltooracle 1.2, a data conversion tool that convert SQL Server data to Oracle database. Version 1.2 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. MsSqlToOracle – convert SQL Server ... Read more