All posts in category 'SQL Server Tutorials'

  • How can you disable a linked server in SQL Server

    How can you disable a linked server in SQL Server
    Read More
  • Step by step Sql Server 2008 R2 installation

    Step by step Sql Server 2008 R2 installation
    Read More
  • How to shrink transaction log file for a SQL Server database?

    How to shrink transaction log file for a SQL Server database?
    Read More
  • How to set a SQL Server database in read only or read write mode

    How to set a SQL Server database in read only or read write mode
    Read More
  • How to set SQL Server database read only or read write mode

    How to set SQL Server database read only or read write mode
    Read More
  • How can you disable a linked server in SQL Server

    How can you disable a linked server in SQL Server
    Read More
  • Sql Server Year Function

    In this post explains how to use the YEAR function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the YEAR function returns a four-digit year (as a number) given a date value.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server While Loop

    In this post explains how to use the WHILE LOOP in SQL Server (Transact-SQL) with syntax and examples. In SQL Server, you use a WHILE LOOP when you are not sure how many times you will execute the loop body and the loop body may not execute even once.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Where Clause

    In this post explains how to use the WHERE clause in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact-SQL) WHERE clause is used to filter the results from a SELECT, INSERT, UPDATE, or DELETE statement.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server View

    Learn how to create, update, and drop VIEWS in SQL Server (Transact-SQL) with syntax and examples. A VIEW, in essence, is a virtual table that does not physically exist in SQL Server. Rather, it is created by a query joining one or more tables.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Upper Function

    In this post explains how to use the UPPER function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the UPPER function converts all letters in the specified string to uppercase.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Update Statement

    In this post explains how to use the UPDATE statement in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact-SQL) UPDATE statement is used to update existing records in a table in a SQL Server database.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Unique Constraints

    In this post explains how to create, add, and drop unique constraints in SQL Server with syntax and examples. A unique constraint is a single field or combination of fields that uniquely defines a record.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Union Operator

    In this post explains how to use the UNION operator in SQL Server (Transact-SQL) with syntax and examples. The SQL Server UNION operator is used to combine the result sets of 2 or more SELECT statements (does remove duplicate rows).site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Union All Operator

    In this post explains how to use the UNION ALL operator in SQL Server (Transact-SQL) with syntax and examples. The SQL Server UNION ALL operator is used to combine the result sets of 2 or more SELECT statements (does not remove duplicate rows).site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Try_convert Function

    In this post explains how to use the TRY_CONVERT function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the TRY_CONVERT function tries to convert an expression from one datatype to another datatype. If the conversion fails, the function will return NULL.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Try_cast Function

    In this post explains how to use the TRY_CAST function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the TRY_CAST function tries to convert an expression from one datatype to another datatype. If the conversion fails, the function will return NULL.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Truncate Table Statement

    In this post explains how to use the TRUNCATE TABLE statement in SQL Server (Transact-SQL) with syntax and examples. The TRUNCATE TABLE statement is used to remove all records from a table in SQL Server.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server System_user Function

    In this post explains how to use the SYSTEM_USER function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the SYSTEM_USER function returns the login name information for the current user in the SQL Server database.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Sum Function

    In this post explains how to use the SUM function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the SUM function returns the summed value of an expression.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Substring Function

    In this post explains how to use the SUBSTRING function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the SUBSTRING functions allows you to extract a substring from a string.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Subqueries

    In this post explains how to use subqueries in SQL Server (Transact-SQL) with syntax and examples. A subquery is a query within a query. In SQL Server (Transact-SQL), you can create subqueries within your SQL statements.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Stuff Function

    In this post explains how to use the STUFF function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the STUFF function deletes a sequence of characters from a source string and then inserts another sequence of characters.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Str Function

    In this post explains how to use the STR function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the STR function returns a string representation of a number.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Space Function

    In this post explains how to use the SPACE function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the SPACE function returns a string with a specified number of spaces.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Sign Function

    In this post explains how to use the SIGN function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the SIGN function returns a value indicating the sign of a number.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Sessionproperty Function

    In this post explains how to use the SESSIONPROPERTY function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the SESSIONPROPERTY function returns the setting for a specified option of a session.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Session_user Function

    In this post explains how to use the SESSION_USER function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the SESSION_USER function returns the user name of the current session in the SQL Server database.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Sequences (autonumber)

    Learn how to create and drop sequences in SQL Server (Transact-SQL) with syntax and examples. In SQL Server, you can create an autonumber field by using sequences.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Select Top Statement

    In this post explains how to use the SELECT TOP statement in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact-SQL) SELECT TOP statement is used to retrieve records from one or more tables in SQL Server and limit the number of records.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Select Statement

    In this post explains how to use the SELECT statement in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact-SQL) SELECT statement is used to retrieve records from one or more tables in a SQL Server database.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Select Into Statement

    In this post explains how to use the SELECT INTO statement in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact-SQL) SELECT INTO statement is used to create a table from an existing table by copying the existing table's columns.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Rtrim Function

    In this post explains how to use the RTRIM function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the RTRIM function removes all space characters from the right-hand side of a string.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Round Function

    In this post explains how to use the ROUND function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the ROUND function returns a number rounded to a certain number of decimal places.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Right Function

    In this post explains how to use the RIGHT function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the RIGHT function allows you to extract a substring from a string, starting from the right-most character.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Replace Function

    In this post explains how to use the REPLACE function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the REPLACE function replaces a sequence of characters in a string with another set of characters, not case-sensitive.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Rand Function

    In this post explains how to use the RAND function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the RAND function can be used to return a random number or a random number within a range.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Procedures

    Learn how to create and drop procedures in SQL Server (Transact-SQL) with syntax and examples. In SQL Server, a procedure is a stored program that you can pass parameters into. It does not return a value like a function does.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Primary Keys

    Learn how to create, change, drop, disable, and enable a primary key in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), a primary key is a single field or combination of fields that uniquely defines a record.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Pivot Clause

    In this post explains how to use the PIVOT clause in SQL Server (Transact-SQL) with syntax and examples.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Patindex Function

    In this post explains how to use the PATINDEX function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the PATINDEX functions returns the location of a pattern in a string. The search is not case-sensitive.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Order By Clause

    In this post explains how to use the ORDER BY clause in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact-SQL) ORDER BY clause is used to sort the records in your result set. The ORDER BY clause can only be used in SELECT statements.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Or Condition

    In this post explains how to use the OR condition in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact-SQL) OR condition is used to test multiple conditions where records are returned when any one of the conditions are met.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Nullif Function

    In this post explains how to use the NULLIF function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the NULLIF function compares expression1 and expression2.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Not Condition

    In this post explains how to use the NOT condition in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact-SQL) NOT condition, also called the NOT Operator, is used to negate a condition in a SELECT, INSERT, UPDATE, or DELETE statement.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Nchar Function

    In this post explains how to use the NCHAR function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the NCHAR function returns the Unicode character based on the number_code in the Unicode standard.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Month Function

    In this post explains how to use the MONTH function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the MONTH function returns the month (a number from 1 to 12) given a date value.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Min Function

    In this post explains how to use the MIN function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the MIN function returns the minimum value of an expression.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Max Function

    In this post explains how to use the MAX function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the MAX function returns the maximum value of an expression.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Ltrim Function

    In this post explains how to use the LTRIM function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the LTRIM function removes all space characters from the left-hand side of a string.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Lower Function

    In this post explains how to use the LOWER function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the LOWER function converts all letters in the specified string to lowercase.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Local Temporary Tables

    In this post explains how to use the LOCAL TEMPORARY TABLES in SQL Server (Transact-SQL) with syntax and examples. LOCAL TEMPORARY TABLES are distinct within modules and embedded SQL programs within SQL Server sessions.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Literals

    In this post explains how to use literals (strings, integers, decimals, and datetime values) in SQL Server with examples. In SQL Server, a literal is the same as a constant.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Like Condition

    In this post explains how to use the LIKE condition in SQL Server (Transact-SQL) to perform pattern matching with syntax and examples. The SQL Server (Transact-SQL) LIKE condition allows wildcards to be used.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Len Function

    In this post explains how to use the LEN function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the LEN function returns the length of the specified string.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Left Function

    In this post explains how to use the LEFT function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the LEFT function allows you to extract a substring from a string, starting from the left-most character.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Lead Function

    In this post explains how to use the SQL Server (Transact-SQL) LEAD function with syntax and examples. The SQL Server (Transact-SQL) LEAD function is an analytic function.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Lag Function

    This Oracle tutorial explains how to use the SQL Server (Transact-SQL) LAG function with syntax and examples. It is an analytic function that lets you query more than one row in a table at a time without having to join the table to itself.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Joins

    In this post explains how to use JOINS, both INNER and OUTER JOINS, in SQL Server (Transact-SQL) with syntax, visual illustrations, and examples. SQL Server (Transact-SQL) JOINS are used to retrieve data from multiple tables.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Isnumeric Function

    In this post explains how to use the ISNUMERIC function in SQL Server (Transact-SQL) with syntax and examples. In The SQL Server (Transact-SQL), the ISNUMERIC function returns 1 if the expression is a valid number. Otherwise, it returns 0.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Isnull Function

    In this post explains how to use the ISNULL function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the ISNULL function lets you return an alternative value when an expression is NULL.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Isdate Function

    In this post explains how to use the ISDATE function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the ISDATE function returns 1 if the expression is a valid date. Otherwise, it returns 0.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Is Null Condition

    In this post explains how to use the IS NULL condition in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact-SQL) IS NULL condition is used to test for a NULL value.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Is Not Null Condition

    In this post explains how to use the IS NOT NULL condition in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact-SQL) IS NOT NULL condition is used to test for a NOT NULL value.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Intersect Operator

    In this post explains how to use the INTERSECT operator in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact-SQL) INTERSECT operator is used to return the records that are in common between two SELECT statements.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Insert Statement

    In this post explains how to use the INSERT statement in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact-SQL) INSERT statement is used to insert a single record or multiple records into a table in SQL Server.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Indexes

    Learn how to create, rename and drop indexes in SQL Server with syntax and examples. An index is a performance-tuning method of allowing faster retrieval of records.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server In Condition

    In this post explains how to use the IN condition in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact-SQL) IN condition is used to help reduce the need to use multiple OR Conditions in a SELECT, INSERT, UPDATE, or DELETE statement.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server If...else Statement

    In this post explains how to use the IF...ELSE statement in SQL Server (Transact-SQL) with syntax and examples. In SQL Server, the IF...ELSE statement is used to execute code when a condition is TRUE, or execute different code if the condition evaluates to FALSE.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Having Clause

    In this post explains how to use the HAVING clause in SQL Server (Transact-SQL) with syntax and examples. The HAVING Clause is used in combination with the GROUP BY Clause to restrict the groups of returned rows to only those whose the condition is TRUE.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Group By Clause

    In this post explains how to use the GROUP BY clause in SQL Server (Transact-SQL) with syntax and examples. The GROUP BY clause is used in a SELECT statement to collect data across multiple records and group the results by one or more columns.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Grant Revoke Privileges

    Learn how to grant and revoke privileges in SQL Server (Transact-SQL) with syntax and examples. You can GRANT and REVOKE privileges on various database objects in SQL Server. We'll look at how to grant and revoke privileges on tables in SQL Server.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Goto Statement

    In this post explains how to use the GOTO statement in SQL Server (Transact-SQL) with syntax and examples. The GOTO statement causes the code to branch to the label after the GOTO statement.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Global Temporary Tables

    In this post explains how to use the GLOBAL TEMPORARY TABLES in SQL Server (Transact-SQL) with syntax and examples. Global Temporary Tables in SQL Server are tables that are created distinct within the SQL Server sessions.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Getutcdate Function

    In this post explains how to use the GETUTCDATE function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the GETUTCDATE function returns the current UTC date and time.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Getdate Function

    In this post explains how to use the GETDATE function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the GETDATE function returns the current date and time.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Functions

    Learn how to create and drop functions in SQL Server (Transact-SQL) with syntax and examples. In SQL Server, a function is a stored program that you can pass parameters into and return a value.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server From Clause

    In this post explains how to use the FROM clause in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact-SQL) FROM clause is used to list the tables and any joins required for the query in SQL Server.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Foreign Keys

    In this post explains how to use Foreign Keys in SQL Server with syntax and examples. A foreign key is a way to enforce referential integrity within your SQL Server database. A foreign key means that values in one table must also appear in another table.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Foreign Keys With Set Null On Delete

    In this post explains how to use Foreign Keys with set null on delete in SQL Server with syntax and examples. If a record in the parent table is deleted, then the corresponding records in the child table will have the foreign key fields set to NULL.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Foreign Keys With Cascade Delete

    In this post explains how to use Foreign Keys with cascade delete in SQL Server with syntax and examples. If a record in the parent table is deleted, then the corresponding records in the child table will automatically be deleted.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server For Loop

    Learn how to simulate the FOR LOOP in SQL Server (Transact-SQL) with syntax and examples. In SQL Server, there is no FOR LOOP. However, you simulate the FOR LOOP using the WHILE LOOP.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Floor Function

    In this post explains how to use the FLOOR function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the FLOOR function returns the largest integer value that is equal to or less than a number.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Find Users In Sql Server

    Is there a query to run in SQL Server that will return all Users created? In SQL Server, there is a system view called sys.sysusers. You can run a query against this system view.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Find Logins In Sql Server

    Is there a query to run in SQL Server that will return all SQL Server Logins and information about those Logins? In SQL Server, there is a catalog view (ie: system view) called sys.sql_logins.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Exists Condition

    In this post explains how to use the EXISTS condition in SQL Server (Transact-SQL) with syntax and examples. It is used in combination with a subquery and is considered to be met if the subquery returns at least one row.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Except Operator

    In this post explains how to use the EXCEPT operator in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact-SQL) EXCEPT operator is used to return all rows in the first SELECT statement that are not returned by the second.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Enable A Foreign Key

    Learn how to enable a foreign key in SQL Server with syntax and examples. You may encounter a foreign key in SQL Server (Transact-SQL) that has been disabled. You can enable the foreign key using the ALTER TABLE statement.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Drop User Statement

    In this post explains how to use the SQL Server DROP USER statement with syntax and examples. The DROP USER statement is used to remove a user from the SQL Server database.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Drop Table Statement

    In this post explains how to use the DROP TABLE statement in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact-SQL) DROP TABLE statement allows you to remove or delete a table from the SQL Server database.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Drop Login Statement

    In this post explains how to use the SQL Server DROP LOGIN statement with syntax and examples. The DROP LOGIN statement is used to remove an identity (ie: Login) used to connect to a SQL Server instance.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Drop A Foreign Key

    Learn how to drop a foreign key in SQL Server with syntax and examples. Once a foreign key has been created, you may find that you wish to drop the foreign key from the table.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Distinct Clause

    In this post explains how to use the DISTINCT clause in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact-SQL) DISTINCT clause is used to remove duplicates from the result set.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Disable A Foreign Key

    Learn how to disable a foreign key in SQL Server with syntax and examples. Once you have created a foreign key in SQL Server, you may encounter a situation where you are required to disable the foreign key.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Delete Top Statement

    In this post explains how to use the DELETE TOP statement in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact-SQL) DELETE TOP statement is used to records from a table in SQL Server and limit the number of records deleted.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Delete Statement

    In this post explains how to use the DELETE statement in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact-SQL) DELETE statement is used to delete a single record or multiple records from a table in SQL Server.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Declare Variables

    Learn how to declare variables in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), a variable allows a programmer to store data temporarily during the execution of code.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Day Function

    In this post explains how to use the DAY function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the DAY function returns the day of the month (a number from 1 to 31) given a date value.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Datepart Function

    In this post explains how to use the DATEPART function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the DATEPART function returns a specified part of a given date, as an integer value.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Datename Function

    In this post explains how to use the DATENAME function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the DATENAME function returns a specified part of a given date, as a string value.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Datediff Function

    In this post explains how to use the DATEDIFF function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the DATEDIFF function returns the difference between two date values, based on the interval specified.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Dateadd Function

    In this post explains how to use the DATEADD function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the DATEADD function returns a date after which a certain time/date interval has been added.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Datalength Function

    In this post explains how to use the DATALENGTH function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the DATALENGTH function returns the length of an expression, in bytes.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Data Types

    The following is a list of datatypes available in SQL Server (Transact-SQL), which includes string, numeric, and date/time datatypes.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Current_user Function

    In this post explains how to use the CURRENT_USER function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the CURRENT_USER function returns the name of the current user in the SQL Server database.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Current_timestamp Function

    In this post explains how to use the CURRENT_TIMESTAMP function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the CURRENT_TIMESTAMP function returns the current date and time.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Create User Statement

    In this post explains how to use the SQL Server CREATE USER statement with syntax and examples. The CREATE USER statement creates a database user to log into SQL Server.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Create Table Statement

    In this post explains how to use the CREATE TABLE statement in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact-SQL) CREATE TABLE statement allows you to create and define a table.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Create Login Statement

    In this post explains how to use the SQL Server CREATE LOGIN statement with syntax and examples. The CREATE LOGIN statement creates an identity used to connect to a SQL Server instance.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Count Function

    In this post explains how to use the COUNT function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the COUNT function returns the count of an expression.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Convert Function

    In this post explains how to use the CONVERT function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the CONVERT function converts an expression from one datatype to another datatype.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Continue Statement

    In this post explains how to use the CONTINUE statement in SQL Server (Transact-SQL) with syntax and examples. In SQL Server, the CONTINUE statement is used when you are want a WHILE LOOP to execute again.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Concat Function

    In this post explains how to use the CONCAT function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the CONCAT function allows you to concatenate strings together.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Comparison Operators

    In this post explores all of the comparison operators used to test for equality and inequality, as well as the more advanced operators in SQL Server (Transact-SQL).site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Comments Within Sql

    In this post explains how to use comments within your SQL statements in SQL Server (Transact-SQL) with syntax and examples. Did you know that you can place comments within your SQL statements in SQL Server (Transact-SQL)?site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Combining The And And Or Conditions

    In this post explains how to use the AND condition and the OR condition together in a SQL Server (Transact-SQL) query with syntax and examples. The AND condition and OR condition can be combined in a SELECT, INSERT, UPDATE, or DELETE statement.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Coalesce Function

    In this post explains how to use the COALESCE function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the COALESCE function returns the first non-null expression in the list.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Check Constraints

    In this post explains how to use the check constraints in SQL Server (Transact-SQL) with syntax and examples. A check constraint in SQL Server (Transact-SQL) allows you to specify a condition on each row in a table.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Charindex Function

    In this post explains how to use the CHARINDEX function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the CHARINDEX functions returns the location of a substring in a string. The search is NOT case-sensitive.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Char Function

    In this post explains how to use the CHAR function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the CHAR function is the opposite of the ASCII function. It returns the character based on the NUMBER code.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Change A Password In Sql Server

    How do I change the password for a user/login in SQL Server? In SQL Server, the password is associated with the SQL Server Login. The Login is then mapped to the database user. So to change a password in SQL Server, you need to execute the ALTER LOGIN statement.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Ceiling Function

    In this post explains how to use the CEILING function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the CEILING function returns the smallest integer value that is greater than or equal to a number.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Cast Function

    In this post explains how to use the CAST function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the CAST function converts an expression from one datatype to another datatype.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Case Statement

    In this post explains how to use the SQL Server (Transact-SQL) CASE statement with syntax and examples. In SQL Server (Transact-SQL), the CASE statement has the functionality of an IF-THEN-ELSE statement. You can use the CASE statement within a SQL statement.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Break Statement

    In this post explains how to use the BREAK statement in SQL Server (Transact-SQL) with syntax and examples. In SQL Server, the BREAK statement is used when you want to exit from a WHILE LOOP and execute the next statements after the loop's END statement.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Between Condition

    In this post explains how to use the BETWEEN condition in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact-SQL) BETWEEN condition is used to retrieve values within a range in a SELECT, INSERT, UPDATE, or DELETE statement.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Avg Function

    In this post explains how to use the AVG function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the AVG function returns the average value of an expression.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Ascii Function

    In this post explains how to use the ASCII function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the ASCII function returns the NUMBER code that represents the specified character. It is the opposite of the CHAR function.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server And Condition

    In this post explains how to use the AND condition in SQL Server (Transact-SQL) with syntax and examples. The SQL Server (Transact-SQL) AND condition (also called the AND Operator) is used to test for two or more conditions.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Alter Table Statement

    In this post explains how to use the ALTER TABLE statement in SQL Server (Transact-SQL) to add a column, modify a column, drop a column, rename a column or rename a table with syntax and examples.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Alter Login Statement

    In this post explains how to use the SQL Server ALTER LOGIN statement with syntax and examples. The ALTER LOGIN statement modifies an identity used to connect to a SQL Server instance.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Aliases

    In this post explains how to use ALIASES in SQL Server (Transact-SQL) with syntax and examples. SQL Server (Transact-SQL) ALIASES can be used to create a temporary name for columns or tables.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server Abs Function

    In this post explains how to use the ABS function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the ABS function returns the absolute value of a number.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server @@version Function

    In this post explains how to use the VERSION function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the VERSION function returns the version of the SQL Server database, including the system and build information.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More
  • Sql Server + Operator

    In this post explains how to use the concatenate operator (+ operator) in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the + operator allows you to concatenate 2 or more strings together.site: google sitemap xml, Open Graph and plain old meta-tags.
    Read More

Search

Loading... Please wait

Subscribe to our Newsletter

Be a sport and

Browse by Categories(Posts)

x