After installing bellow procedure you will be able to easly attach workbook and read data from it.This example shows how to attach excel file (c:\temp\orders.xls) and display data from named range (Table1):Exec mysp_AttachWorkbook 'c:\temp\orders.xls', 'MyOrders'Select * from MyOrders...Table1
2002-05-25
2,221 reads
This procedure will return useful columns information for VB developers. It shows column name, data type, size, vbtype, checktable (refferenced table) and flags: NoNull, IsIdentity, IsPK.Calling sample: mysp_columns 'customers'
2002-04-19
673 reads
By Steve Jones
A customer recently was concerned about the time to run SQL Compare for a...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Arun Sirpal
On the theme of failover groups let’s do a quick recap on my environment....
Comments posted to this topic are about the item Tracking, Privacy, and Lots of...
Hi Team, We have primary DC which is having 3 nodes cluster and implemented...
Can we configure active passive clustering on sql server 2014 without any licence?
Ask SSC