Is it possible to modify column data type of view

Hot Topic

No data in cube while browsing (URGENT!)
Windows Mobile 5 connecting to SQL Server 2005
Javascript Error When trying url access
one to one relationship
ODBC linked table support in SQL SERVER 2005
MSRS + Fit to Page
Problem with Hyphen in server name?
Transforming a "?" to NULL value
Installing SQL Server 2005 Express edition
Error when calling a Sub report (Jump to report)

SQL Server

More Merge Join question
Smart App to Endpoint Kerberos Authentication
Format of zeros
Transactions, package.transactionOption=support
Switch / choose / IIf in expression
Decode Base64 to Image!
connection string
how do i use a secure non-windows smtp server with ssis?
Multiple inserts against single insert from temp table
Simultaneous DB access

Is it possible to modify column data type of view

The SQL Server Management Studio shows the data type of each column of views. I am wondering how SQL server determines the types since my SQL code of views does not specifiy data types for any columns.

I am much more interested in knowing whether the data types can be modified. Could anyone offer some hint

Thanks,

hz




Answer this question

Is it possible to modify column data type of view

  • mnemon

    SQL Server uses the underlying schema information to do so unless you don’t specify a different data type than the source data type (liek within CONVERT). You can change the resulting data type in the view e.g. via CONNVERT(VARCHAR(10),GETDATE(),112), which was a datetime before and a varchar afterwards.

    HTH, Jens Suessmeyer.

  • Kirk Larsen

    Jens, thanks a lot! That is exactly what I was looking for.

    hz



  • Is it possible to modify column data type of view
Answer this question