|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here! |
|
#1
|
||||
|
||||
|
Deleting files from sql query
I am writing a trigger for a table to check for duplicate entries. The table contains several columns including a filepath to an image stored somewhere on the server. In order to save on filespace, since the images can be upwards of 500 megs, the client has decided they only want to store the most recent version of the image. Any ideas on how I can delete the old images from within sql server?
|
|
#2
|
|||
|
|||
|
try with xp_cmdshell ..it's calling a Command prompt for you
|
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Deleting files from sql query |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|