Ashish's Blog On Sql Server - All Comments

Temporary Tables and Table Variables An Overview - Ashish's Blog On Sql Server

DotNetBurner - SQL Server — Thu, 27 Aug 2009 08:00:45 GMT

DotNetBurner - burning hot .net content

Ashish Gilhotra — Mon, 10 Aug 2009 05:05:17 GMT

Thanks Mangal...

for your valuable information and true no DDL is applied on table variable and you also can't use

-insert into Tbl_Variable Exec STORE_PROCEDURE

am still searching for a proper definition for both of these which differenciate these two things..

Thanks..

Mangal — Tue, 04 Aug 2009 06:50:33 GMT

I won't be using the table variable even if number rows are even greater than 10.

Most probabably always i would like to use temp table.

some advantage

- you can create it using SELECT INTO clause.

- with table variable you can't use ALTER command, basically means you can't have more than one Index on table varible.

Ashish's Blog — Mon, 29 Jun 2009 15:30:55 GMT

Hi all me again here with a post about Encryption & Decryption in Sql Server 2005.I have received

Ashish's Blog — Mon, 29 Jun 2009 15:24:20 GMT

Hi all me again here with a post about Encryption & Decryption in Sql Server 2005.I have received

Pinal Dave — Mon, 04 May 2009 02:27:41 GMT

Ashish good work and you are working with good people (Jacob). He is great mentor as well.

Ashish Gilhotra — Sun, 03 May 2009 17:53:28 GMT

hi Sir ,,

Thanks very Much just i need your support and corporation,,,

thanks very Much,,,

Pinal Dave — Sun, 03 May 2009 17:44:18 GMT

Great Going. Keep it up!

Regards,

Pinal