General MySQL Oracle SQL Server

<< < … 11 12 13 14 15 16 17 18 19 20 21 … > >>   ∑:509  Sort:Date

Converting Numeric Data Types by Assignment Operations in SQL Server
How To Convert Numeric Expression Data Types by Assignment Operations in SQL Server Transact-SQL? An assignment operation is used to assign an expression to a variable, a column, or a parameter. If the data type of the expression does not match the data type of the receiving variable, column, or par... 2017-03-27, 2527🔥, 0💬

Turning Off PHP Warning Messages for ODBC Connection
How To Turn Off Warning Messages during PHP Execution? If don't want see warning messages generated from the PHP engine when executing PHP scripts, you can change the error_reporting setting in the php.ini configuration file. Open php.ini and change the following lines: ;error_reporting = E_ALL &... 2024-06-30, 2526🔥, 0💬

Using Subqueries in the FROM Clause in SQL Server
How To Use Subqueries in the FROM Clause in SQL Server? If you have a query returning many rows of data, and you want to perform another query on those rows, you can put the first query as a subquery in the FROM clause of the second query. A subquery used in this way become a temporary table, and yo... 2016-10-29, 2526🔥, 0💬

NULL Values Involved in Bitwise Operations in SQL Server
What Happens If NULL Values Are Involved in Bitwise Operations in SQL Server Transact-SQL? If NULL values are involved in bitwise operations, the result will be binary NULL values. The following tutorial script shows you some good examples: SELECT 1 | NULL; GO ----------- NULL SELECT 707 &amp; N... 2017-02-03, 2524🔥, 0💬

ntwdblib.dll - SQL Server Client Library DLL
What Is Wrong with SQL Server Client Library DLL, ntwdblib.dll? The second requirement to access SQL Server with PHP scripts is the SQL Server Client Library DLL, ntwdblib.dll. The good news is that the Windows binary version of PHP 5.2.3 has ntwdblib.dll included in the PHP home directory. But the ... 2024-04-14, 2523🔥, 0💬

SQL Server Connection Tutorials
Where to find SQL Server Connection tutorials? I am having trouble to connect to my SQL Server. Here is a collection of tutorials, tips and FAQs on how to connect your client tools and client application programs to SQL server. SQL Server Connection Concepts SQL Server Connection Protocols SQL Serve... 2023-12-30, 2523🔥, 0💬

Deleting All Rows with DELETE Statements in SQL Server
How To Delete All Rows with DELETE Statements in SQL Server? If you want to delete all rows from a table, you have two options: Use the DELETE statement with no WHERE clause. Use the TRUNCATE TABLE statement. Here is an example of deleting all rows with a DELETE statement: SELECT COUNT(*) FROM fyi_l... 2016-10-30, 2520🔥, 0💬

Deleting a Table That Is Used by a View in SQL Server
What Happens If You Delete a Table That Is Used by a View in SQL Server? Assuming that you have a table which is used by a view, and you try to delete that table. SQL Server will let you delete the table without any trouble. But that view will become invalid. The tutorial exercise below shows you wh... 2016-11-04, 2519🔥, 0💬

Sorting Query Output in Descending Order in SQL Server
How To Sort Query Output in Descending Order in SQL Server? If you want to sort a column in descending order, you can specify the DESC keyword in the ORDER BY clause. The following SELECT statement first sorts the "tag" in descending order, then sorts the "counts" in ascending order: SELECT tag, cou... 2016-10-26, 2518🔥, 0💬

CREATE INDEX - Adding an Index on an Existing Table in SQL Server
How To Create an Index on an Existing Table in SQL Server? If you want to an index on an existing table, you can use the CREATE INDEX statement in a simple syntax: CREATE INDEX index_name ON table_name (column_name) The tutorial exercise below shows you how to add an index for the "in" column of the... 2016-11-15, 2517🔥, 0💬

"DROP SCHEMA" - Dropping an Existing Schema in SQL Server
How To Drop an Existing Schema in SQL Server? If you want to delete a schema, you need to move all objects out of that schema, then use the "DROP SCHEMA" statement to delete the schema. The tutorial exercise below shows you how to drop schema "fyi": -- Login with "sa" USE FyiCenterData; GO -- Drop f... 2016-10-20, 2516🔥, 0💬

OUTPUT - Receiving Output Values from Stored Procedures in SQL Server
How To Receive Output Values from Stored Procedures in SQL Server Transact-SQL? If an output parameter is defined in a stored procedure, the execution statement must provide a variable to receive the output value in the format: "@variable_name OUTPUT" or "@parameter_name = @variable_name OUTPUT". Th... 2016-12-28, 2509🔥, 0💬

Subtracting a DATETIME Value from Another DATETIME Value in SQL Server
Can a DATETIME Value Be Subtracted from Another DATETIME Value in SQL Server Transact-SQL? Can a datetime value be subtracted from another datetime value? The answer is yes. The subtract operation can be performed by the subtract operator (-) as: datetime1 - datetime2: Returning a DATETIME value cal... 2017-02-20, 2507🔥, 0💬

"CREATE USER" - Creating a User Name in a Database in SQL Server
How To Create a User Name in a Database in SQL Server? User names are security principals at the database level. If you want to allow a login name to access a specific database, you need to create a user name in that database and link it to the login name. Creating a user name can be done by using t... 2016-10-19, 2506🔥, 0💬

Getting "Connection failed" Error on ODBC DSN Creation
Why Am I Getting Errors When Creating a New ODBC DSN? Continue from the previous tutorial. After clicking Next on the SQL login information screen, ODBC manager will try to connect to the SQL Server with the login information you provided. After a period of waiting time, you may get error message bo... 2024-08-06, 2504🔥, 0💬

Updating Data in a View in SQL Server
Can You Update Data in a View in SQL Server? Can you update data in a view? The answer is no. But if the question is "Can you update data in the underlying table through view?" The answer is then yes. SQL Server will allow you to update data in the underlying table through a view. The tutorial exerc... 2016-11-04, 2500🔥, 0💬

odbc_tables() - Listing All Tables in the Database
How To List All Tables in the Database using odbc_tables()? If you want to get a list of all tables in the database, you can use the odbc_tables() function, which can actually be used to list all tables and views in the database. The syntax of odbc_tables() is: $result_set = odbc_tables($connection_... 2024-07-11, 2499🔥, 0💬

Deleting Multiple Rows with One DELETE Statement in SQL Server
How To Delete Multiple Rows with One DELETE Statement in SQL Server? You can delete multiple rows from a table in the same way as deleting a single row, except that the WHERE clause will match multiple rows. The tutorial exercise below deletes 3 rows from the fyi_links table: -- view rows to be dele... 2016-10-30, 2498🔥, 0💬

EXISTS - Testing Subquery Results in SQL Server
How To Test Subquery Results with the EXISTS Operator in SQL Server Transact-SQL? EXISTS is a special operator used to test subquery results. EXISTS can be used in two ways: EXISTS (SELECT ...) -- Returns TRUE if the specified subquery has one or more rows returned. NOT EXISTS (SELECT ...) -- Return... 2017-01-21, 2492🔥, 0💬

"RETURNS TABLE" - Creating Inline Table-Value Functions in SQL Server
How To Create an Inline Table-Valued Function in SQL Server Transact-SQL? To create an inline table-valued function, you need to use the "RETURNS TABLE" clause in the "CREATE FUNCTION" statement. There should be no function body, except for a RETURN statement with a SELECT subquery: An inline table-... 2016-12-18, 2491🔥, 0💬

"FETCH" - Transferring Data from Cursors to Variables in SQL Server
How To Transfer Data from a Cursor to Variables with a "FETCH" Statement in SQL Server Transact-SQL? By default, a FETCH statement will display the fetched row on the client program window. If you want to transfer the output data to variables, you can specify an INTO clause with a list of variables ... 2016-10-17, 2491🔥, 0💬

Testing Local Temporary Stored Procedures in SQL Server
Can Another User Execute Your Local Temporary Stored Procedures in SQL Server Transact-SQL? Can another user execute your local temporary stored procedures? The answer is no. To test this out, continue with the exercise from the previous tutorial. Keep that user session running and open a new client... 2016-12-28, 2488🔥, 0💬

Counting Groups Returned with the GROUP BY Clause in SQL Server
How To Count Groups Returned with the GROUP BY Clause in SQL Server? If you use the COUNT(*) function on groups returned with the GROUP BY clause, it will count the number of rows within each group, not the number of groups. If you want to count the number of groups, you can put the GROUP BY query i... 2016-10-29, 2488🔥, 0💬

Sorting Query Output by Multiple Columns in SQL Server
Can the Query Output Be Sorted by Multiple Columns in SQL Server? You can specifying multiple columns in the ORDER BY clause as shown in the following example statement, which returns rows sorted by "tag" and "counts" values: SELECT tag, counts, url, created FROM fyi_links ORDER BY tag, counts GO ta... 2016-10-26, 2486🔥, 0💬

<< < … 11 12 13 14 15 16 17 18 19 20 21 … > >>   ∑:509  Sort:Date

General MySQL Oracle SQL Server