Top "Sqldatatypes" questions

Concerns data types used with SQL.

SQL DataType Negative Decimal

Im inserting Data into a database, they have a decimal and a negative number, is there a way to the …

sql decimal sqldatatypes
Workaround for ORA-00997: illegal use of LONG datatype

I want to save some data from a system table user_tab_cols, to a temp table so I can …

sql oracle sqldatatypes sqllong
Why doesn't SQL Server support unsigned datatype?

I am specifically thinking about unsigned int. Here is a practical example: what do you do when your identity column …

sql sql-server sqldatatypes unsigned-integer
Is it possible to change the datatype of a column in a view?

Usually I run a script like this: ALTER TABLE [TABLE] ALTER COLUMN [Column] NVARCHAR(40); The result is that the field …

database sql-server-2008 tsql view sqldatatypes
Entity Framework Code First Date field creation

I am using Entity Framework Code First method to create my database table. The following code creates a DATETIME column …

c# entity-framework entity-framework-4.1 code-first sqldatatypes
Difference between DECIMAL and NUMERIC datatype in PSQL

what is the use of decimal and numeric datatype in postgreSQL. As per the reference the following is the explanation …

postgresql rdbms sqldatatypes
which datatype to use to store a mobile number

Which datatype shall I use to store mobile numbers of 10 digits (Ex.:9932234242). Shall I go for varchar(10) or for the …

sql-server-2005 sql-server-2008 sql-server-express sqldatatypes
Change datatype varchar to nvarchar in existing SQL Server 2005 database. Any issues?

I need to change column datatypes in a database table from varchar to nvarchar in order to support Chinese characters (…

sql sql-server sql-server-2005 sqldatatypes
What's the difference between MySQL BOOL and BOOLEAN column data types?

I'm using MySQL version 5.1.49-1ubuntu8.1. It allows me to define columns of two different data types: BOOL and BOOLEAN. …

mysql sqldatatypes
Column, parameter, or variable #10: Cannot find data type

I'm trying to create table from template code. This template code is working: CREATE TABLE [dbo].[Table1] ( [Field1] [int] NULL, […

sql-server tsql sqldatatypes create-table