technical-recipes.blogspot.com

Some instructions on how to use alternate portrait and landscape orientations in a Word document. Just as a simple illustration: suppose we want to configure a 3-page Word document to have a first page with portrait-style orientation, followed by a second page with landscape orientation and then a third page that is in portrait mode once again. So our Word document is currently structured as follows: Page 1 Contains some text that is easily accommodated by the portrait page orientation: [caption id="attachment_8840" align="alignnone" width="713"] portrait and landscape[/caption] Page 2 Contains text plus a table that is too wide to fit on a page with portrait orientation. This page (and only this page) we wish to change to landscape orientation in order to fit the table: Page 3 And the third page that we wish to keep as portrait again: To change page 2 to landscape without impacting pages 1 and 3, go to page 2, and select the t...

A few instructions on how to fire up SQL Server Management Studio (SSMS) in order to create a database, create a database table and perform various operations Creating a new database Open SSMS, right-click on Databases and select New Database... Give the database a name ('People' in this example) and select OK: Creating a new database table In the Object Explorer, select the database you created, right-click on Tables and select Table... (or New Table... in more recent versions of SSMS) You can fill in the column names and their data types like so Save the table by selecting Ctrl+S or via File > Save Table Making a column a primary key Select the column (in this case the column id) Right click and select Set Primary Key: So that the symbol for the primary key then appears in the column as shown: Also make sure the column property 'Is Identity' is set to Yes for id Unable to modify the database table? In some versions of SS...