SQLTeam.com | Weblogs | Forums

Export some tables to separate file according to pattern

tsql
sql2008r2

#1

Hi everybody,

I need to archive some table to file and deleting after.
But I don't know SQL crud or transacSQL.
Is there anyone of you that have a little bloc of code to do this according to with the following pattern ?

ClientsWLogs_YYYYMM Like clientsWLogs_201201 à ClientsWLogs_201501
AboWeLogs_YYYYMM
CoLogs_YYYYMM
MsgLogs_YYYYMM

Thank you for your help

Orwell