Question: What are
the different types of data types in SQL Server?
Answer: There are
different types of data types used in SQL Server
1. Int
2.
Small int
3.
Big int
4.
Tiny int
5.
Float
6.
Double
7.
Decimal
8.
Money
9.
Char
10.Varchar
11.Nvarchar
12.Nchar
13.Varbinary
14.Varbinary max
15.Small date time
16.Date time
17.Ntext
18.Numeric
19.Sql variant
20.Blob.
21.Glob
22.Unique identifier
23.Nvarchar max
Question: What is
the use of different types of integer data types?
Answer: Tiny int,
SmallInt, Int and Bigint are the different types of integer data types. The
difference is for size range.
Question: What is
times stamp data type is SQL Server?
Answer: Timestamp is the column in database for which counter increments when there is insert or update in table. This time is a relative time in database which in not real with clock time. Every time when there is a modification in row timestamp values updates with new timestamp of that database.
Answer: Timestamp is the column in database for which counter increments when there is insert or update in table. This time is a relative time in database which in not real with clock time. Every time when there is a modification in row timestamp values updates with new timestamp of that database.
This column considered
as poor candidate for primary key index or any kind of key as it’s not stable.
No comments:
Post a Comment