Want to schedule and automate SQL Server copy data task? Using DBCopier, a native GUI tool, you can scheduled SQL Server copy data task easily, just a few mouse clicks! Let computer automate repetitive SQL Server copy data busy work, DBCopier make our life easier! Here you can download and ... Read more
Tag Archives: Sql Server
Schedule and automate SQL Server importing XML data task
Want to schedule and automate SQL Server importing XML data task? Using FileToDB, a native GUI tool, you can scheduled importing XML data to SQL Server task easily, just a few mouse clicks! Let computer automate repetitive SQL Server importing XML data busy work, FileToDB make our life ... Read more
Schedule and automate SQL Server importing Excel data task
Want to schedule and automate SQL Server importing Excel data task? Using FileToDB, a native GUI tool, you can scheduled importing Excel data to SQL Server task easily, just a few mouse clicks! Let computer automate repetitive SQL Server importing Excel data busy work, FileToDB make our life ... Read more
Schedule and automate SQL Server importing TXT/CSV/TSV data task
Want to schedule and automate SQL Server importing TXT/CSV/TSV data task? Using FileToDB, a native GUI tool, you can scheduled importing TXT/CSV/TSV data to SQL Server task easily, just a few mouse clicks! Let computer automate repetitive SQL Server importing TXT/CSV/TSV data busy work, ... Read more
Schedule and automate SQL Server importing JSON data task
Want to schedule and automate SQL Server importing JSON data task? Using FileToDB, a native GUI tool, you can scheduled importing JSON data to SQL Server task easily, just a few mouse clicks! Let computer automate repetitive SQL Server importing JSON data busy work, FileToDB make our life ... Read more
Schedule and automate SQL Server exporting to Excel task
Want to schedule and automate SQL Server exporting to Excel task? Using DBToFile, a native GUI tool, you can scheduled exporting SQL Server data to Excel task easily, just a few mouse clicks! Let computer automate repetitive exporting SQL Server data to Excel busy work, DBToFile make our life ... Read more
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 ... 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
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 ... Read more