Welcome to my blog.

Post on this blog are my experience which I like to share. This blog is completely about sharing my experience and solving others query. So my humble request would be share you queries to me, who knows... maybe I can come up with a solution...
It is good know :-)

Use my contact details below to get directly in touch with me.
Gmail: nadarmuthukumar1987@gmail.com
Yahoo: nadarmuthukumar@yahoo.co.in

Apart from above people can share their queries on programming related stuff also. As me myself a programmer ;-)

Multiple users working on the same excel sheet


  1. Go to Tools>Share Workbook>Editing tab
  2. Click Allow changes by more than one user at the same time checkbox if needed and click OK
  3. Save the workbook if prompted
  4. Use File>Save As to save the workbook to be shared to a network location to which both users have access 
Reference: Muthukumar (http://nadarmuthukumar.blogspot.in) Hope you liked this and let me know your thoughts on post through your comments :)

Get all tables name of database

SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
Or
SELECT *
FROM SYS.TABLES

Reference: Muthukumar (http://nadarmuthukumar.blogspot.in) Hope you liked this and let me know your thoughts on post through your comments :)

Twitter Delicious Facebook Digg Stumbleupon Favorites More