I have heard that even though the maximum varchar size is 8000, that we should not go higher than 7500 for the size value. What is the logic behind this advice?
View 1 Replieshow can set length of varchar more then 8000?
View 3 RepliesI have two database.one is "TEMS1" and another one is "TEMSLIVE"
"TEMS1" is my local database.
"TEMSLIVE" is client database.
my application is working fine while connecting to my local database. when connecting to client database("TEMSLIVE") it's shows "Msg 457, Level 16, State 1, Procedure GET_MY_TRAVEL_PENDING_ACTIONS, Line 53 Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved due to a collation conflict." this error. i have compared "TEMS1" and "TEMSLIVE" stored procedure(GET_MY_TRAVEL_PENDING_ACTIONS),but both are identical only.
I know that varchar(n) in sql server specifies that a variable character of n bytes can be stored But what value of "n" should I choose if I have to store a string of say 100 character in that field. I am not able to decide the size of varchar when creating a table in database when I have to store a string of say 50 characters or string or 100 or say 1000 characters.
View 8 RepliesI'm trying to compare a string from a label to a varchar(50) in my database. String Occasion = '1 2010-07-07 10:00' compared to varchar(50) OccasionID = '1 2010-07-07 10:00'
[Code]....
[Code]....
I've checked that the values really are identical in the debug. I was under the impression that no conversion is neccessary between string and varchar, but maybe I'm wrong.
I am using sql server 2008. Could anyone tell me the differance between varchar(25) and nvarchar(25)? Which is more efficient?
View 3 RepliesI'm trying to create a stored procedure that get a Key and Name (both varchar), the procedure will check if a the key allready exists in the table, if it exists it will update the name, if its not exists it will add it to the table..
View 2 RepliesIn SQL ......
"reading_i" is smallmoney
"reading_f" is smallmoney
CAST(ABS((reading_i - reading_f)) AS VARCHAR)
I want four decimal places alwaysfor example
reading_i = 3.123
reading_f = 1.23
I want 1.8930 (always four decimal places)
I have a doubt in regards to use varchar or nvarchar for portuguese content, so the question is:varchar support all portuguese chars? or must I use nvarchar (unicode)
View 2 Repliesi have a column in my table of type varchar (50)
beek1
beek10
beek3
beek6
beek61
beek2
i want to sort in my sql querry like this
beek1
beek2
beek3
beek6
beek10
beek61
how to write Sql querry to sort a column of type varchar (50) that contains number
a1
a2
a3
a11
a21
instead of
a1
a11
a2
a21
a3
Below one is model table, am getting strange issue, i dont know how overcome this issue
[Code]....
Even i tried to convert the varchar to numberic, and also am getting same issue.
Can any one please guide, how to convert the above one.
I get the following error "Conversion failed when converting the varchar value ' (' to data type int." when executing this code
View 2 RepliesSo I have a ntext column in a table with a combination of large random data (hence why ntext in the first place) and sometimes contains a uniqueidentifier.
I need to find and delete rows based on the uniqueidentifier.
I can't do the comparison with it being ntext, but I changed it to varchar(max) in my dev enviornment and it let me do it without any warnings and I can now do my comparison like I want to, so all is good.
I just want to make sure I'm not changing any of my large random data by changing the data type.
<Conversion failed when converting the varchar value 'ID' to data type int.>am trying to insert datavalueField for a drop down list into a table column, its type is int. am using this syntax
[Code]....
My filter Expression was working fine with filtering by Control Parameters.When I added the Phone Parameter it went nuts - with the Phone Parameter the GridView just Comes out blank upon loading the page (without it would show Select * from Individuals)Is it because the phone field is populated with numbers? Don't get it.... In the SQL server the 'phone' field is set to 'varchar(30)' and nulls are allowed.here is my code:
[Code]....
Select number,empname,empfathername from emp
where number column is float data type
I need first four dights of number where it consists 10 digits.
num is 1234567890
O/P like to be
1234
I want to change one of my table columns data type. Now the column data type is varchar and i want to change it to float. Updated all the column data to numeric and tried to convert the datatype with the following syntax
alter table vibration_values alter column dis_v float
but getting the error as
Error converting data type varchar to float.
The statement has been terminated.
Suprisingly every thing worked well in sqlserver 2005 and not working in sqlserver 2000.
I am storing date data in sql server as varchar but I want to make comaparisons on this field in where clause- like this field from 2 days before or after etc
View 3 RepliesI have written a small Asp.net application using Entity Framework.
A Stored Procedure accepts the following: employeeID int, startDate varchar(12),endDate varchar(12)
I then use SQL server to convert the short date strings to DateTime.
SET @correctStartDate = CONVERT(DATETIME,(convert(varchar(10),@startDate,103) + ' 00:00:00am'), 103)
SET @correctEndDate = CONVERT(DATETIME,(convert(varchar(10),@endDate,103) + ' 11:59:59pm'), 103)
In development environment iis7 Windows Server 2008 with SQL Server 2008 R2 there are no issues.
If we deploy to production server iis6 (Windows Server 2003 SP2 with SQL Server 2008 R2) we get:
"The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.The conversion of a varchar data type to a datetime data type resulted in an out-of-range value."
Why would this be? Both have regional settings the same.
Not sure if this should be in SQL or .NET but as I'm doing this in asp.net I figured here..I'm trying to insert '00' into a varchar column of my database, when I do this its actually in the database as '0'... if I do '05' or '15' or '30' then its fine.
View 5 RepliesIm developing a web application in asp.net where i have gridview with some text box controls in it.In runtime we are creating a new row dynamically by clicking add button .To insert data into the database.i used a stringbuilder instead of string becoz the data what i have to insert into database is more.but i am gettin the following error No mapping exists from object type System.Text.StringBuilder to a known managed provider native type. in database the datafield column datatype is varchar(max).
View 3 RepliesI want to use three language: English, German and italian. If i will use varchar type, will i face any problem or I have to use nVarchar.
View 3 Repliesi was given a form in which empid is varchar and i m supposed to auto increment it using a function and calling it ....i have never done this. plz help me out the way .
View 9 RepliesI've got an SQL script that fetches results based on the colour passed to it, but unless I set the size of the variable defined as a varchar to (50) no results are returned.
If I use: like ''+@Colour+'%' then it works but I don't really want to use it in case it brings back results I don't need or want.
The column FieldValue has a type of Varchar(Max) (which can't be changed as this field can store different things). It is part of aspdotnetstorefront package so I can't really change the tables or field types.
This doesn't work:
declare @Col VarChar
set @Col = 'blu'
select * from dbo.MetaData as MD where MD.FieldValue = @Colour
But this does work:
declare @Col VarChar (50)
set @Col = 'blu'
select * from dbo.MetaData as MD where MD.FieldValue = @Colour
The code is used in the following context, but should work either way
<query name="Products" rowElementName="Variant">
<sql>
<![CDATA[
select * from dbo.MetaData as MD where MD.Colour = @Colour
]]>
</sql>
<queryparam paramname="@ProductID" paramtype="runtime" requestparamname="pID" sqlDataType="int" defvalue="0" validationpattern="^d{1,10}$" />
<queryparam paramname="@Colour" paramtype="runtime" requestparamname="pCol" sqlDataType="varchar" defvalue="" validationpattern=""/>
</query>
Also I can't set the size in <queryparam paramname="@Colour" paramtype="runtime" requestparamname="pCol" sqlDataType="varchar" defvalue="" validationpattern=""/>