Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
select * from openrowset('MSDASQL', 'DSN=Visual FoxPro Tables; SourceDB= \\MYSERVER\FOLDER\; SourceType=DBF', 'select * from dbfTable')
EXEC sp_addlinkedserver MyExcel, 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', 'c:\ee\test1_work.xls', NULL, 'Excel 5.0;' GO --Set up login mappings (just ADMIN - jet wants something). EXEC sp_addlinkedsrvlogin MyExcel, FALSE, NULL, Admin, NULL GO --List the tables in the linked server (these are the worksheet names). EXEC sp_tables_ex MyExcel GO select * from myexcel...Sheet1$ GO
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|read Json fields and insert all the content into a table by Store Procedure||4||24|
|SQL Server Express or Standard?||5||33|
|Run daily script on multiple sql servers using table with server connection strings||4||22|
|Store single record two values to ASP. NET Session using a Function running a ExecuteReader by executing a Sql Stored Procedure||2||12|