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

SQL Server Connection Concepts
Where to find answers to frequently asked questions on SQL Server Connection Concepts? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL Server Connectivity Concepts. SQL Server Connection Protocols SQL Server TCP/IP Connection Info   ⇒ SQL Serv...
2024-08-14, 2693🔥, 0💬

"DROP DATABASE" - Deleting Databases in SQL Server
How to delete a database in SQL Server? If you created a database incorrectly, or you have a database that is not needed any more, you can delete it with the "DROP DATABASE" statement with this syntax: DROP DATABASE database_name For example, execute this statement: DROP DATABASE FyiCenterData GO Th...
2016-11-24, 2692🔥, 0💬

MS SQL Server DBA Checklist - General DBA Best Practices
-- Join (or start) a local SQL Server users group -- Attend at least one professional conference each year. -- Attend at least one training session each year. -- Read at least four books on SQL Server each year. -- Read the free e-book, How to Become an Exceptional DBA -- Learn everything you can ab...
2022-01-24, 2691🔥, 0💬

PHP MSSQL - mssql_rows_affected() - Number of Affected Rows
PHP MSSQL - How To Get the Number of Affected Rows? If you insert multiple rows with a single INSERT statement, you can use the mssql_rows_affected() function to find out how many rows were inserted. mssql_rows_affected($connectio n)returns the number of affected rows of the last INSET, UPDATE or DE...
2024-02-28, 2690🔥, 0💬

Getting Month and Weekday Names from DATATIME Values in SQL Server
How To Get Month and Weekday Names from DATETIME Values in SQL Server Transact-SQL? In DATETIME values, the month part and weekday part have names. You can use the DATENAME() function to get the month name and weekday name from a DATETIME value in the following format: DATENAME(datepart, date) retur...
2017-02-14, 2688🔥, 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, 2688🔥, 0💬

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, 2686🔥, 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, 2685🔥, 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, 2682🔥, 0💬

"SELECT" Statements - Reading the Data In a Table in SQL Server
How to read data in a table with "SELECT" statements in SQL Server? This is the fourth tutorial of a quick lesson on creating database objects with Transact-SQL statements. This lesson shows you how to create a database, create a table in the database, and then access and change the data in the tabl...
2016-12-02, 2681🔥, 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, 2681🔥, 0💬

Using Subqueries with the EXISTS Operators in SQL Server
How To Use Subqueries with the EXISTS Operators in SQL Server? A subquery can be used with the EXISTS operator as "EXISTS (subquery)", which returns true if the subquery returns one or more rows. The following statement is a good example of "EXISTS (subquery)". It returns rows from fyi_links table t...
2016-10-29, 2678🔥, 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, 2671🔥, 0💬

What Are Views in SQL Server
What Are Views in SQL Server? A view is a database object that represents the data in one or more tables in the same structure as a separate table. Here are some basic rules about views: Tables store real data. Views do not store real data. Views must have underlying tables to provide data. Each vie...
2016-11-08, 2670🔥, 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, 2664🔥, 0💬

Creating a New Table in a Given Schema in SQL Server
How To Create a New Table in a Given Schema in SQL Server? When you create a new table, you can specify in which schema you want this table to be located by prefixing the table name with the schema name. In the tutorial example below, a new table "test" is created in schema "fyi": USE FyiCenterData;...
2016-10-22, 2661🔥, 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, 2659🔥, 0💬

Commonly Used ODBC Functions in PHP
What Are Commonly Used ODBC Functions in PHP? If you look at the PHP 5 manual, you will see a group of functions listed under the ODBC Functions (Unified) section. The commonly used ODBC functions are: odbc_connect � Establish an OBDC connection. odbc_data_source � Returns information about a curren...
2024-03-17, 2656🔥, 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, 2656🔥, 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, 2652🔥, 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, 2651🔥, 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, 2648🔥, 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, 2648🔥, 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, 2644🔥, 0💬

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