Advertisements

Quick tip create a file copy with a different extension

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

Get data across databases sql server

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 🙂