FilesExpand file tree

master

/

Files.cs

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

23 lines (21 loc) · 972 Bytes

master

/

Files.cs

Copy path

Top

File metadata and controls

• Code
• Blame

23 lines (21 loc) · 972 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

using Microsoft.SqlServer.Server;

using System.IO;

namespace MySQLCLRFunctions

{

public static class Files

{

// Need a way to copy off locked files into temp space so I can open them in SSMS scripts, alter them swapping out macros, and execute them.

// But if you have a file open in SSMS and it is part of a Project, it is locked for reading. Files opened outside of a solution/project don't get locked this way.

//

// This also works great for Excel old style (xls) when someone leaves it open on their desktop but you need to load something.

//

// <returns>temporary file is created within the user's temporary folder.</returns>

[SqlFunction(DataAccess = DataAccessKind.None, IsDeterministic = true, IsPrecise = true)]

public static string TempFilePath()

{

return Path.GetTempFileName();

}

// TODO: FileWatcher

// TODO: FileEventWatcher

}

}