Top "Sqldatatypes" questions

Concerns data types used with SQL.

How to get the SqlType of a column in a DataTable?

I have a DataTable obtained from a SQL DataBase, like this: using (SqlCommand cmd = new SqlCommand(query, _sqlserverDB)) { using (SqlDataAdapter …

c# sqldatatypes datacolumn
Is "NUMBER" and "NUMBER(*,0)" the same in Oracle?

In Oracle documentation it is mentioned that NUMBER (precision, scale) If a precision is not specified, the column stores values …

sql oracle types oracle11g sqldatatypes
SQL Server: Checking the datatype of a column

How to check if a column in a table has a specific datatype? For example, how to check if a …

sql-server-2008 sqldatatypes
Converting dates with PHP for DATETIME in SQL

I have a forum in PHP which takes a date like in the form dd/mm/yyyy hh:mm:ss. …

php mysqli sqldatatypes type-conversion
SQL Server 2008 – Unsigned Integer Data Types

I am using SQL SERVER 2008, I have a number of INT, SMALLINT fields in my various tables, And I know …

sql sql-server-2008 sqldatatypes unsigned-integer
What is difference between storing data in a blob, vs. storing a pointer to a file?

I have a question about the blob data type in MySQL. I read that the data type can be used …

mysql blob sqldatatypes
store only date in database not time portion C#

I have a test class and an ExecutionDate property which stores only date but when we use [DataType(DataType.Date)] …

c# entity-framework datetime sqldatatypes entity-framework-6.1
PostgreSQL: what is the difference between float(1) and float(24)?

I am having a hard time understanding the precision parameter p for float(p) in PostgreSQL. For example, float(1) and …

postgresql floating-point precision sqldatatypes floating-point-precision
Converting Varchar to NVarchar?

I know when converting from nvarchar to varchar, some data will be lost/changed. However, are there any risks of …

sql sql-server-2008 varchar nvarchar sqldatatypes
Can we create a column of character varying(MAX) with PostgreSQL database

I am unable to set the max size of particular column in PostgreSQL with MAX keyword. Is there any keyword …

postgresql postgresql-9.3 sqldatatypes