Some Unique Datatypes In MSSqlServer

1)

Timestamp : –  8 Bytes

This is Just Read Only

It’s Update Version is Reversion

It’s Column Can’t be Updated

2)

Row Version

This Can’t be used in Primary Key.

This Generatre Version for row.

3)

Cursor            -> Store to Data Pointer

4)

Hierarchy ID -> It Maintain Hierarchy of Record.

5)

Spatial -> This Datatype Include Two Datatype

1) Geomatric-3d

2) Geographic -2d

It Deal with storing Co-ordinates.

For Example –Point,Line-Stream,Polygon, Multipoint, Multiline Stream and Multi Polygon.


Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s