Microsoft SQL Server

»Tag:Microsoft SQL Server

How To Create, Check And Change Identity Column In Microsoft SQL Server

Microsoft SQL Server has built-in an identity column (fields) which used for generating key values.  It may refer as an AutoNumber field in Microsoft Access or a sequence in Oracle.  An identity property on a column will [...]

By | 2017-08-30T14:47:37+00:00 August 30th, 2017|Categories: Databases|Tags: |0 Comments

Error Has Occurred While Establishing A Connection To SQL Server 2005 / 2008 / 2012 / 2014 Which Does Not Allow Remote Connections

When connecting to an instance of Microsoft SQL Server 2005 or Microsoft SQL Server 2008, Microsoft SQL Server 2012 or Microsoft SQL Server 2014 database, including SQL Server Express, Standard, Web, Workgroup, Business Intelligence, Developer and Enterprise [...]

Create New Table by Selecting Data from Other Tables with CREATE TABLE AS

By using SQL data manipulation statement, a new, temporary, backup or regular table can be created and filled or inserted with data from another table or tables retrieved by SELECT statement. The SQL data manipulation language is [...]

By | 2016-12-09T08:41:38+00:00 December 9th, 2016|Categories: Databases|Tags: , , , , |8 Comments

Pin It on Pinterest