I used to do same in SQL server itself

Can you please share that modified code or share what you have changed!!!!!!!!!

Thanks

Sorry! I am not able to open the given link.

not able to open link

I hope this link will help you..

http://sqlscripthub.blogspot.in/2012/11/sqlworld.html

Thanks for reply.

I know this its taking size 1 default.. But my doubt is .. I assign the values to that variable so it contains memory as per values. I...

In this senario we can create multiple indexes . Creating multiple index with diffrent combination of columns is nothing but providing more option to the optimizer to plan better and...

Following example will give idea that default size of the varchar and char in convert/cast has 30

DECLARE @myVariable AS varchar(40);

SET @myVariable = 'This string is longer than thirty characters';

SELECT CAST(@myVariable...

Here we can see the default size is 30 for the varchar and the char datatype.

DECLARE @myVariable AS varchar(40);

SET @myVariable = 'This string is longer than thirty characters';

SELECT CAST(@myVariable AS...