https://wiki.ispirer.com/ 2026-08-29T08:33:16+00:00 https://wiki.ispirer.com/ https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/data-types?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing Microsoft SQL Server - Data Types Versions: SQL Server 2008, 2005, 2000, 7.0 and 6.5 Data Type Parameters and Range Character Data Types CHAR(n) - Fixed-length character data 1 <= n <= 8000, default is 1 NCHAR(n) - Fixed-length character data in Unicode - UCS-2 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/date-time-functions?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - Date and Time Functions This article describes the Transact-SQL date and time functions supported by Microsoft SQL Server. Overview Function Description GETDATE() Returns the current system date and time. GETDATE SQL Server - GETDATE text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/functions?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server Functions * SQL Functions Mapping to Other Databases * Numeric Functions * ABS * ACOS * ASIN * ATAN * ATN2 * CEILING * COS * COT * DEGREES * EXP * FLOOR * LOG * LOG10 * PI * POWER * RADIANS * RAND * ROUND * SIGN * SIN * SQRT * SQUARE * TAN * String Functions * ASCII * CHAR * CHARINDEX * DIF… text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/identifiers?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - Identifiers This article describes identifiers in Microsoft SQL Server. Identifier Rules SQL Server - Identifier Rules First Character An alphabetical character, underscore (_), at sign (@) and pound sign (#) Subsequent Characters text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/migration-assessment?rev=1741078744&do=diff User Documentation Ispirer Assessment Tools Overview Pricing Microsoft SQL Server - Migration Assessment * Collecting Information text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/set-lock-timeout?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - SET LOCK_TIMEOUT Statement SQL Server - SET LOCK_TIMEOUT Statement Syntax SET LOCK_TIMEOUT milliseconds Description SET LOCK_TIMEOUT defines how to handle a process that tries to access a locked row or table. -1 - the server waits forever (no timeout). This is the default behavior for locking. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/statements?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing Microsoft SQL Server - SQL Statements This article describes the SQL Statements supported by Microsoft SQL Server 2008 and earlier. * SET LOCK_TIMEOUT text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/string-functions?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - String Functions This article describes string functions in Microsoft SQL Server. Overview Function Description LEN() Length of string SUBSTRING() Substring at the specified position and length LTRIM() Removes leading blank characters RTRIM() Removes trailing blank characters text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/system-functions?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing SQL Server - System Functions This article describes the Transact-SQL system functions supported by Microsoft SQL Server. Overview Function Description APP_NAME() Returns the application name for the current session OBJECT_NAME() Returns the database object name text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/techniques?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing Microsoft SQL Server - Techniques * Returning Result Sets from Stored Procedures * Returning Information as Result Set (Dummy Tables) * TRUNC (date) function conversion from Oracle to MS SQL Server text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/transactions?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing Microsoft SQL Server - Transactions This article describes transactions in Microsoft SQL Server 2008 and earlier. Transactions In SQL Server, transactions are explicit by default. This means that each SQL statement is not a part of a logical transaction by default, and it is committed on completion. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/sql-server/upgrade?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing MSSQL - Upgrade * Data Types * Built-in SQL Functions migration * System object conversion * Statements Syntax Conversion