Sometimes we need to know the table structure information of a database. We need to know the information like columns name, data type, length etc. There are multiple options to find the information. Some of them are

sp_columns: You can execute sp_columns and get the columns information of the table.
Example: exec sp_columns ‘Table Name’

sp_help: You can execute sp_help and get the all the necessary information of the table.
Example: exec sp_help ‘Table Name’

You can download some free ebooks from here.
http://www.microsoftvirtualacademy.com/ebooks

NAnt is a free .NET build tool, but it is enough handy to accomplish our intricate job once we able to put it in place. The configuration options are enormous and I am sure you will get a way of your new job accomplished. This is because we have been doing a lot of manual work every time while we deploy this particular project, but finally we have come accross a solution of a large build management work. This is implemented for one of our projects as well.

In many of our projects, we embed YouTube videos as part of the site content. By default, when a YouTube video finishes playing, it shows a bunch of related videos, which unfortunately can be VERY unrelated.

To avoid showing any related videos, please include "rel=0" parameter with the YouTube URL in the embed code. Or, just unchecked the option when you get the embed code from YouTube.

This is something we should always do to save ourselves and our clients from potential embarrassing situations.

You think you don't write good emails? This blog might help you :) | Tips to write effective emails | Tips to write effective emails | These are some tips to write more effective emails. Hope these will help you. a. ALWAYS REPLY TO THE EMAIL THAT WAS SENT TO YOU. Do not leave any email untreated. If the email said “thank you”, ...

Project Communication & Coordination Scopes for a QA in a Project :) | Project Communication & Coordination Scopes for a QA in a Project | Project Communication & Coordination Scopes for a QA in a Project | As said a few times in my last post, project communication and coordination could be one fine way to turn yourself into a very dependable QA from just a software tester for your project. If you are...

Drush like command line tool for wordpress. | Command line interface for WordPress | WP-CLI | Command line interface for WordPress | WP-CLI | WP-CLI is a set of command-line tools for managing WordPress installations. You can update plugins, set up multisite installs and much more, without using a web browser.

Subscribe to Front page feed