Want to append the data from CSV file to the existing SQL Server table via command line on MacOS? Using mssql-cmd, a Command-Line client for SQL Server, you can append CSV/TSV/TXT data into existing SQL Server table easily and fast. Support Windows, Linux, and MacOS. Download mssql-cmd MacOS ... Read more
Tag Archives: Sql Server
Append CSV data to SQL Server table via command line on Linux
Want to append the data from CSV file to the existing SQL Server table via command line on Linux (Ubuntu/RedHat/CentOS…)? Using mssql-cmd, a Command-Line client for SQL Server, you can append CSV/TSV/TXT data into existing SQL Server table easily and fast. Support Windows, Linux, and ... Read more
Append CSV data to SQL Server table via command line on Windows
Want to append the data from CSV file to the existing SQL Server table via command line on Windows? Using mssql-cmd, a Command-Line client for SQL Server, you can append CSV/TSV/TXT data into existing SQL Server table easily and fast. Support Windows, Linux, and MacOS. Download mssql-cmd ... Read more
Batch import RTF files into SQL Server [IMAGE, VARBINARY(MAX)] (BLOB) without programming
Want to batch import RTF (Rich Text Format) documents into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) or [IMAGE, VARBINARY(MAX)] (BLOB) column? Using SqlLobEditor, you can import bulk rtf files into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) or [IMAGE, ... Read more
Some ETL (Extract-Transform-Load) tools for SQL Server
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
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