you can used the varbinary datatype for this purpose.

select  CAST(CAST((RAND()*255) AS Int) AS VarBinary(2))

have a look on this and I think it will sortout your problem

cheers

You can select Maximum column in a select statement are 4,096

have a look on this URL

http://mssql.meetholland.com/message/119974.aspx

Hi,

In general, is there a performance difference between using table variables and using temporary tables in SQL Server 2000?

There can be a big performance difference between using table...

BOOK ONLINE

what would you like for the UNIQUE ID. Should it be a numeric in the increasing order or it would be any alpha numeric value.

I recmend just remove the COMMIT TRAN, As in the current senario there is no need for this............ even though if u have this then it should be at the...

Hi,

I think you should consider your where clause to modify. I think that it is not too good

WHERE   

rg.ReportingGroupKey =869141 and            

and ((sp.ServiceBeginDate = '10/02/2006' 

            OR ('10/02/2006' BETWEEN sp.ServiceBeginDate and sp.ServiceEndDate)) 

And

sp.LineStatusCode IN ('F','D','A','B','R','P')...

Hi,

You should identify this using the system table sysobjects. There is a field against each object with name Xtype and Type.. Which have the values 'FN' and 'TF' against the...

Hi,

You should consider you database design why you are using the one column table having the identity field.

You should make the entry into the table by Making the...

Hi,

You should consider you database design why you are using the one column table having the identity field.

You should make the entry into the table by Making the Identity...

Hi,

You can, if you think that you can drive without knowing it.

Cheers

Hi,

You can specify the column in this way but you cann't specify the Order.

There are two different way to accomodate your requirement.

One is the using dyanamic SQL which I...

hi,

you should need to to access the column having the User Id.

Forms!Form Name!Combo Box.columns(0)

Where 0 is the index of the column holding the user id. may be...

Hi,

sp_helptext , will provide the content of a stored procedure.

Cheers