Advertisements

Quick tip create a file copy with a different extension

Posted on February 5, 2010 by mellerbeck

i.e. if you have a bunch of .txt files and you wanted to keep them but also have a copy with .xml

go to dos promp

go to that folder of files

copy *.txt *.xml

There you go

Advertisements

Filed under: Applied IT | Leave a comment »

Get data across databases sql server

Posted on February 5, 2010 by mellerbeck

select a.col1, b.col2
from db1.dbo.tab1 a, db2.dbo.tab2 b
where a.col1 = b.col2

All you sql wizards prob know this alread 🙂

Filed under: Applied IT | Leave a comment »