Withdata Software

Tag: 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, CHECK_POLICY=OFF GO USE [YourDB] GO CREATE USER [YourUsername] FOR LOGIN [YourUsername] WITH DEFAULT_SCHEMA=[dbo] GO from: http://stackoverflow.com/questions/3737449/how-can-i-create-a-user-in-sql-server-express-database-i-added-to-my-project Then you would need grant permissions to…

  • 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 rowNum <= 30 In Oracle: https://www.withdata.com/blog/oracle/how-to-limit-the-number-of-rows-returned-by-an-oracle-query-after-ordering.html . In…

  • 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 command line”. SqlLobEditor – Edit Sql Server LOB data directly SqlLobEditor is convenient: 1. Edit…

  • 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+’] ‘ + data_type + coalesce(‘(‘+cast(character_maximum_length as varchar)+’)’,”) + ‘ ‘ + case…

  • 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 MsSqlToExcel – Export MS SQL Server data to Excel Withdata MsSqlToExcel is convenient: 1. Easy visually…

  • 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 error”. SqlToTxt – The better tool to export SQL Server data to file SqlToTxt…

  • 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 to SQL Server OracleToMsSql is convenient: 1. Easy visually config, just click on the mouse. 2.…

  • 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 SQL Server MysqlToMsSql is convenient: 1. Easy visually config, just click on the mouse. 2.…

  • 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 data to Oracle MsSqlToOracle is convenient: 1. Easy visually config, just click on the mouse. 2.…

  • Withdata Software Released MsSqlToMysql Version 1.2

    Withdata software has announced mssqltomysql 1.2, a data conversion tool that convert SQL Server data to MySQL database. Version 1.2 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. MsSqlToMysql – Convert SQL Server data to Mysql MsSqlToMysql is convenient: 1. Easy visually config, just click on the mouse. 2.…