Griffiths web design based in Royston, Hertfordshire, United Kingdom


Sql Server Data Types and their ASP.NET equivalents.

Author:   Michael Griffiths

Date created:   30 July 2016

[postpic=creativedatabase.jpg class=img-responsive center-block title=DataTypes alt=DataTypes style=STYLE][/postpic] [l]As developers we are expected to remember a vast array of things. From programming languages to all the little browser nuances. Being the resourceful folks that we are we have handy little references for almost everything. Today I want to add another reference sheet to your knowledge toolkit. So without further ado I present to you….. A table which displays a list of SQL Server data types and their .NET equivalents. Wow that was an anti-climax.[/l] [c][table][trow][thead][b]SQL Server type[/b][/thead][thead][b]ASP.NET type[/b]/thead][/trow][trow][tdata]char[/tdata][tdata]String[/tdata][/trow][trow][tdata]nchar[/tdata][tdata]String[/tdata][/trow][trow][tdata]varchar[/tdata][tdata]String[/tdata][/trow][trow][tdata]nvarchar[/tdata][tdata]String[/tdata][/trow][trow][tdata]tinyint[/tdata][tdata]Byte[/tdata][/trow][trow][tdata]smallint[/tdata][tdata]int16[/tdata][/trow][trow][tdata]int[/tdata][tdata]int32[/tdata][/trow][trow][tdata]bigint[/tdata][tdata]int64[/tdata][/trow][trow][tdata]smallmoney[/tdata][tdata]Decimal[/tdata][/trow][trow][tdata]money[/tdata][tdata]Decimal[/tdata][/trow][trow][tdata]decimal[/tdata][tdata]Decimal[/tdata] [/trow][trow][tdata]Float[/tdata][tdata]Double[/tdata][/trow][trow][tdata]date[/tdata][tdata]DateTime[/tdata][/trow][trow][tdata]datetime[/tdata][tdata]DateTime[/tdata][/trow][trow][tdata]datetime2[/tdata][tdata]DateTime[/tdata][/trow][trow][tdata]datetimeoffset[/tdata][tdata]DateTimeOffset[/tdata][/trow][trow][tdata]time[/tdata] [tdata]TimeSpan[/tdata][/trow][trow][tdata]uniqueidentifier[/tdata][tdata]Guid[/tdata] [/trow][trow][tdata]bit[/tdata][tdata]Boolean[/tdata][/trow][/table][/c]

About the author

My name is Michael Griffiths, I am a website designer and developer and the owner of Griffiths Web Design. I am based in Royston, Hertfordshire. Most of my work is local, Hertfordshire, Cambridgeshire, Bedfordshire, Essex etc. but that’s not to say I won’t work elsewhere. One of the wonders of modern technology is remote working. So no matter where the client is located it is always possible to connect.

I specialise in creating ASP.NET webforms applications using C#. I use Microsoft SQL Server for database development and on the front end I use Html, CSS and JavaScript. I am also proficient in the use of jQuery and several CSS frameworks.

One of my greatest passions in life is learning. Which is why I chose to pursue a career in web design and development, technology is in a state of constant and rapid evolution which means there is always something new to learn. I also enjoy writing, both fiction and non-fiction.


Please feel free to leave a comment below:

Griffiths Web Design Logo by Michael Griffiths
Griffiths Web Design Logo by Michael Griffiths