MD5 in SQL

Is there any MD5() type of function SQL Server to encrypt
a string?
Thanks,
LixinNothing built in. Take a look at wiHash and wiCrypt from www.whamware.com.
Tom
"Lixin Fan" wrote:
> Is there any MD5() type of function SQL Server to encrypt
> a string?
> Thanks,
> Lixin|||Tom,
Thanks a lot.
Lixin
>--Original Message--
>Nothing built in. Take a look at wiHash and wiCrypt from
www.whamware.com.
>Tom
>"Lixin Fan" wrote:
>> Is there any MD5() type of function SQL Server to
encrypt
>> a string?
>> Thanks,
>> Lixin
>
>.
>

Maybe I'm asking for too much.

I’m using oracle but I’m sure this problem will have similar solution to SQL. I have a list of string in a table (aa, bb, cc, dd). I also have a list of numbers that are not in the database. What I’m looking for is an output like this.

Aa, 11

Aa, 22

Bb, 11

Bb, 22

Cc, 11

Cc, 22

Dd, 11

Dd, 22

Is this possible, without having to insert the numbers in a database table and with a simple query? (this could be done with temporary table)

? Sure... SELECT YourTable.YourStringColumn, N.Number FROM YourTable CROSS JOIN ( SELECT 11 UNION ALL SELECT 22 ) N (Number) -- Adam MachanicPro SQL Server 2005, available nowhttp://www..apress.com/book/bookDisplay.html?bID=457-- <ThE_lOtUs@.discussions..microsoft.com> wrote in message news:484c9f08-620e-46e9-bc35-83620c31d17d@.discussions.microsoft.com... I’m using oracle but I’m sure this problem will have similar solution to SQL. I have a list of string in a table (aa, bb, cc, dd). I also have a list of numbers that are not in the database. What I’m looking for is an output like this. Aa, 11 Aa, 22 Bb, 11 Bb, 22 Cc, 11 Cc, 22 Dd, 11 Dd, 22 Is this possible, without having to insert the numbers in a database table and with a simple query? (this could be done with temporary table)

Maximum size of the SSIS String Variable?

In SSIS, what is the maximum size of the String variable (one that you would define in the Variables dialog box)?

I think its 4000 but I could be mistaken.

|||

4000 is the limit on expressions. I'm not sure what the limit is on strings.

|||

jwelch wrote:

4000 is the limit on expressions. I'm not sure what the limit is on strings.

This is all true. Technically, I'm not sure there's a limit on the string variables. Though you can't really use that variable anywhere without the 4000 character expression limit applying. (Most of the time the variable is used in an expression SOMEWHERE...)

|||

I don't believe there is a limit on the string variable size. As mentioned, there is a 4000 character limit in the expression editor, and I believe the limit for NVARCHAR fields for the SQL Native Client provider is also 4000 (above that it has to be NTEXT).

|||

I'm using the String variable to store the text of an XML File that I then reference in the XML Source component, so the 4000 character limit isn't a concern for me.

I'm wondering, though, when the size of the String variable becomes a problem -- will it handle the text 100K file? I suppose I should just do a quick test and see what happens.

|||

Post back and let us know.

|||

I just loaded a 600,000+ character file into an SSIS String variable without any problems, so I'm assuming that there isn't a built-in maximum size -- although, as the other posters mentioned, there are limitations on size of a String variable you can use in expressions, etc.

This should be very useful for my purposes -- now I'm able able to store my medium-sized XML files as SSIS Strings (for use in the XML Source component) without much worry.

|||

Can you let us know how you loaded this many characters into the SSIS string variable?

Maximum size of the SSIS String Variable?

In SSIS, what is the maximum size of the String variable (one that you would define in the Variables dialog box)?

I think its 4000 but I could be mistaken.

|||

4000 is the limit on expressions. I'm not sure what the limit is on strings.

|||

jwelch wrote:

4000 is the limit on expressions. I'm not sure what the limit is on strings.

This is all true. Technically, I'm not sure there's a limit on the string variables. Though you can't really use that variable anywhere without the 4000 character expression limit applying. (Most of the time the variable is used in an expression SOMEWHERE...)

|||

I don't believe there is a limit on the string variable size. As mentioned, there is a 4000 character limit in the expression editor, and I believe the limit for NVARCHAR fields for the SQL Native Client provider is also 4000 (above that it has to be NTEXT).

|||

I'm using the String variable to store the text of an XML File that I then reference in the XML Source component, so the 4000 character limit isn't a concern for me.

I'm wondering, though, when the size of the String variable becomes a problem -- will it handle the text 100K file? I suppose I should just do a quick test and see what happens.

|||

Post back and let us know.

|||

I just loaded a 600,000+ character file into an SSIS String variable without any problems, so I'm assuming that there isn't a built-in maximum size -- although, as the other posters mentioned, there are limitations on size of a String variable you can use in expressions, etc.

This should be very useful for my purposes -- now I'm able able to store my medium-sized XML files as SSIS Strings (for use in the XML Source component) without much worry.

|||

Can you let us know how you loaded this many characters into the SSIS string variable?

Maximum size of the SSIS String Variable?

In SSIS, what is the maximum size of the String variable (one that you would define in the Variables dialog box)?

I think its 4000 but I could be mistaken.

|||

4000 is the limit on expressions. I'm not sure what the limit is on strings.

|||

jwelch wrote:

4000 is the limit on expressions. I'm not sure what the limit is on strings.

This is all true. Technically, I'm not sure there's a limit on the string variables. Though you can't really use that variable anywhere without the 4000 character expression limit applying. (Most of the time the variable is used in an expression SOMEWHERE...)

|||

I don't believe there is a limit on the string variable size. As mentioned, there is a 4000 character limit in the expression editor, and I believe the limit for NVARCHAR fields for the SQL Native Client provider is also 4000 (above that it has to be NTEXT).

|||

I'm using the String variable to store the text of an XML File that I then reference in the XML Source component, so the 4000 character limit isn't a concern for me.

I'm wondering, though, when the size of the String variable becomes a problem -- will it handle the text 100K file? I suppose I should just do a quick test and see what happens.

|||

Post back and let us know.

|||

I just loaded a 600,000+ character file into an SSIS String variable without any problems, so I'm assuming that there isn't a built-in maximum size -- although, as the other posters mentioned, there are limitations on size of a String variable you can use in expressions, etc.

This should be very useful for my purposes -- now I'm able able to store my medium-sized XML files as SSIS Strings (for use in the XML Source component) without much worry.

|||

Can you let us know how you loaded this many characters into the SSIS string variable?