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,213 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
664 reads
How does one consistently find the correct path to the Extended Event Log file...
By Steve Jones
Years ago I was working on a demo with Microsoft and someone added me...
I find that I’m using containers more and more to get things done with...
Comments posted to this topic are about the item The Change Failure Rate
Comments posted to this topic are about the item DBA Walkthrough – Adding space...
Comments posted to this topic are about the item The Datatimeoffset Value
Ask SSC