General MySQL Oracle SQL Server

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

What Is an Expression in SQL Server
What Is an Expression in SQL Server Transact-SQL? An expression is a combination of identifiers, values, and operators that SQL Server 2005 can evaluate to obtain a numeric value. A simple expression could be a constant, a function, a column name, a variable, or a subquery without any operators. Com... 2017-04-01, 2871🔥, 0💬

Rebuilding All Indexes on One Table in SQL Server
How To Rebuild All Indexes on a Single Table in SQL Server? If you have several indexes on a single table and want to rebuild all of them, you may use the "ALTER INDEX ALL ON table_name REBUILD" statement as shown in the tutorial exercise below: USE FyiCenterData; GO UPDATE fyi_links_indexed SET url... 2016-11-08, 2871🔥, 0💬

Categories of Functions Based on Return Modes in SQL Server
How Many Categories of Functions based Their Return Modes in SQL Server Transact-SQL? SQL Server supports 2 categories of user defined functions based on their return modes: 1. Scalar-valued Functions - A function that returns a single value. Scalar-valued functions can be used in scalar expressions... 2016-12-18, 2868🔥, 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, 2865🔥, 0💬

Updating Values with UPDATE Statements in SQL Server
How To Update Values in a Table with UPDATE Statements in SQL Server? If you want to update some values in one row or multiple rows in a table, you can use the UPDATE statement. The tutorial script below shows a good example: SELECT * FROM fyi_links WHERE id = 101 GO id url notes counts created 101 ... 2016-11-02, 2864🔥, 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, 2863🔥, 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, 2862🔥, 0💬

Security Principals Used in SQL Server 2005 in SQL Server
What Are Security Principals Used in SQL Server 2005 in SQL Server? SQL Server 2005 supports several basic security principals located at different levels: Windows-Level Principals: Windows Local Login and Windows Network Domain Login - Used to control accesses to SQL Server instances. SQL Server-Le... 2016-10-20, 2862🔥, 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, 2856🔥, 0💬

Finding ntwdblib.dll Version 2000.80.194.0
Where to Find ntwdblib.dll Version 2000.80.194.0? You know that the copy of ntwdblib.dll version 2000.2.8.0 included in Windows binary version of PHP 5.2.3 does not work with MS SQL Server 2005. You need to get a new version of ntwdblib.dll. One way to get a free copy of ntwdblib.dll is to download ... 2024-04-14, 2849🔥, 0💬

mssql_connect() - Connecting to Different Port Numbers
How To Connect with Different Port Numbers? You know that SQL Server could be configured to accept connections with different TCP/IP port numbers. See other tutorial collections on how to view and configure SQL Server TCP/IP protocol. If you installed SQL Server 2005 Express Edition with default set... 2024-04-14, 2847🔥, 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, 2846🔥, 0💬

Creating an Index on a View in SQL Server
How To Create an Index on a View in SQL Server? If you need to search and sort data in a view with a large number of row, you may want to create an index on the view to speed up your search process. The tutorial exercise below shows you how to create a unique clustered index on a view. DROP VIEW fyi... 2016-11-03, 2845🔥, 0💬

odbc_fetch_row() - Looping through Result Set Objects
How To Loop through Result Set Objects using odbc_fetch_row()? If the returning output of a query statement is captured in a result set object, you can use odbc_fetch_row() to loop through each row in the output. The tutorial PHP script below shows you how to list tables in the database: &lt;?ph... 2024-06-30, 2839🔥, 0💬

Requirements for Connecting PHP to MS SQL Server
What Do You Need to Connect PHP to SQL Server? If you want to access MS SQL Server in your PHP script, you need to make sure that: 1. MSSQL API module (extension) is installed and turned on in your PHP engine. If you installed the Windows binary version of PHP 5.2.3, MSSQL API module is included but... 2024-04-29, 2839🔥, 0💬

Requirements to Use ODBC Connections in PHP
What Are the Requirements to Use ODBC Connections in PHP Scripts? If you are planning to use ODBC connections to access SQL Server databases in PHP scripts, you need to check the following requirements: The PHP engine must support ODBC functions. If you install PHP 5.2.2 from The PHP Group, the ODBC... 2024-03-17, 2837🔥, 0💬

PHP ODBC - Deleting Existing Rows in a Table
PHP ODBC - How To Delete Existing Rows in a Table? If you want to remove a row from a table, you can use the DELETE statement with a WHERE clause to identify the row. The following sample script deletes one row: &lt;?php $con = odbc_connect('FYI_SQL_SERVER', 'sa','FYIcenter');$sql = "DELETE FROM... 2024-05-05, 2834🔥, 0💬

"DROP TABLE" - Deleting Existing Tables in SQL Server
How To Drop an Existing Table with "DROP TABLE" Statements in SQL Server? If you want to delete an existing table and its data rows, you can use the "DROP TABLE" statement as shown in the tutorial script below: SELECT * FROM tipBackup GO id subject description create_date 1 Learn SQL Visit dev.fyice... 2016-11-15, 2826🔥, 0💬

DROP INDEX - Removing Existing Indexes in SQL Server
How To Drop Existing Indexes in SQL Server? For some reason, if you want remove an existing index, you can use the DROP INDEX statement with following syntax: CREATE INDEX table_name.index_name The tutorial exercise below shows you how to remove the index "fyi_links_id": USE FyiCenterData; GO SELECT... 2016-11-15, 2824🔥, 0💬

PHP ODBC - Updating Existing Rows in a Table
PHP ODBC - How To Update Existing Rows in a Table? Updating existing rows in a table requires to run the UPDATE statement with a WHERE clause to identify the row. The following sample script updates one row with two new values: &lt;?php $con = odbc_connect('FYI_SQL_SERVER', 'sa','FYIcenter');$sq... 2024-05-29, 2821🔥, 0💬

IN - Testing Value in a Value List in SQL Server
What To Test Value Lists with the IN Operator in SQL Server Transact-SQL? Sometimes you want to test a given value against a list of values. You can do this in a loop with the regular "equal" operator. But you can also use the special comparison operator IN to get it done with the following syntaxes... 2017-01-21, 2821🔥, 0💬

Deleting Data from a View in SQL Server
Can You Delete Data from a View in SQL Server? Can you delete data in a view? The answer is no. But if the question is "Can you delete data from the underlying table through view?" The answer is then yes. SQL Server will allow you to delete data from the underlying table through a view. The tutorial... 2016-11-03, 2818🔥, 0💬

Group Functions in Query Statements in SQL Server
What Are Group Functions in Query Statements in SQL Server? Group functions are functions applied to a group of rows. Examples of group functions are: COUNT(*) - Returns the number of rows in the group. MIN(exp) - Returns the minimum value of the expression evaluated on each row of the group. MAX(ex... 2016-10-25, 2818🔥, 0💬

Using Values from Other Tables in UPDATE Statements in SQL Server
How To Use Values from Other Tables in UPDATE Statements in SQL Server? If you want to update values in one table with values from another table, you can use a subquery as an expression in the SET clause. The subquery should return only one row for each row in the update table that matches the WHERE... 2016-11-02, 2817🔥, 0💬

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

General MySQL Oracle SQL Server