Home Articles SQL Server 2012 SQL Server 2014 SQL Server 2016 FAQ Practice Test

Tip of the Day : SQL Server Numeric Data Types

What's New in SQL Server 2008 Compound Operators SQL Server 2008 introduces the Compound Operators which execute some operation, such as + (addition), - (subtraction), * (multiplication) and / (division), and set an original value to the result of the operation. Multiple Value Inserts Within a Single INSERT Statement One of the new programmability enhancements in the Database Engine introduced in SQL Server 2008 for Transact-SQL is the row constructor which consists of a single VALUES clause with multiple value lists enclosed in parentheses and separated by a comma.  With the row constructor, you can now insert multiple values using a single INSERT statement. Row Constructor (or Table-Valued Constructor) as Derived Table In this article, we will show how to use the row constructor (also called as table-valued constructor) as a derived table which you can use in the FROM clause of a SELECT statement and as a source table in a MERGE statement, yet another new statement introduced in SQL Server 2008. MERGE Statement One of the common tasks in database management is the maintenance of lookup tables.  Maintenance of these look-up tables are usually done using stored procedures where the normal task is to add the new record if it does not exist or update the existing record if it already exists based on the identified primary key of the table.  SQL Server 2008 introduces a new statement called MERGE statement which combines these functionalities into just a single statement.  The MERGE statement performs an INSERT, UPDATE or DELETE operation on a target table based on the results of a join with source table. Table-Valued Parameters SQL Server 2008 introduces a new parameter type called the table-valued parameters.  With the table-valued parameters, which are declared by using user-defined table types, you can now send multiple rows of data to a function or stored procedure without creating a temporary table or many parameters. Date and Time Data Types Test Description Spatial Data Type Importing Geography and Geometry Data Types Test Description Difference Between Geography and Geometry Data Types Connection String Description Convert Latitude / Longitude Into Geography Data Type Connection String Description Date and Time Data Type Get Date Only - Revisited Test Description Date and Time Related Messages Connection String Description SQL Server 2008 Connection Strings SqlConnection Connection String SqlConnection Connection String Description OleDbConnection Connection String OleDbConnection Connection String Description OdbcConnection Connection String OdbcConnection Connection String Description SQL Server 2008 Articles Error in Importing/Exporting Geography/Geometry Columns in SQL Server 2008 Management Studio When importing or exporting a table with a geometry or geography column, you might encounter an "unknown column type conversion" error.  This article shows how to manually resolve the issue. SQL Server 2008 to Windows Server 2008 Connection Error 1326 This article discusses the two ways (automatic and manual) of opening the firewall port for SQL Server on Windows Server 2008 to solve the issue of "Could not open a connection to SQL Server (Microsoft SQL Server, Error: 1326)". Store Locator Using Geography Data Type Most, if not all, retail store websites and bank websites have a way of helping their customers locate any of their retail store locations or bank branches given either a ZIP code or a full address.  Using the new Geography data type, SQL Server 2008 makes it easy to generate a list of store locations or bank branches given an address. Convert Latitude/Longitude (Lat/Long) to Geography Point Prior to SQL Server 2008, geography locations are usually stored as latitude and longitude coordinates in two separate columns.  With the introduction of spatial data types in SQL Server 2008, particularly the GEOGRAPHY data type, this can now be stored as points in a single column stored as a spatial data object. MERGE Statement With Table-Valued Parameters This article continues the discussion of the Table-Valued Parameters article and will combine this new feature with the MERGE statement, yet another new feature of SQL Server 2008. SqlConnection Connection String This article shows the different connection strings that you can use when connecting to SQL Server 2008 using .NET Framework Data Provider for SQL Server, the SqlConnection class. How to Import Data from Microsoft Excel 2007 to SQL Server 2008 Importing data from a Microsoft Excel file prior to MS Excel 2007 was a straightforward task by simply selecting Microsoft Excel as the Data Source from the SQL Server Import and Export Wizard.  With Microsoft Excel 2007 files, selecting Microsoft Excel as the Data Source will not work because this Data Source is only for Microsoft Excel 97-2005.  This article walks you through the process of importing a Microsoft Excel 2007 file into a SQL Server 2008 database. SQL Server 2008 Date Formats One of the most frequently asked questions in SQL Server forums is how to format a datetime value or column into a specific date format.  Here's a summary of the different date formats that come standard in SQL Server as part of the CONVERT function.  Following the standard date formats are some extended date formats that are often asked by SQL Server developers.