Concerns data types used with SQL.
I am working with a table in a PostgreSQL database that has several boolean columns that determine some state (e.…
postgresql sqldatatypes bitmask postgresql-9.0One of the columns in a somewhat large table (~10,000 records) is of the data type DECIMAL(10,0). I'm using MySQL. I'd …
mysql types sqldatatypesIf varchar(max) is used as the datatype and the inserted data is less than the full allocation, i.e. …
sql-server sqldatatypes varcharmaxUsing Database first design and having tinyint (or smallint) column: [MyEnumColumn] [tinyint] NOT NULL I mapped this column to Enum …
entity-framework-5 sqldatatypesWhat is the use of the following declarations, and where will we use these types of declarations? myrow tablename%ROWTYPE; …
postgresql plpgsql rdbms sqldatatypesI have a rating system that ranges from -1 to 5 through 0. So i need to store the following values -1 0 1 2 3 4 5 …
mysql sqldatatypes negative-numberI want to increase my database performance. In a project, all tables went from int to bigint, which I think …
performance postgresql int sqldatatypes bigintWhat is the correct column type for holding ZipCode values in PostgreSQL database?
postgresql zipcode sqldatatypesWhat is the difference between user_type_id and system_type_id in the view of sys.types in sql …
sql-server sqldatatypesThe database development standards in our organization state the varchar fields should not allow null values. They should have a …
sql-server null types nullable sqldatatypes