Archive for the ‘Tips and Tricks’ Category

Convert .MOD file to .MPG

This item was filled under [ Tips and Tricks ]

 
Today i came across a typical problem of converting .MOD file to .MPG file.
and my friend gave a very good suggestion…
Convert .MOD file to .MPG is very simple…
Change Extension/Rename the file  and you are done …
e.g. video1.mod rename to video.mpg and it will work…
ProCoder will import .MOD file after that.
Premier will also accept .MOD file [...]

Continue reading...

Fetch SP Data From SQL Server to Excel in Excel

This item was filled under [ SQL Server, Tips and Tricks ]

If you are planning to get data from SQL Server to excel by using Excel External Data feature. Please follow the follwing steps :
1.  Set all steps by choosing any table.
2. Go To Refresh button > Connection Properties > Definition Tab
3.  Change the Command Type to SQL  and put the command “EXEC databasename.ownername.StoredProcedurename”
You are done.
Also [...]

Continue reading...