-
How can you disable a linked server in SQL Server
Read More
-
Step by step Sql Server 2008 R2 installation
Read More
-
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
Read More
-
How to set SQL Server database read only or read write mode
Read More
-
How can you disable a linked server in SQL Server
Read More
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
