No announcements
Found 1304248 threads
-
3 Votes
Which is best in performance CHAR or VARCHAR
The cutoff for char/varchar is around 20.Answered | 14 Replies | 27457 Views | Created by miruan - Wednesday, July 17, 2013 7:46 AM | Last reply by davidbaxterbrowne - Friday, April 17, 2015 10:05 PM -
0 Votes
char vs varchar in compressed (ROW/PAGE) tables, is there a difference
I was not expecting the row compression table size for varchar - char would be any different, I got surprised, which is ok.Answered | 10 Replies | 5215 Views | Created by GV1973 - Wednesday, April 25, 2012 3:20 PM | Last reply by GV1973 - Friday, April 27, 2012 8:24 PM -
0 Votes
Difference between varchar and varchar(max)?
VARCHAR is a data type similar to CHAR data type except it has the ability to store the exact length of the given data instead of leaving blank spaces for the given length limit .Answered | 7 Replies | 5194 Views | Created by iamanujit - Wednesday, December 10, 2014 11:16 AM | Last reply by RK-SQLDBA - Saturday, December 13, 2014 3:08 PM -
8 Votes
Choosing between char(n) and varchar(n)
VARCHAR(1) = '' is NOT LIKE ' ' while CHAR(1) = '' IS LIKE ' ' However, VARCHAR(1) = '' is = ' ' and ...Answered | 19 Replies | 9289 Views | Created by Kamran Shahid - Wednesday, February 17, 2010 1:28 PM | Last reply by Erland Sommarskog - Thursday, December 5, 2019 10:49 PM -
1 Votes
Converting VarChar to Numeric and Increment by 1 then convert back to VarChar
They mess up fixed length spaces on forms, they mess ups screens, they are a bench to check for validity (think about a varying length ZIP Code as opposed to the char(5) validation.Answered | 11 Replies | 8811 Views | Created by doddsw916 - Friday, August 10, 2012 1:54 AM | Last reply by --CELKO-- - Sunday, January 29, 2017 10:44 PM -
0 Votes
SQL 2008 VARCHAR & CHAR DATA TYPES NOT WORKING
Char and varchar are not supported as SQL CE is unicode ...you need to use Nchar and nvarchar.Answered | 9 Replies | 9255 Views | Created by SriLankan - Tuesday, September 7, 2010 3:30 PM | Last reply by Abhay_78 - Wednesday, September 8, 2010 10:33 AM -
0 Votes
Argument data type varchar is invalid for argument 1 of formatmessage function
SELECT * FROM sys.messages WHERE message_id = 20009 AND language_id = 1033; DECLARE @var1 VARCHAR(200); SELECT @var1 = FORMATMESSAGE(20009, ...Answered | 4 Replies | 23549 Views | Created by DataByter - Tuesday, March 10, 2015 5:14 PM | Last reply by Eric__Zhang - Wednesday, March 11, 2015 10:39 AM -
0 Votes
difference between varchar and nvarchar
Hmm, I don't see anyone suggesting VARCHAR can only hold 256 characters.Answered | 15 Replies | 5628 Views | Created by Sudip_inn - Wednesday, May 30, 2018 2:40 PM | Last reply by .theDBguy - Saturday, June 2, 2018 2:38 PM -
15 Votes
difference between char(13) and char(10)
char(13) is carriage return and char(10) is line feed.Answered | 4 Replies | 604393 Views | Created by salman shehbaz - Wednesday, October 29, 2008 10:00 AM | Last reply by Kalman Toth - Friday, March 9, 2012 8:19 AM -
0 Votes
SCCM 2007 different between messagestate (-1) and (1)
Dear Exprt, Can you please tell different between below two option?Answered | 1 Replies | 1251 Views | Created by Technicalsupp - Sunday, February 23, 2014 9:07 AM | Last reply by Garth Jones - Wednesday, December 24, 2014 2:50 PM -
29 Votes
varchar and nvarchar use (What is exact difference between these?)
1) - For what kind of data we should choose varchar or nvarchar.Answered | 12 Replies | 32728 Views | Created by S.P Singh - Tuesday, September 3, 2013 4:55 PM | Last reply by Tarunsrivastava - Thursday, May 1, 2014 10:26 AM -
1 Votes
Date calendar 1 year
.: SELECT * FROM dbo.fnCalendar(2008) --------------------------------------------*/ RETURNS @Calendar TABLE(dtDate ...Answered | 6 Replies | 3689 Views | Created by Jonel Amran - Tuesday, November 24, 2009 1:15 PM | Last reply by Kent Waldrop - Tuesday, November 24, 2009 5:14 PM -
0 Votes
Part of the string increase by 1
It was my comment and Noam added some thing that you have missed that he prefers explicit casts, even if char + intAnswered | 8 Replies | 3646 Views | Created by jasisic - Friday, September 25, 2009 4:45 PM | Last reply by Naomi N - Tuesday, September 29, 2009 5:03 AM -
1 Votes
Using VARCHAR as PK
However, if you're considering using a varchar(x) or char(x) as your clustered index, don't do it.Answered | 6 Replies | 7950 Views | Created by mrtaikandi - Wednesday, December 17, 2008 10:54 AM | Last reply by MUfford - Wednesday, December 24, 2008 5:07 PM -
3 Votes
1
Answered | 3 Replies | 4340 Views | Created by WouldReallyLikeToKnowMore - Monday, December 3, 2012 9:50 PM | Last reply by Just Karl - Tuesday, December 4, 2012 8:26 PM -
2 Votes
What does SSIS VARCHAR Parameter Size = -1 do?
Answered | 7 Replies | 5710 Views | Created by Ron Ruble1 - Wednesday, February 25, 2015 4:41 PM | Last reply by Ron Ruble1 - Wednesday, March 4, 2015 3:27 PM -
3 Votes
problem solving # 1
My blog 1.Answered | 8 Replies | 1641 Views | Created by Sandra VO - Tuesday, April 30, 2013 8:51 PM | Last reply by Sandra VO - Wednesday, May 1, 2013 6:48 PM -
0 Votes
Separate varchar into words when a uppercase char is found
CREATE FUNCTION CaseSensitiveSQLSplitFunction ( @str nvarchar(max) ) returns @t table (val nvarchar(max)) as begin declare @i int, @j ...Answered | 2 Replies | 2226 Views | Created by Laura Lobo - Saturday, March 26, 2016 3:24 PM | Last reply by Lydia Zhang - Monday, March 28, 2016 6:52 AM -
0 Votes
Create 1 to 1 relationship
It created a 1 to many relationship i tried looking at all properties to change it to a 1-1 but cant figure it out.Answered | 1 Replies | 8110 Views | Created by WIJ - Friday, January 7, 2011 9:05 PM | Last reply by Hugo Kornelis - Friday, January 7, 2011 11:58 PM -
2 Votes
varchar(max) and varchar(8000)
This is because varchar(8000) and varchar(MAX) are stored in different ways.Answered | 2 Replies | 13136 Views | Created by Nagasundar TN - Saturday, September 22, 2012 9:57 AM | Last reply by Erland Sommarskog - Saturday, September 22, 2012 10:32 AM - Items 1 to 20 of 1304248 Next ›
No announcements