<< < 3 4 5 6 7 8 9 10 11 12 13 > >>   ∑:509  Sort:Date

"FETCH" - Fetching the Next Row from a Cursor in SQL Server
How To Fetch the Next Row from a Cursor with a "FETCH" Statement in SQL Server Transact-SQL? When the result set is ready in a cursor, you can use a FETCH statement to retrieve one row from the result set in the same format as a SELECT statement. The FETCH statement has the following formats: FETCH ...
2016-10-17, 3158🔥, 0💬

DML (Data Manipulation Language_Statements in SQL Server
What Are DML (Data Manipulation Language) Statements in SQL Server? DML (Data Manipulation Language) statements are statements to change data values in database tables. The are 3 primary DML statements: INSERT - Inserting new rows into database tables. For example "INSERT INTO fyi_links VALUES (101,...
2016-11-03, 3157🔥, 0💬

"ALTER INDEX ... REORGANIZE" - Defragmenting Indexes in SQL Server
How To Defragment Indexes with ALTER INDEX ... REORGANIZE in SQL Server? When an index is defragmented to a small percentage, like &lt; 30%, you can use the "ALTER INDEX ... REORGANIZE" statement to defragment the index. Here is a tutorial exercise on defragmenting indexes: USE FyiCenterData; GO...
2016-11-08, 3148🔥, 0💬

"@@FETCH_STATUS" - Looping through Result Set in SQL Server
How To Loop through the Result Set with @@FETCH_STATUS in SQL Server Transact-SQL? The FETCH statement only returns one row from the result set. If you want to return all rows, you need to put the FETCH statement in a loop. A simple way to stop the loop to check the system variable @@FETCH_STATUS, w...
2016-10-17, 3144🔥, 0💬

CONVERT/CAST Function in SQL Server Transact-SQL
How to convert value from one data type to another in SQL Server Transact-SQL? How to use the CONVERT function or the CAST function? In Transact-SQL, you can use CONVERT statements to convert values from one data type to another, in the syntax of: CONVERT(data_type, value[, style]) In this syntax, "...
2017-04-01, 3133🔥, 0💬

"DROP USER" - Deleting a Database User in SQL Server
How To Delete an Existing Database User in SQL Server? If you don't want to keep a database user any more, you should delete the user by using the "DROP USER" statement. This tutorial exercise shows how to delete "Dba_User": -- Login with "sa" USE FyiCenterData; GO DROP USER Dba_User; GO -- List all...
2022-01-24, 3126🔥, 0💬

Default Collation in SQL Server Transact-SQL
How To Find Out What Is the Default Collation in SQL Server Transact-SQL? The default collation of a database comes from the server if you are not using the COLLATE clause in the CREATE DATABASE statement. If you are not using the COLLATE clause for character string column, it will use the default c...
2017-05-13, 3116🔥, 0💬

Rules on Arithmetic Operations in SQL Server
What Are Arithmetic Operators in SQL Server Transact-SQL? An arithmetic operator performs an arithmetic operation on two expressions of numeric data types. SQL Server supports 5 arithmetic operators: + (Add): Addition - (Subtract): Subtraction * (Multiply): Multiplication / (Divide): Division % (Mod...
2017-04-01, 3110🔥, 0💬

"CREATE DATABASE" Statement - Creating New Databases in SQL Server
How to create new databases with "CREATE DATABASE" statements in SQL Server? This is the first 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 ...
2016-12-02, 3110🔥, 0💬

"INNER JOIN ... ON" - Writing Queries with Inner Joins in SQL Server
How To Write a Query with an Inner Join in SQL Server? If you want to query from two tables with an inner join, you can use the INNER JOIN ... ON clause in the FROM clause. The tutorial exercise below creates another testing table and returns output with an inner join from two tables: fyi_links and ...
2016-10-30, 3110🔥, 0💬

SQL Server Connection Protocols
What connection protocols are supported by SQL Server? SQL Server supports the following connection protocols: 1. TCP/IP (Transmission Control Protocol/Internet Protocol) - This is the most commonly used protocols to connect to SQL Server databases. It allow client tools or application programs on a...
2024-08-14, 3106🔥, 0💬

Converting DATETIME and NUMERIC Values in SQL Server
Are DATETIME and NUMERIC Values Convertible in SQL Server Transact-SQL? Are datetime and numeric value convertible? The answer is yes. Here are the main rules on DATATIME and NUMERIC value conversions: During the conversion a DATETIME value will be treated as a NUMERIC value with the number of days ...
2017-02-22, 3101🔥, 0💬

Using SELECT Statements on Views in SQL Server
Can SELECT Statements Be Used on Views in SQL Server? Select (query) statements can be used on views in the same way as tables. The following tutorial exercise helps you creating a view and running a query statement on the view: CREATE VIEW myLinks AS SELECT * FROM fyi_links WHERE url LIKE '%fyi%' G...
2016-10-26, 3086🔥, 0💬

Creating a Logon Trigger in Express Edition in SQL Server
Can You Create a Logon Trigger in SQL Server 2005 Express Edition in SQL Server? Can you create a logon trigger in SQL Server 2005 Express Edition? The answer is no. LOGON is not a supported event type in Express Edition. The script below shows you the error message when you try to create a logon tr...
2016-10-22, 3084🔥, 0💬

"sp_columns" - Getting a List of Columns in a Table in SQL Server
How To Get a List of Columns using the "sp_columns" Stored Procedure in SQL Server? If you have an existing table, but you don't remember what are the columns defined in the table, you can use the "sp_columns" stored procedure to get a list of all columns of the specified table. The following tutori...
2016-11-17, 3077🔥, 0💬

Creating Stored Procedures with Statement Blocks in SQL Server
How To Create a Stored Procedure with a Statement Block in SQL Server Transact-SQL? If you are creating a stored procedure with multiple statements, it's better to use "BEGIN ... END" to group all statements into a single statement block. The tutorial exercise below shows you some good examples: USE...
2017-01-05, 3075🔥, 0💬

SCROLL - Creating Cursors for Backward Scrolling in SQL Server
How To Create a Scrollable Cursor with the SCROLL Option in SQL Server Transact-SQL? SQL Server offers two scrolling option on cursors: 1. FORWARD_ONLY - The cursor can only be scrolled forward with "FETCH NEXT" statements. In another word, you can only loop through the cursor from the first row to ...
2016-10-17, 3063🔥, 0💬

Date and Time Functions Supported by SQL Server 2005 in SQL Server
What Are the Date and Time Functions Supported by SQL Server 2005 in SQL Server Transact-SQL? SQL Server 2005 supports n character string functions: DATEADD(datepart, number, date) - Returning the same date and time value with one part added with the "number". DATEDIFF(datepart, startdate, enddate) ...
2017-02-20, 3061🔥, 0💬

Finding the Login Name Linked to a Given User Name in SQL Server
How To Find the Login Name Linked to a Given User Name in SQL Server? If you know a user name in a database and you want to find out which login name is linked this user name, you need to check the Security ID (SID) of the user name based on the following rules: Each login name is associated a uniqu...
2017-08-25, 3060🔥, 0💬

Start and End of Statement in SQL Server Transact-SQL
How to start and end a statement in SQL Server Transact-SQL? Here are some simple rules about writing statements in SQL Server Transact-SQL: A Transact-SQL statement must be started with a pre-defined statement keyword. A Transact-SQL statement must be ended with a new line (/n) or a semicolon (;) c...
2017-05-29, 3058🔥, 0💬

"GRANT EXECUTE" Statements - Granting EXECUTE permission in SQL Server
How to grant a permission using "GRANT EXECUTE" statements in SQL Server? This is the fourth tutorial of a quick lesson on creating login and configure users for databases with Transact-SQL statements. Granting a user access to a database involves three steps. First, you create a login. The login le...
2016-11-27, 3054🔥, 0💬

"DROP LOGIN" - Deleting a Login Name in SQL Server
How To Delete a Login Name in SQL Server? If you don't want to keep a login name any more, you should delete it by using the "DROP LOGIN" statement as shown in this tutorial example: -- Login with "sa" DROP LOGIN Dba_Login; GO Command(s) completed successfully. -- View login names SELECT name, sid, ...
2016-10-19, 3050🔥, 0💬

Default Schema of Your Login Session in SQL Server
What Is the Default Schema of Your Login Session in SQL Server? When you login to a SQL Server and select a database to use, SQL Server will assign your login session a default schema. The schema name can be omitted when you refer to objects in the default schema. Here is what you should remember ab...
2016-10-22, 3048🔥, 0💬

Using Old Values to Define New Values in UPDATE Statements in SQL Server
How to use old values to define new values in UPDATE statements in SQL Server? If a row matches the WHERE clause in a UPDATE statement, existing values in this row can be used in expressions to provide new values in the SET clause. Existing values are represented by column names in the expressions. ...
2016-11-02, 3043🔥, 0💬

<< < 3 4 5 6 7 8 9 10 11 12 13 > >>   ∑:509  Sort:Date