You can use the database create script at the bottom of this page in the section Creating a test database to do this.To run the My Database Create Script, open the View menu, and then choose SQL Server Object Explorer or choose the Ctrl \, Ctrl S keys.In SQL Server Object Explorer window, open the shortcut menu for the appropriate instance, choose New Query, copy the script at the bottom of this page, and then paste the script into the editor.To run the SQL script, choose the toolbar icon with the triangular symbol, or choose the Ctrl Q keys.Column Store Index is a new feature in SQL Server 2012 that improves performance of data warehouse queries several folds.Unlike regular indexes or heaps, which store data in B-Tree structure (in row-wise fashion), the column store index stores data in columnar fashion and uses compression aggressively to reduce the disk I/O needed to serve the query request.
A record, also called a row, is each individual entry that exists in a table.
For more information about SQL Server Object Explorer, see Connected Database Development. You can then select each block of code as you add it and press Alt Enter to run it in F# Interactive. Submit Changes() printfn "Successfully deleted all pending rows." with | exn - for the database schema.
In this step, you create a type provider for your database schema. The simplified data context is easier to use when you are constructing queries because there are not as many members available.
For information about the use of PL/SQL records with SQL to update and insert data, see Inserting Records Into the Database and Updating the Database with Record Values.
For more information about assigning values to PL/SQL variables, see Assigning SQL Query Results to PL/SQL Variables.