Suppose you have a huge table which has say 30-40 columns and you want to select all of them or most of them say around 30 columns. It is a tedious job to type each of the column names. Here is a quick way to get a comma separated list of all the column...

Suppose you have a huge table which has say 30-40 columns and you want to select all of them or most of them say around 30 columns. It is a tedious job to type each of the column names. Here is a quick way to get a comma separated list of all the column...

Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement [code]DROP table test1,test2,test3[/code]......

Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement [code]DROP table test1,test2,test3[/code]......

Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement [code]DROP table test1,test2,test3[/code]......

Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement [code]DROP table test1,test2,test3[/code]......

Suppose, We need to block the access to current database and for that decided to make the db offline. For this, right click db->task-> offline. But it won't work, if some connection still open. Fix: [code] ALTER DATABASE <dbname> SE...

Suppose, We need to block the access to current database and for that decided to make the db offline. For this, right click db->task-> offline. But it won't work, if some connection still open. Fix: [code] ALTER DATABASE <dbname> SE...

Suppose, We need to block the access to current database and for that decided to make the db offline. For this, right click db->task-> offline. But it won't work, if some connection still open. Fix: [code] ALTER DATABASE <dbname> SE...

Suppose, We need to block the access to current database and for that decided to make the db offline. For this, right click db->task-> offline. But it won't work, if some connection still open. Fix: [code] ALTER DATABASE <dbname> SE...