Using New Data Types in 2008. Andrew Couch UK Access User Group www.ukaug.co.uk ASC associates www.upsizing.co.uk. Flow of Presentation. Data types and products Share Point : Access & SQL Server SQL Server : Access & Visual Studio SQL Server New Data Types
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
UK Access User Group
SQL Server (2008)
Visual Studio (2005/8)
Share Point (2003)see next slide
n prefix for Unicode
Data is held in the AllUserData table which has a generic set of fields,
some people would suggest that image data should not directly held in the
database and instead a text link is used to point to an external image file
which works around this issue
Visual Studio does not utilise timestamps on bound controls the new LINQ will support timestamp concurrency
WHERE "au_id" = ? AND "au_lname" = ? AND "au_fname" = ?
AND "phone" = ? AND "address" = ? AND "city" = ? AND "state" = ? AND "zip" = ? AND "contract" = ?
WHERE "au_id" = ? AND "ts" = ?
Timestamps improve efficiency and remove potential problems
with rounding errors in numerical data
UpdateCommand = "UPDATE [Customers] SET [CustomerID] = @CustomerID, [CompanyName] = @CompanyName, [ContactName] = @ContactName, [ContactTitle] = @ContactTitle, [Address] = @Address, [City] = @City, [Region] = @Region, [PostalCode] = @PostalCode, [Country] = @Country, [Phone] = @Phone, [Fax] = @Fax WHERE [CustomerID] = @original_CustomerID AND [CompanyName] = @original_CompanyName AND COALESCE([ContactName],'') = COALESCE(@original_ContactName,'') AND COALESCE([ContactTitle],'') = COALESCE(@original_ContactTitle,'') AND COALESCE([Address],'') = COALESCE(@original_Address,'') AND COALESCE([City],'') = COALESCE(@original_City,'') AND COALESCE([Region],'') = COALESCE(@original_Region,'') AND COALESCE([PostalCode],'') = COALESCE(@original_PostalCode,'') AND COALESCE([Country],'') = COALESCE(@original_Country,'') AND COALESCE([Phone],'') = COALESCE(@original_Phone,'') AND COALESCE([Fax],'') = COALESCE(@original_Fax,'')"