Withdata Software provide some ETL (Extract-Transform-Load) tools for SQL Server: FileToDB Load TXT, CSV, TSV, XML, JSON, Excel, SQL, RDF, INI data to SQL Server DBToFile Export SQL Server data to TXT, CSV, TSV, XML, JSON, Excel, SQL files DBCopier Copy data between SQL Server and ... Read more
Tag Archives: Sql Server
Parse RDF file and save to SQL Server
Want to parse RDF file and save to SQL Server ? Want to schedule and automate this importing task? To import Xml format RDF file (.rdf, .owl) to SQL Server, https://www.withdata.com/blog/rdftomssql/sql-server-import-rdf.html To import RDF Turtle file (.ttl, .n3) to SQL Server, ... Read more
How to select N random records from a SQL Server table
If you want to select N random records from a SQL Server table, you need to change the clause as follows: select top N * from tableName order by newid() For example, to select 5 random customers in the customers table, you use the following query: select top 5 * from customers order by ... Read more
How to get index column names of a table from SQL Server
select i.name as IndexName, co.[name] as ColumnName from sys.indexes i join sys.objects o on i.object_id = o.object_id join sys.schemas s on s.schema_id = o.schema_id join sys.index_columns ic on ic.object_id = i.object_id and ic.index_id = i.index_id join sys.columns co on co.object_id = ... Read more
How to get primary key of a table from SQL Server
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE OBJECTPROPERTY(OBJECT_ID(CONSTRAINT_SCHEMA + '.' + CONSTRAINT_NAME), 'IsPrimaryKey') = 1 AND TABLE_NAME = 'my_table_name' AND TABLE_SCHEMA = 'my_schema_name' See also: How to get primary key of a table from PostgreSQL How to get ... Read more
Withdata Software Released SqlLobEditor Version 2.3
Withdata software has announced sqllobeditor 2.3, a tool that helps you edit SQL Server lob ([image, varbinary(max)] (blob), [text, ntext, varchar(max), nvarchar(max)] (clob)) data directly. Version 2.3 Add “Create sub folders by field name”. Add “turning off log” in ... Read more
Withdata Software Released MsSqlToExcel Version 2.1
Withdata software has announced mssqltoexcel 2.1, a data conversion tool that export SQL Server data to excel. Version 2.1 Add “turning off log” in command line. Fix bug when logon to SQL Server name with “\”. Withdata MsSqlToExcel – Tool for exporting SQL Server ... Read more
Withdata Software Released SqlToTxt Version 2.6
Withdata software has announced sqltotxt 2.6, a data conversion tool that export SQL Server data to flat file (csv, tsv, xml, html, sql) and excel. Version 2.6 Add “turning off log” in command line. Add an option for “replace CRLF with space”. Fix bug when logon to SQL ... Read more
Withdata Software Released XlsToSql Version 2.5
Withdata software has announced xlstosql 2.5, a data conversion tool that import Excel data to SQL Server database. Version 2.5 Add “turning off log” in command line. Add “Bad File” to log failed import records. Fix bug “falied load part columns data in command ... Read more
Withdata Software Released TxtToSql Version 2.6
Withdata software has announced txttosql 2.6, a data conversion tool that import txt (csv, tsv) data to SQL Server database. Version 2.6 Add “Bad File” to log failed import records. Add “Exception Report From”. Improve import performance. TxtToSql – Better tool to ... Read more