Search: datatypes

More Results

Sort by: Relevance | Date

  • Manage, query SQL Azure Federations using T-SQL

    EDITOR’S NOTE: The following is the first article in a two-part series on managing Microsoft’s sharding technology SQL Azure Federations with Transact-SQL (T-SQL). Part 1 focuses on using T-SQL to create federated tables and migrating data... Tip   |   SearchSQLServer.com

  • PL/SQL datatypes in Oracle

    Learn about PL/SQL datatypes in Oracle, and learn the definitions of BLOB, CLOB, DATE, VACHAR2 and more in this PL/SQL tutorial for beginners and experts. Learning Guide   |   SearchOracle.com

  • Adding column and changing datatype

    I need to add a column and change a datatype on a publishing table in a replicated database. I would like to do this without having to drop and recreate replication. Is there a way? I am using SQL Server... Ask the Expert   |   SearchSQLServer.com

  • Getting the most out of SQL Server information schema views

    Information schema views are one of several methods available in SQL Server for accessing... Tip   |   SearchSQLServer.com

  • Correct use of CLOB datatype

    I have a database design where CLOB datatypes are being used in place of VARCHAR2 datatypes. The VARCHAR2 datatypes are not large. I believe this was done was to use ConText indexes for Web page... Ask the Expert   |   SearchOracle.com

  • Changing datatype of one column

    I have an Oracle table with 8 million records. I need to change the datatype associated with one of the columns. What would be the best process for doing this? I am a .NET developer and do not know exactly how to approach this. Ask the Expert   |   SearchOracle.com

  • Extracting from LONG datatype column

    I have a table with a column specified as the LONG datatype. When selecting data I get the following error: "ORA-00932: INCONSISTENT DATATYPE." Is there a quick way to extract this information? Ask the Expert   |   SearchOracle.com

  • Conversion of char datatype to datetime datatype resulted in an out of range datetime value

    We have an application in VB which runs in Windows 2000/SQL2000. The same application gives the following error "conversion of char data type to datetime data type resulted in an out of range datetime value" in Windows... Ask the Expert   |   SearchSQLServer.com

  • Sending valid datatypes

    Using PHP to connect an axis based server, I cannot send parameters as long (I send int or doubles), is there any way to have Axis being a little nicer to int or doubles ? Or is there a way to send "long" via PHP + PEAR soap... Ask the Expert   |   SearchSOA.com

  • Using BLOB and CLOB datatypes to store, retrieve an image in Oracle 9i

    Expert Brian Peasland explains how to use large objects (LOBs) in Oracle, such as BLOB and CLOB datatypes, to store and retrieve an image greater than 1 GB. Ask the Expert   |   SearchOracle.com

Search Again: