General MySQL Oracle SQL Server

<< < 1 2 3 4 5 6 7 8 9 … > >>   ∑:509  Sort:Date

"ALTER TABLE ... ALTER COLUMN" - Changing Column Data Type in SQL Server
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Sometimes, you may need to change the data type of an existing column. For example, you want increase the string length of a column. You can use the "ALTER TABLE ... ALTER COLUMN" statements in the followi... 2016-11-15, 3177🔥, 0💬

BEGIN ... END Statement Blocks in SQL Server Transact-SQL
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into a statement block with BEGIN and END key words in Transact-SQL using these syntaxes BEGIN statement_1 statement_2 ... END Statement blocks are mainly used with logical conditions and control-of-flow ... 2017-01-11, 3082🔥, 0💬

"ALTER LOGIN" - Disabling a Login Name in SQL Server
How To Disable a Login Name in SQL Server? If you want temporarily disable a login name, you can use the "ALTER LOGIN" statement with a DISABLE keyword. If you want to enable it later on, you can use the ENABLE keyword. The tutorial exercise below shows how to disable and enable login name "Dba_Logi... 2016-10-19, 2993🔥, 0💬

ISNULL() - Replacing NULL Values in Expressions in SQL Server
How To Replace NULL Values in Expressions using ISNULL() in SQL Server Transact-SQL? As you learned from previous tutorials, NULL values presented in expressions will cause the final results to be NULL. Sometimes, you want NULL values to be replaced with some default values, like 0, '', or 'NULL', s... 2017-02-03, 2953🔥, 0💬

sys.objects - Listing All User Defined Functions in SQL Server
How To List All User Defined Functions in the Current Database in SQL Server Transact-SQL? If you want to see a list of all user defined functions in your current database, you can use the system view, sys.objects as shown in this tutorial exercise: USE FyiCenterData; GO -- Number of Sundays in a gi... 2016-12-24, 2933🔥, 0💬

Using INSERT, UPDATE and DELETE Statements in SQL Server
Where to find answers to frequently asked questions on Using INSERT, UPDATE and DELETE Statements in SQL Server? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Using INSERT, UPDATE and DELETE Statements in SQL Server. Clear answers are provided w... 2016-11-03, 2881🔥, 0💬

Converting Binary Strings into NUMERIC or FLOAT in SQL Server
Can Binary Strings Be Converted into NUMERIC or FLOAT Data Types in SQL Server Transact-SQL? Can binary strings be converted into numeric or float data types? The answer is no. Binary strings can not be converted implicitly or explicitly into NUMERIC, DECIMAL, REAL, or FLOAT data types. The tutorial... 2017-02-28, 2872🔥, 0💬

DROP_EXISTING - Recreating an Existing Index in SQL Server
How To Recreate an Existing Index in SQL Server? If you want to change the definition of an existing index, you can use the "DROP INDEX" statement to drop the index first. Then use the "CREATE INDEX" statement to create it again with the new definition. But you can also combine those two statements ... 2016-11-08, 2863🔥, 0💬

Missing .NET Framework 2.0 for SQL Server 2005 Express Edition in SQL Server
Why I am getting "The Microsoft .Net Framework 2.0 in not installed" message in SQL Server? When you try to install SQL Server 2005 Express Edition, you may get a Microsoft SQL Server 2005 Setup error box with this message: "The Microsoft .Net Framework 2.0 in not installed. Please install before ru... 2016-12-08, 2854🔥, 0💬

Rolling Back the DDL Statement in a Trigger in SQL Server
Can You Roll Back the DDL Statement in a Trigger in SQL Server? Can you roll back the DDL statement in a trigger? The answer is yes. Since the DDL statement that fires the trigger and the statements defined inside the trigger are all executed as a single statement batch, you can add a ROLLBACK state... 2016-10-22, 2782🔥, 0💬

"CREATE PROCEDURE" - Creating Simple Stored Procedures in SQL Server
How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple stored procedure with no input and output parameters, you can use the "CREATE PROCEDURE" command with a statement batch in a simple format as shown in below: CREATE PROCEDURE procedure_name AS statemen... 2017-01-05, 2779🔥, 0💬

Using Binary Strings in Arithmetical Operations in SQL Server
Can Binary Strings Be Used in Arithmetical Operations in SQL Server Transact-SQL? Can binary strings be used in arithmetical operations? The answer is yes. But there are two simple rules you need to remember: If an arithmetical operation has one binary string operand and one integer data type operan... 2017-02-28, 2753🔥, 0💬

