Index of SQL Server Articles
| Topic | Tutorial Link |
|---|---|
| SQL Server – Change Edit Top 200 Rows and Select Top 1000 Rows to Select/Edit All | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-server-2008-change-edit-top-200-rows-and-select-top-1000-rows-to-selectedit-all/','_blank')"] |
| Restore SQL Server Backup file to Older SQL Server Version | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/restoring-sql-server-2008-r2-backup-file-to-sql-server-2008/','_blank')"] |
| How to Reset the Value of identity Column in SQL Server ? | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/how-to-reset-the-value-of-identity-column-in-sql-server/','_blank')"] |
| How to find the SQL Server Version with a query ? | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/how-to-find-the-sql-server-version-with-a-query/','_blank')"] |
| Auto generate change scripts in SQL Server Management Studio | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/auto-generate-change-scripts-in-sql-server-management-studio/','_blank')"] |
| Open DBDiff for SQL Server | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/open-dbdiff-for-sql-server-2008/','_blank')"] |
| Which port number does SQL Server run on? | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/which-port-number-does-sql-server-run-on/','_blank')"] |
| Difference between Primary Key and Unique Key | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/difference-between-primary-key-and-unique-key/','_blank')"] |
| Difference between DELETE and TRUNCATE command in SQL Server | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/difference-between-delete-and-truncate-command-in-sql-server/','_blank')"] |
| Difference between HAVING Clause and WHERE Clause | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/difference-between-having-clause-and-where-clause/','_blank')"] |
| How to take Database Backup in SQL Server 2008 R2? | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/how-to-take-database-backup-in-sql-server-2008-r2/','_blank')"] |
| How to Create a Database Backup in SQL Server using SQL Scripts? | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/how-to-create-a-database-backup-in-sql-server-using-sql-scripts/','_blank')"] |
| How to query the version number and other information related to SQL Server ? | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/how-to-query-the-sql-server-version-and-other-information/','_blank')"] |
| How to escape single quote in SQL Server? | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/how-to-escape-a-single-quote-in-sql-server/','_blank')"] |
| How to Export the Query Result to .csv file in SQL Server? | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/how-to-export-the-query-result-to-csv-file-in-sql-server/','_blank')"] |
| What are the Limitations of SQL Server Express Edition ? | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/what-are-the-limitations-of-sql-server-express-edition/','_blank')"] |
| How to Get the List of User Tables in SQL Server? | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/how-to-get-the-list-of-user-tables-in-sql-server/','_blank')"] |
| How to Specify port number for Server when connecting in SQL Management Studio ? | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/how-to-specify-port-number-for-server-when-connecting-in-sql-management-studio/','_blank')"] |
| How to Get the Number of Tables from SQL Server Database ? | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/how-to-get-the-number-of-tables-from-sql-server-database/','_blank')"] |
| SQL Server 2014 Tutorial – Install SQL Server 2014 on Windows 10 machine | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-server-2014-tutorial-install-sql-server-2014-on-windows-10-machine/','_blank')"] |
| Column Alias and Square brackets in SQL Query. | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/column-alias-and-square-brackets-in-sql-query/','_blank')"] |
| Other ways of specifying the alias name for a column in SQL Server | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/other-ways-of-specifying-the-alias-name-for-a-column-in-sql-server/','_blank')"] |
| Wildcard Search in SQL Query | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/wildcard-search-in-sql-query/','_blank')"] |
| Using Expressions for SORT Order in SQL Server | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/using-expressions-for-sort-order-in-sql-server/','_blank')"] |
| How to check if the table exists in a database in SQL Server ? | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/how-to-check-if-the-table-exists-in-a-database-in-sql-server/','_blank')"] |
| WAITFOR DELAY in SQL Server | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/waitfor-delay-in-sql-server/','_blank')"] |
| WAITFOR TIME in SQL Server | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/waitfor-time-in-sql-server/','_blank')"] |
| How to replace NULL values with alternate values in SQL Server ? | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/how-to-replace-null-values-with-alternate-values-in-sql-server/','_blank')"] |
| Kill all the current active connection in SQL Server database | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/kill-all-the-current-active-connection-in-sql-server-database/','_blank')"] |
| How to get day of a week in SQL Server ? | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/how-to-get-day-of-a-week-in-sql-server/','_blank')"] |
| Print a text N number of times in SQL Management Studio | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/print-a-text-n-number-of-times-in-sql-management-studio/','_blank')"] |
| How to view the code of a stored procedure using a Query in SQL Server ? | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/how-to-view-the-code-of-a-stored-procedure-using-a-query-in-sql-server/','_blank')"] |
| Quick way to search within a procedure in SQL Server | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/quick-way-to-search-within-a-procedure-in-sql-server/','_blank')"] |
| SQL Server’s ISNULL() equivalent in PostgreSQL | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-servers-isnull-equivalent-in-postgresql/','_blank')"] |
| How to return the column names from a table in SQL Server ? | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/how-to-return-the-column-names-from-a-table-in-sql-server/','_blank')"] |
| Dealing with the column names that looks like SQL Keywords in SQL Server | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/dealing-with-the-column-names-that-looks-like-sql-keywords-in-sql-server/','_blank')"] |
| SQL Function to make all TEXT to propercase in SQL Server | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-function-to-make-all-text-to-propercase-in-sql-server/','_blank')"] |
| SQL Server – Shortcut to display the Stored procedure Code | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-server-shortcut-to-display-the-stored-procedure-code/','_blank')"] |
| Fix – Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80004005. SQLSTATE: 08001, Native Error: 17 | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/fix-sqllib-error-oledb-error-encountered-calling-idbinitializeinitialize-hr-0x80004005-sqlstate-08001-native-error-17/','_blank')"] |
| SQL Server 101 – How to Delete Top N records ? | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-server-101-how-to-delete-top-n-records/','_blank')"] |
| SQL Server 101 – How to add a column with a default value to existing table ? | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-server-101-how-to-add-a-column-with-a-default-value-to-existing-table/','_blank')"] |
| SQL Server 101 – Check if a column exists in a table | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-server-101-check-if-a-column-exists-in-a-table/','_blank')"] |
| SQL Server 101 – Return the Current DateTime | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-server-101-return-the-current-datetime/','_blank')"] |
| SQL Server 101 – Get the Date part from DateTime | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-server-101-get-the-date-part-from-datetime/','_blank')"] |
| SQL Server 101 – Get the size of all tables in database | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-server-101-get-the-size-of-all-tables-in-database/','_blank')"] |
| SQL Server 101 – Search tables for a specific column name | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-server-101-search-tables-for-a-specific-column-name/','_blank')"] |
| SQL Server 101 – Get the identity of inserted row | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-server-101-get-the-identity-of-inserted-row/','_blank')"] |
| SQL Server 101 – Extract Domain Name from Email Address | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-server-101-extract-domain-name-from-email-address/','_blank')"] |
| SQL Server 101 – GROUP BY datetime and ignore time | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-server-101-group-by-datetime-and-ignore-time/','_blank')"] |
| SQL Server Error Msg 104 – ORDER BY items must appear in the select list if the statement contains a UNION | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-server-error-msg-104-order-by-items-must-appear-in-the-select-list-if-the-statement-contains-a-union//','_blank')"] |
| SQL Server 101 – How to Round Up or Round Down a Number ? | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-server-101-how-to-round-up-or-round-down-a-number/','_blank')"] |
| SQL Server 101 – How to Find Currently Running Query ? | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-server-101-how-to-find-currently-running-query/','_blank')"] |
| SQL Server Error Msg 107 – The column prefix does not match with a table name or alias name used in the query | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-server-error-msg-107-the-column-prefix-does-not-match-with-a-table-name-or-alias-name-used-in-the-query/','_blank')"] |
| SQL Server Error Msg 53 – An error has occurred while establishing a connection to the server | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-server-error-msg-53-an-error-has-occurred-while-establishing-a-connection-to-the-server/','_blank')"] |
| SQL Server Error Msg 108 – The ORDER BY position number 4 is out of range of the number of items in the select list | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-server-error-msg-108-the-order-by-position-number-4-is-out-of-range-of-the-number-of-items-in-the-select-list/','_blank')"] |
| SQL Server Error Msg 109 – There are more columns in the INSERT statement than values specified in the VALUES clause. | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-server-error-msg-109-there-are-more-columns-in-the-insert-statement-than-values-specified-in-the-values-clause/','_blank')"] |
| SQL Server Error Msg 110 – There are fewer columns in the INSERT statement than values specified in the VALUES clause | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-server-error-msg-110-there-are-fewer-columns-in-the-insert-statement-than-values-specified-in-the-values-clause/','_blank')"] |
| SQL Server Error Msg 111 – ‘CREATE FUNCTION’ must be the first statement in a query batch | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/sql-server-error-msg-111-create-function-must-be-the-first-statement-in-a-query-batch/','_blank')"] |
| Download & Install SQL SERVER 2019 Developer Edition for free | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/download-install-sql-server-2019-developer-edition-for-free/','_blank')"] |
| Download & Install – SQL Server Management Studio | [gamipress_button label="Learn" onclick="window.open('https://developerpublish.com/download-install-sql-server-management-studio/','_blank')"] |