In Sql Server Management Studio, I usually access my sql query files that I save -- using the File -- Recent Files option. The default setting of the number of recent files to be displayed in SSMS. Today I wanted to access a file that I had used last week and I could not find that file in the recent list. So I thought of displaying more than the normal 4 files that are displayed in the Recent Files option. So I set out to find where the settings are (as in the microsoft office programs) -- I cli...
Read More
Yesterday I wanted to export the contents of a folder into excel to provide it to the users for input. Here are the steps I followed. Go to Start -- Run -- CMD Change to the drive letter of the drive in which the folder you want the contents listed is if you are not already there by typing the drive letter followed by a colon. Eg: d: for going to the d drive. Change to the folder of which you want the contents to be exported by using the chane directory command cd. Eg: cd shared/test for changin...