FYI Center for Database Administrators: SQL Server

MySQL Function References
Where to find reference information and tutorials on MySQL database functions? I want to know how to use SUBSTRING(), ABS(), DATEDIFF(), and other MySQL functions. Here is a collection of reference information and tutorials on MySQL database functions compiled by FYIcenter.com DBA team. Calling MySQ... 2023-11-18, 9135🔥, 0💬

<< < … 17 18 19 20 21 22 ∑:509 Sort:Rank

DYNAMIC - Creating Dynamic Cursors in SQL Server
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying table is changed after the cursor is opened, should the changes be reflected in the cursor result set? The answer is based on the update option used when creating the cursor. SQL SERVER supports two ... 2016-10-17, 6053🔥, 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, 2605🔥, 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, 2551🔥, 0💬

Declaring and Using Cursor Variables in SQL Server
How To Declare and Use Cursor Variables in SQL Server Transact-SQL? There are two ways to representing a cursor: 1. A cursor name - A static name representing a cursor object. A cursor name should be linked to a cursor object in the DECLARE statement. 2. A cursor variable name - A variable name poin... 2016-10-17, 2253🔥, 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, 2127🔥, 0💬

<< < … 17 18 19 20 21 22 ∑:509 Sort:Rank

Popular Posts:

Converting Binary St...

Can Binary Strings Be Converted into NUMERIC or FLOAT Data Types in SQL Server Transact-SQL? Can bin...

sys.database_princip...

How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...

IF ... ELSE Statemen...

How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...

DEFAULT - Providing ...

How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...

Converting Unicode S...

How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...