Long text in "Default value or Binding"

Hey guys, how can I use a long text as default value in my database (column properties)?
I tried to paste my 10 row text into the field but it will only paste the first row as default value.

any ideas??What's the data type and data length of the column to which you paste text? And where did you paste your 10 row text into database?|||data type: text

It's obviosuly working fine if I create an update command updating the database with the same text. All I want is to have this text as default value for the column. But only the first row will be pasted...

SQL Server Mgmt-studio - Column Properties - default value or binding. Just a lil frustrating :)|||

OK now I understand you Unfortunately this seems to be a flaw of Management Studio GUI, while you can add multiple lines as default in Enterprise Manager in SQL2000 However we can define multiple-line default value by using T-SQL. New a query and use such statement:

ALTER TABLE dbo.test2 ADD CONSTRAINT
DF_Table1_description DEFAULT'The general steps are:

Back up the source database, which can reside on an instance of SQL Server 7.0, SQL Server 2000, or SQL Server 2005. The computer on which this instance of SQL Server is running is the source computer.

.'FOR description

sql

Long + Complicated IIF expression

Hello, I have a long / complicated IIF expression for opening
subreports from report 1 (navigation feature). If field = 1, open
subreport 1, if field = 2, open subreport 2, etc etc...and this goes
on.
What's an easier way to do this besides the IIF statement in Reporting
Services? I have about 15 conditions so it would be a very long IIF
expression...Thanks for your help.Create a method in the Code section of report properties and use regular If
or even use case statements.
You can then call this method from the same place you were putting your
IIF's
"RSNewbie" <alinka345@.gmail.com> wrote in message
news:1118942105.414500.325850@.g43g2000cwa.googlegroups.com...
> Hello, I have a long / complicated IIF expression for opening
> subreports from report 1 (navigation feature). If field = 1, open
> subreport 1, if field = 2, open subreport 2, etc etc...and this goes
> on.
> What's an easier way to do this besides the IIF statement in Reporting
> Services? I have about 15 conditions so it would be a very long IIF
> expression...Thanks for your help.
>|||what do you mean by method? What kind of code would I put there?

Logon Failed error in Crystal Reports

HI,

I have two tables T1 and T2 in Crystal Reports . I want to display 2 fields from T1 and 1 field from T2. I am using a dataset to populate the fields in the report. But I am getting Logon Failed error. The report displays fine when only one tables is used .
Please help me .
Thanks in advance.

AswiniDid you relate those two tables by the Keycolumn?
Do you have permission to access the tables?

Login with a case sensitive password with a Stored Procedure

I have a stored procedure that validates a user login against a username and password field.
How can I ensure case sensitivity in the stored procedure for the password field?Hi

If you cast both the inputted password and the stored password as varbinary, if they are not the same case they will not match.|||OK i tried it but how do I change the the user input from a string a varbinary for the
Stored procedure input parameter ?|||I figured it out.
Thank you, merkin|||If you use MD5 to encrypt the password then it will be case sensitive and won't be crackable if the table becomes visible to a hacker.