mscorsvw.exe - Process - Microsoft .NET Framework NGEN in SQL Server
What is mscorsvw.exe - Process - Microsoft .NET Framework NGEN in SQL Server? Process mscorsvw.exe is installed as a system service as part of the .NET Framework 2.0. You can disable it, if you are not using any applications that require .NET Framework 2.0. mscorsvw.exe process and program file info... 2016-12-08, 2732🔥, 0💬

CREATE TABLE - Creating New Tables in SQL Server
How to create new tables with "CREATE TABLE" statements in SQL Server? If you want to create a new table, you can use the "CREATE TABLE" statement. The following tutorial script shows you how to create a table called "tip": CREATE TABLE tip (id INTEGER PRIMARY KEY, subject VARCHAR(80) NOT NULL, desc... 2016-11-17, 2727🔥, 0💬

PRINT Statements in SQL Server Transact-SQL
How to print value on console in SQL Server Transact-SQL? How to use the PRINT statements? In Transact-SQL, you can use PRINT statements to print values on the console of the client tool, in the syntax of: PRINT &lt;value&gt; When a PRINT statement is executed, the system will: Print the val... 2017-04-01, 2719🔥, 0💬

Exact Numeric Literals in SQL Server Transact-SQL
What are exact numeric literals supported in SQL Server Transact-SQL? Exact numeric literals in Transact-SQL are numbers written in standard signed decimal formats. Exact numeric literals are used to provide values to exact numeric variables or table columns like INTEGER, DECIMAL(8,2), MONEY, etc. E... 2017-05-05, 2649🔥, 0💬

How To Count Duplicated Values in a Column? in SQL Server
How To Count Duplicated Values in a Column in SQL Server? If you have a column with duplicated values, and you want to know what are those duplicated values are and how many duplicates are there for each of those values, you can use the "GROUP BY ... HAVING" clause as shown in the following example.... 2016-10-25, 2649🔥, 0💬

What Are Indexes in SQL Server
What Are Indexes in SQL Server? An index is a secondary database object associated with a table to improve the retrieval performance of rows from that table. An index can be defined for a single column or multiple columns of a given table. If an index is defined on a single column of a table, the in... 2016-11-15, 2646🔥, 0💬

Converting Binary Strings into Unicode Character Strings in SQL Server
Can Binary Strings Be Converted into Unicode Character Strings in SQL Server Transact-SQL? Can binary strings be converted into Unicode character strings? The answer is yes. But you need to know how Unicode characters are represented in a binary format. Remember the following simple rules: An ASCII ... 2017-02-28, 2597🔥, 0💬

OFFLINE - Taking a database offline in SQL Server
How to set a database state to OFFLINE in SQL Server? If you want to move database physical files, you should take the database offline by using the "ALTER DATABASE" statement with the following syntax: ALTER DATABASE database_name SET OFFLINE The following tutorial example will bring "FyiCenterComD... 2016-11-20, 2576🔥, 0💬

Measuring Performance of INSERT Statements in SQL Server
How To Measure Performance of INSERT Statements in SQL Server? When indexes are defined for a table, each time a new row is inserted to the table, all the indexes must be updated. This extra update work could slow down the insert statement. To find out how much slower the INSERT statements will be o... 2016-11-13, 2570🔥, 0💬

CREATE VIEW - Creating a View on an Existing Table in SQL Server
How To Create a View on an Existing Table in SQL Server? If you want to a view on an existing table, you can use the CREATE VIEW statement in a simple syntax: CREATE VIEW view_name AS SELECT ... The tutorial exercise below shows you how to create a view to represent sub set of data stored in fyi_lin... 2016-11-05, 2566🔥, 0💬

Using User Defined Functions in SQL Server Transact-SQL
Where to find answers to frequently asked questions on Using User Defined Functions in SQL Server Transact-SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Using User Defined Functions in SQL Server Transact-SQL. Clear answers are provided wit... 2016-12-28, 2559🔥, 0💬

What Is Microsoft SQL Server in SQL Server
What is Microsoft SQL Server in SQL Server? Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It runs on Windows systems and uses Transact-SQL as the query language. Microsoft SQL Server release history: 1993 - SQL Server 4.21 for Windows NT 1995 - SQL S... 2016-12-08, 2520🔥, 0💬

<< < 1 2 3 4 5 6 7 8 9 … > >>   ∑:509  Sort:Date

General MySQL Oracle SQL Server