Withdata Software

Tag: Sql Server

  • Batch import data from Excel files to SQL Server without programming

    Want to batch import data from files to SQL Server ? Using XlsToSql, you can batch import data from Excel files to SQL Server easily and fast, no need to program, just a few mouse clicks! Here you can download and install XlsToSql. Batch import data from Excel files to SQL Server Click “Wizard –…

  • Schedule and automate SQL Server exporting to files task

    Want to schedule and automate SQL Server exporting to files task? Using SqlToTxt, you can scheduled exporting SQL Server data to files task easily, just a few mouse clicks! Here you can download and install SqlToTxt. Schedule and automate SQL Server exporting to files task 1. Select and run a task from follow list: Export…

  • 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 = i.object_id and co.column_id = ic.column_id where ic.is_included_column = 0 and s.name=’my_schema_name’ and o.name=’my_table_name’ See…

  • 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 primary key of a table from SQLite How to get primary key of a table from MySQL How to…

  • Export data from SQL Server query to SQL file

    Want to export data from SQL Server query to SQL file? Using SqlToTxt, you can export data from SQL Server query to Sql file easily and fast, just a few mouse clicks! Here you can download and install SqlToTxt. Export data from SQL Server query to Sql file Click “Export From Query” at task dialog.…

  • Batch export data from SQL Server tables to HTML files

    Want to batch export data from SQL Server tables to HTML files? Using SqlToTxt, you can batch export data from SQL Server tables to Html files easily and fast, just a few mouse clicks! Here you can download and install SqlToTxt. Batch export data from SQL Server tables to Html files Click “Export All Tables”…

  • Batch export data from SQL Server tables to JSON files

    Want to batch export data from SQL Server tables to JSON files? Using SqlToTxt, you can batch export data from SQL Server tables to Json files easily and fast, just a few mouse clicks! Here you can download and install SqlToTxt. Batch export data from SQL Server tables to Json files Click “Export All Tables”…

  • Batch export data from SQL Server tables to XML files

    Want to batch export data from SQL Server tables to XML files? Using SqlToTxt, you can batch export data from SQL Server tables to Xml files easily and fast, just a few mouse clicks! Here you can download and install SqlToTxt. Batch export data from SQL Server tables to Xml files Click “Export All Tables”…

  • Batch export data from SQL Server tables to TSV files

    Want to batch export data from SQL Server tables to TSV files? Using SqlToTxt, you can batch export data from SQL Server tables to Tsv files easily and fast, just a few mouse clicks! Here you can download and install SqlToTxt. Batch export data from SQL Server tables to Tsv files Click “Export All Tables”…

  • Export data from SQL Server query to HTML file

    Want to export data from SQL Server query to HTML file? Using SqlToTxt, you can export data from SQL Server query to Html file easily and fast, just a few mouse clicks! Here you can download and install SqlToTxt. Export data from SQL Server query to Html file Click “Export From Query” at task dialog.…