VARCHAR

Date formats and Microsoft Analysis Services

How can we convert date format in analysis services form yyyy-mm-dd to dd-mm-yyyy without converting date to varchar Thanks

is varchar numeric

sql to check varchar as numeric

Convert column from Number(9) to varchar2(3) in SQL

What is the quickest way of achieving a total column datatype change from number(9) to varchar(3)? I have a few million rows in this table and SQL will run forever ....

Execute a view/query is slower in SQL Server 2005 than 2000

Hi, I have migrated a database from 2000 to 2005, updated the statistic and rebuild the index. When I run the following query "select top 500 * from myview order by name", it is extremely slower in 2005 than 2000. The myview simply does an inner join with 2 table. The name is varchar(50)....

The difference between VARCHAR and NVARCHAR

What is the difference between varchar and nvarchar?

DB2/400 field to match an Oracle VARCHAR?

We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR? Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS field, apparently any...

Need help creating a specific Oracle View

We have several tables with what would probably have been nested columns if that feature had existed when they were created. They are simple VARCHAR2 columns occurring a fixed number of times (2 to 4). Since they are often null, the true number is variable with a fixed maximum. Although we would...

Converting date time in C#

hi all, I have a column called WBsstartdate (storing dates), that has been created as a Varchar data type. If I run a convert on the table, my date comes out in the right format. (Eg: 2006-04-03 00:00:00). This is fine. However when I run this date as an sql query in a programme in C#, and save...

Define array in Oracle

i have coulumb stn varchar2(100) , i want to split it to 4 columbs n1 varcha2(20)...n4 varchar2(20) ,depend on space eg: stn : John Adms Smith Zac n1 : John n2 : Adms n3 : Smith n4 : Zac i use oracle8.0.5 developer6

Converting a varchar to a numberic in SQL query

How can we convert a varchar field to Numberic in a SQL Query in db2 400?

Replace a variable part of a string in a varchar2 field

I have a vendor Oracle table containing data as follows column name: PVC_Value value = TRKCASETRK;6,0,0,0,0,0,0;;20801911;32004910;43175007;2,2;0;59647;1,30;0;0;3002 As you can see this field contains data delimited by semi-colons (for 13 elements) I need to relace the 7th and 10th elements in...

Crystal Reports and varchar(MAX) not printing

Hi All, I have a Crystal Reports report (VS2005 version) that prints a number of fields from a SQL table. When I print the report under Windows XP, everything works properly. When I print under Windows Vista on a tablet PC, the report prints, except for the varchar(MAX) field. Does anyone know a...

Error In SQL SERVER DataBase

am trying to insert four varchar(50) values in a table which is with a primarykey column id_number. i didnt check : "True" to the null field . so it should not allow null values in table. but while am trying . it allows null values. including primary key column. how is possible ? pls help me....