technical-recipes.blogspot.com

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...

This post describes the steps needed to install and configure Microsoft SQL Server to perform full text searches within documents like Word, pdf, rich text format etc. These instructions require no prior knowledge of using or installing SQL Server - all steps from installation to implementation are included. 1. Install SQL Server. Go to MSDN Subscriber downloads: https://msdn.microsoft.com/en-us/subscriptions/downloads/ If you have not yet done so create an account with them. Check the boxes that apply to you – 32/64 bit architecture, language etc. I chose the free version of SQL Server Express 2014 with Advanced Services. Advanced Series is what you will need if you wish to install full text searches. The ordinary installers not appear to include this. Once downloaded, run the installer. Just click OK when prompted to choose the destination folder: And let it run Then choose to run a new installation of SQL Server 2014: And continue through the inst...