Viewing 10 posts - 1 through 10 (of 10 total)
Since all datatypes are integers and one integer will take 4 bytes.
Suppose u have 10 columns in resultset then one row will take 40 bytes and by 64*1024/40 = No....
August 8, 2007 at 3:45 am
I m using this
Declare @status varchar(2),
@day varchar(3),
@Result1 Int,
@CardNmbr varchar(9)
Set @Day = convert(int,datepart(dy, getdate()))
select @CardNmbr = '200031250'
select @Result1 = ((convert(int,substring(@Cardnmbr,1,2)) + convert(int,@day)) )
select @Result1
Amit Choudhary
August 6, 2007 at 9:35 am
At mine pc it giving 238 , that is perfect according to me :
August 6, 2007 at 9:00 am
Convert XLS to CSV and use bulk insert command.
OR Use DTS in enterprise manager.
Hope this will help u.
Amit Choudhary
August 1, 2007 at 9:49 am
Hi Michael and Jeff,
I think Michael is saying right , language is not proper in article ..
According to me :
if clustered index is created on any table with Fill factor 90 and...
July 27, 2007 at 1:26 am
Thanks Sugesh For valuable help..
For Winston : The code was in VB and like 'SQLDMOScript_AppendToFile are flag of enum can be used in call script method according to ur requirement.
Accutally one...
July 13, 2007 at 5:57 am
Yes , By using "Case When else end " u can do it
for example order by case when type = 'others' then 'zzzz' else type end .
Here order by is working...
June 13, 2005 at 2:18 am
Any thing printed in back ground like the string you have printed or the record count which query processor through create problem in vba.
That is why its good practice to...
June 11, 2005 at 5:01 am
Hi Rookie,
Fantastic ! U hav made proper solution .
Thanks Again.
June 9, 2005 at 12:28 am
Hi Remy ,
Right Question , But i want any one combination . When one combination is mapped, there should not be another combination As 1 - 3, 2 - 5, 1...
June 8, 2005 at 5:49 am
Viewing 10 posts - 1 through 10 (of 10 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy