General MySQL Oracle SQL Server

<< < … 5 6 7 8 9 10 11 12 13 14 15 … > >>   ∑:509  Sort:Date

Determining Data Types of View Columns in SQL Server
How Column Data Types Are Determined in a View in SQL Server? When you define a view, its columns are defined through a list of expressions in the underlying SELECT statement. Their data types will be determined implicitly by the expressions. For example, if the column expression is a column name of... 2016-11-03, 3161🔥, 0💬

odbc_errormsg() - Retrieving ODBC Error Messages
How To Retrieve Error Messages using odbc_errormsg()? When you call odbc_exec() to execute a SQL statement, and the execution failed on the SQL Server, you can use odbc_error() and odbc_errormsg() to retrieve the error code and error messages. The tutorial script below shows you a good example: &... 2024-06-30, 3151🔥, 0💬

"DROP" Statements - Deleting database objects in SQL Server
How to delete database objects with "DROP" statements in SQL Server? To remove all database objects created by previous tutorials, you could just delete the database. However, in this tutorial, you will go through the steps to reverse every action you took doing the tutorial. Removing permissions an... 2016-11-27, 3141🔥, 0💬

Mixing Group Functions with Non-group Selection Fields in SQL Server
Can Group Functions Be Mixed with Non-group Selection Fields in SQL Server? If a group function is used in the SELECT clause, all other selection fields must be group level fields. Non-group fields can not be mixed with group fields in the SELECT clause. The script below gives you an example of inva... 2016-10-25, 3139🔥, 0💬

Truncating DATETIME Values to Dates without Time in SQL Server
How To Truncate DATETIME Values to Dates without Time in SQL Server Transact-SQL? Assuming that you have some date and time, DATETIME, values, and you want to work with dates only. You want to truncate them to dates without time, or with time of 00:00:00.000. Again, SQL Server offers no simple solut... 2017-02-08, 3134🔥, 0💬

Location of Database Files in SQL Server
Where is my database stored on the hard disk in SQL Server? If a database is created with simple CREATE DATABASE statement, the server will create two database files on the hard disk to store data and configuration information about that data bases: database_name.mdf - SQL Server Database Primary Da... 2016-11-24, 3134🔥, 0💬

Using ORDER BY to Define a View in SQL Server
Can You Use ORDER BY When Defining a View in SQL Server? Sometimes you want the data in a view to be sorted and try to use the ORDER BY clause in the SELECT statement to define the view. But SQL Server will not allow you to use ORDER BY to define a view without the TOP clause. The tutorial exercise ... 2016-11-04, 3134🔥, 0💬

What Is ODBC (Open Database Communication)?
What Is Open Database Communication (ODBC)? ODBC, Open Database Communication, a standard API (application program interface) developed by Microsoft for Windows applications to communicate with database management servers. If you want to access a database server through an ODBC driver from an applic... 2024-08-14, 3126🔥, 0💬

DEFAULT - Using Column Default Values in INSERT Statements in SQL Server
How To Use Column Default Values in INSERT Statements in SQL Server? If a column is defined with a default value in a table, you can use the key word DEFAULT in the INSERT statement to take the default value for that column. The following tutorial exercise gives a good example: INSERT INTO fyi_links... 2016-11-03, 3110🔥, 0💬

Using ORDER BY with UNION Operators in SQL Server
How To Use ORDER BY with UNION Operators in SQL Server? If you need to sort the output from two queries grouped together with a UNION operator, you need to apply the ORDER BY clause at the group level, not at the subquery level. Note that SQL Server and MySQL react differently to the ORDER BY clause... 2016-10-26, 3110🔥, 0💬

Adding and Removing Days on Date and Time Values in SQL Server
How To Add or Remove Days on Date and Time Values in SQL Server Transact-SQL? SQL Server 2005 only support two operators on data and time values: + (Add): Adding days to a date and time value. - (Subtract): Removing days from a date and time value. Note that to add or subtract days on a date and tim... 2017-02-22, 3109🔥, 0💬

Date/Time Data Type Comparison in SQL Server Transact-SQL
What are differences between date and time data types in SQL Server Transact-SQL? I want to compare of date and time data types? Here is a comparison table of all date and time data types supported in SQL Server Transact-SQL: Data type Storage size Precision Default Format / (bytes) Value range ----... 2017-02-25, 3102🔥, 0💬

Boolean Values and Logical Operations in SQL Server Transact-SQL
Where to find answers to frequently asked questions on Boolean Values and Logical Operations in SQL Server Transact-SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Boolean Values and Logical Operations in SQL Server Transact-SQL. Clear answer... 2017-01-29, 3097🔥, 0💬

Attaching AdventureWorksLT Physical Files to the Server in SQL Server
How to attach AdventureWorksLT physical files to the server in SQL Server? After installed the sample database AdventureWorksLT, you need to attach it to your SQL server to make it available by follow this tutorial: EXEC sp_attach_db @dbname=N'AdventureWorksLT', @filename1=N'C:\Program Files\Microso... 2016-12-02, 3091🔥, 0💬

Generating CREATE FUNCTION Scripts on Existing Functions in SQL Server
How To Generate CREATE FUNCTION Script on an Existing Function in SQL Server Transact-SQL? If you want to know how an existing user defined function was created, you can use SQL Server Management Studio to automatically generate a "CREATE FUNCTION" script The following tutorial shows you how to do t... 2016-12-18, 3090🔥, 0💬

Exact Numeric Data Types in SQL Server Transact-SQL
What are exact numeric data types supported in SQL Server Transact-SQL? Exact numeric data types are used to hold numeric values truncated to a specific precision and scale. There are 8 different exact numeric data types supported in SQL Server Transact-SQL: 1. BIGINT - Used to hold big integers wit... 2017-04-22, 3087🔥, 0💬

Downloading and Installing SQL Server 2005 Books Online in SQL Server
How to download and install SQL Server 2005 Books Online in SQL Server? 1. Go to the SQL Server 2005 Books Online download page . 2. Click the download button, the File Download box shows up. Save the download file to c:\temp. 3. Double click on the downloaded file: c:\temp\SqlServer2K5_BOL_Feb20 07.... 2016-12-04, 3087🔥, 0💬

Managing Tables and Columns in SQL Server
Where to find answers to frequently asked questions on Managing Tables and Columns in SQL Server? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Tables and Columns in SQL Server. Clear answers are provided with tutorial exercises on crea... 2016-11-20, 3084🔥, 0💬

"ALTER PROCEDURE" - Modifying Existing Stored Procedures in SQL Server
How To Modify an Existing Stored Procedure in SQL Server Transact-SQL? If you find a mistake in an existing stored procedure previously created, you can drop (delete) it and create it again correctly. But dropping a stored procedure may affect other database objects who are depending on this stored ... 2017-01-05, 3082🔥, 0💬

Numeric Expressions and Functions in SQL Server Transact-SQL
Where to find answers to frequently asked questions on Numeric Expressions and Functions in SQL Server Transact-SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Numeric Expressions and Functions in SQL Server Transact-SQL. Clear answers are pr... 2017-04-01, 3081🔥, 0💬

"CREATE FUNCTION" - Creating User Defined Functions in SQL Server
How To Create a Simple User Defined Function in SQL Server Transact-SQL? If you want to create a simple user defined function, you can use the "CREATE FUNCTION" command with a statement block in a simple format as shown in below: CREATE FUNCTION function_name() RETURNS data_type AS BEGIN statement_1... 2016-12-24, 3080🔥, 0💬

"INSERT" and "UPDATE" Statements - Inserting and Updating Data In Tables in SQL Server
How to insert and update data into a table with "INSERT" and "UPDATE" statements in SQL Server? This is the third 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 ... 2016-12-02, 3080🔥, 0💬

Using Wildcard Characters in LIKE Operations in SQL Server
How To Use Wildcard Characters in LIKE Operations in SQL Server Transact-SQL? Wildcard character '%' can be used in the pattern string for the LIKE operator to match any string of zero or more characters. The following example uses '%Sport% Store' to search all company names that has a partial word ... 2017-01-21, 3079🔥, 0💬

Selecting Some Specific Rows from a Table in SQL Server
How To Select Some Specific Rows from a Table in SQL Server? If you don't want select all rows from a table, you can specify a WHERE clause to tell the query to return only the rows that meets the condition defined in the WHERE clause. The WHERE clause condition is a normal Boolean expression. If an... 2016-10-26, 3074🔥, 0💬

<< < … 5 6 7 8 9 10 11 12 13 14 15 … > >>   ∑:509  Sort:Date

General MySQL Oracle SQL Server