\nSee page 134 of 'Beginning SQL Server Express 2008)\n<\/p>\n
\nvarchar(50)\n<\/p>\n
\nFor short text fields\n<\/p>\n
\nvarchar(MAX)\n<\/p>\n
\n(Will eventually supercede text type)\n<\/p>\n
\nvNarchar(50)\n<\/p>\n
\nUnicode so double storage space but not limited characterset\n<\/p>\n
\nnVarchar(MAX)\n<\/p>\n
\nUnicode so double storage space but not limited characterset\n<\/p>\n
\ntext\n<\/p>\n
\nDon't Use – Use varchar instead as this will be superceeded by it\n<\/p>\n
\nbinary\n<\/p>\n
\nUsed for flags etc (see bit in 'data' for a general boolean data type)\n<\/p>\n
\ntinyint\n<\/p>\n
\n8bit unsigned 0 – 255\n<\/p>\n
\nsmallint\n<\/p>\n
\n16bit (-32,768 – 32,767)\n<\/p>\n
\nint\n<\/p>\n
\n32bit (-2,147,483,648 – 2,147,483,647)\n<\/p>\n
\nbigint\n<\/p>\n
\n64bit\n<\/p>\n
\nfloat\n<\/p>\n
\nreal\n<\/p>\n
\nsmalldatetime\n<\/p>\n
\nDon't use as only runs to 2079\n<\/p>\n
\ndatetime\n<\/p>\n
\nStandard date and time\n<\/p>\n
\ndatetime2\n<\/p>\n
\nSame as datetime but allows fractions of a second to be stored.with greate precision\n<\/p>\n
\ndate\n<\/p>\n
\nTo store only the date\n<\/p>\n
\ntime\n<\/p>\n
\nStores time based on 24 hour clock\n<\/p>\n
\nbit\n<\/p>\n
\nTrue or false values\n<\/p>\n
\nbinary\n<\/p>\n
\nUsed for flags etc\n<\/p>\n
\nvarbinary\n<\/p>\n
\nFor holding data such as images. For file sizes > approx 1-2MB it's more efficient to use an external filestream for the actual data storage (which also removes them from the database backup).\n<\/p>\n
\nYou either specify varbinary(n) and give a specific number up to 8000bytes (more is not possible), or you define the column to be varbinary(max) in which case it can hold up to 2 GB of data.\n<\/p>\n
\nimage\n<\/p>\n
\nDue to besuperceeded by binary – don't use\n<\/p>\n
\nBeginning SQL server 2008 express see page 155\n<\/p>\n
\r\n\r\nif not exists (select * from syscolumns\r\n where id=object_id('\r\n') and name='\r\n')\r\n alter table\r\n add\r\n\r\nif not exists (select * from syscolumns\r\n where id=object_id('Employees') and name='MaidenName')\r\n alter table Employees add MaidenName varchar(64) NULL\r\ngo\r\n<\/code><\/pre>\n\nAdd leaving new column set to null for all rows
\n<\/h5>\n\r\n\r\n SqlClient::SqlConnection ^SqlConnection1 = gcnew SqlClient::SqlConnection();\r\n SqlConnection1->ConnectionString = DataSourceString + DatabaseConnectionString;\r\n try\r\n {\r\n SqlConnection1->Open();\r\n \/\/Add 'IsRecording' column\r\n SqlClient::SqlCommand ^SqlCommand1 = gcnew SqlClient::SqlCommand();\r\n SqlCommand1->Connection = SqlConnection1;\r\n SqlCommand1->CommandType = CommandType::Text;\r\n SqlCommand1->CommandText = "if not exists (SELECT * from syscolumns WHERE id=object_id('tblLocations') and name='IsRecording') ALTER TABLE tblLocations ADD IsRecording bit NULL";\r\n affected = SqlCommand1->ExecuteNonQuery(); \/\/affected = number of rows affected\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"Column Types See page 134 of 'Beginning SQL Server Express 2008) Text varchar(50) For short text fields varchar(MAX) (Will eventually supercede text type) vNarchar(50) Unicode so double storage space but not limited characterset nVarchar(MAX) Unicode so double storage space but not limited characterset text Don't Use – Use varchar instead as this will be superceeded […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[125],"tags":[],"class_list":["post-42","post","type-post","status-publish","format-standard","hentry","category-columns"],"_links":{"self":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/42","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/comments?post=42"}],"version-history":[{"count":8,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/42\/revisions"}],"predecessor-version":[{"id":1614,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/42\/revisions\/1614"}],"wp:attachment":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/media?parent=42"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/categories?post=42"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/tags?post=42"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}