Keith Henry


Technical Article

Get contents of a directory/share to a table

Following on from todays QOD (on xp_cmdshell permissions) I thought this might be useful.Takes a directory or UNC path and returns the contents as a table.  eg:exec sp_getdir '\\mypc\c$'returns:datestring timestring directory   filesize    nameoffile---------- ---------- ----------- ----------- ----------------------18/07/2003 10:45      1           NULL        Documents and Settings18/07/2003 11:02    […]

You rated this post out of 5. Change rating

2003-09-04

251 reads

Technical Article

Convert float to duration-time string

This UDF is using in reporting where lots of durations are calculated, stored and then summed up and averaged for reports.  By storing the durations as floats (which are similar to the fixed point numbers datetimes are stored as) math functions are simpler.The problem is that float-times are not human readable, and cast(@floatime as datetime) […]

You rated this post out of 5. Change rating

2003-09-03

991 reads

Technical Article

Execute large sql (>8000 chars)

With a dynamic sql script under 4000 chars use sp_executesql With under 8000 chars write it to a variable.For anything longer you can use this script.  Use UpdateText and WriteText to write your dynamic sql to a text/ntext field in a table somewhere and then pass its location to this script.

You rated this post out of 5. Change rating

2003-09-01

589 reads

Technical Article

Prioritised list to table

I wrote this to allow me to send a priority list of int ids.This takes a "," seperated list of integers and puts them into a table, along with an [insorder] field that allows you to sort them.eg 2,6,3,1,7 becomesints insorder ---- --------1    72    13    56    37    9Depending on what […]

You rated this post out of 5. Change rating

2003-09-01

76 reads

Blogs

Creating a GitHub Actions Self-Hosted Runner

By

I had to demo the Flyway Autopilot system recently and created a GitHub Actions...

Migrating from Azure PG Single Server to Flex with Azure VM and pg_dump/restore

By

This is more complicated than using the Azure Migration method, but because it’s maxed...

PowerShell (and T-SQL) and Elastic Jobs

By

I’ve covered how to create Elastic Jobs in the portal (this one is important...

Read the latest Blogs

Forums

SSMA for Oracle get error for assembly 'Oracle.ManagedDataAccess'

By Xiaogang Zheng

Hi, I am using the SSMA for Oracle v10.0. I have installed the SSMA...

Avoiding duplicates stop and restart an ssis package that is using batch inserts

By Neo

Hi, I an using VS 2022 to build a package that selects and then...

Contracting DBA - Permissions for initial analysis

By StephenSQL

Accidental DBA here.  After looking at all the work that needs to be done,...

Visit the forum

Question of the Day

AG Rules for Databases

Which of these is not a requirement for a database to be added to an Availability Group (AG)?

See possible answers