Advertisement

10.10.2008 at 06:53AM PDT, ID: 23804109 | Points: 50
[x]
Attachment Details

varchar not big enough?

Asked by lobos in MS SQL Server

I have a web application that contains a field that is used to hold a list of all users that a specific e-mail was sent to. I have the field is currently a varchar of 8000 but its not going to be big enough, as more time passes the list of users e-mail is getting bigger...so I need to update/convert and change my application...which field should I use, and how do I go about updating my current proc.

Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:

CREATE procedure stp_Summary
					(
@guid nvarchar (50),
@date datetime,
@url nvarchar (1000),
@recipients varchar (8000)
					)
as
Begin
insert into summary (
guid,
datesent,
url,
recipients
)
values
(						 
@guid,
@datesent,
@url,
@recipients
)	
	return  @@IDENTITY 
	 	
end
GO
[+][-]10.10.2008 at 06:56AM PDT, ID: 22686933

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.10.2008 at 06:57AM PDT, ID: 22686936

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.10.2008 at 07:17AM PDT, ID: 22687119

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.10.2008 at 07:37AM PDT, ID: 22687264

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.10.2008 at 07:41AM PDT, ID: 22687291

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.10.2008 at 07:54AM PDT, ID: 22687394

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.10.2008 at 08:05AM PDT, ID: 22687489

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.23.2008 at 04:09AM PDT, ID: 22784806

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20081112-EE-VQP-42 - Hierarchy / EE_QW_2_20070628