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 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 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'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=""/>
I have an output parameter called '@packIds', that I create in ADO.Net using the code below:
SqlParameter packIdPara = new SqlParameter("@packIds", null);
packIdPara.SqlDbType = SqlDbType.VarChar;
packIdPara.Direction = ParameterDirection.Output;
sqlCmd.Parameters.Add(packIdPara);
How will I specify that the parameter '@packIds' is of max size? I cannot find any code for this.
[Code]....
1) we have only one select query to select 5 column form the table(i.e. select col1,col2,col3,col4,col5). so in that case should we go for stored procedure Or we can directly write the select query in the .Cs file only ( means in Database layer). when we should go for the SQL server stored procedure and when we should go for in line query in Visual Studio itself.
2)how to decide when to use Clustered and when to use Non Clustered index?
how can set length of varchar more then 8000?
View 3 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.
This is a pretty basic question. Since browsers have a culture setting that the web app uses to decide which locale to use, should I still have a "language" button for users to be able to override the culture? Why or Why Not? To me it doesn't make sense to have a button there if the user had already set their language in their system.
View 1 RepliesI 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]....
How can i decide wich images can be viewed and witch cannot?
Is it possible to keep all the files in one folder but programaticaly decide wich ones can be seen?
I dont want the user to be able to navigate and browse the folder with all the images, but i want some images from the folder to be viewable for anonymous users.
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 have 3 page index.aspx and store.aspx and Electric.aspx
In index.aspx I have TB and button and this is my user’s table
ID Behcode Name Description T_name
1 2222 Iron Test Store
4 3333 Laundry Test Electric
When user type their behcode in TB it go to store.aspx and fill this page with user’s information
This is my code I use query string
protected void ImageButton3_Click(object sender, ImageClickEventArgs e) {
Response.Redirect(store.aspx?behcode=" + Server.UrlEncode(txtNumeric.Text));
}
[Code]....
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 Replies