How to format a number with commas in SQL Server?
There are couple of different ways to format a number with commas in SQL Server. Let see them in detail.
SQL Server 2005
List All Foreign Keys Referencing A Table In SQL Server
Quick methods to list all foreign keys referencing a table in SQL Server using execution of simple TSQL scripts and SSMS GUI. Ways to identify all the tables referencing a table with foreign key constraint
Pagination of Results in SQL Server In Efficient Way
How to do pagination of results in SQL Server In and efficient way? Best way to paginate results in SQL Server to improve performance of the application.
How to get Date from DateTime data type in SQL Server?
How to get date part alone from DateTime and DateTime2 data types in SQL Server? Here are few of the techniques to get date from DateTime column.
TRIM() Function To Remove Space In SQL Server
TRIM() Function In SQL Server 2017 and equivalent custom made TRIM UDF in 2016 and older versions ti trim the spaces at the starting and ending of a string.
Offline Vs Detach Vs Emergency Database In SQL Server
Differences between taking database offline, detaching it and moving it to emergency mode in SQL Server? Offline Vs Detach Vs Emergency in table format.
Detach And Attach Database In SQL Server
Simple method to detach and attach database in SQL Server. T-SQL method and SSMS method to detach an database and attach it back.
Taking Database Offline In SQL Server
How to take an SQL Server database offline? Simple methods to bring a MSSQL database to offline state using transact-SQL or management studio.
Temp Table vs Table Variable vs CTE in SQL Server
Difference between Temp Table, Table Variable and CTE in SQL Server. Temp Table vs Table Variable vs CTE and their usage.
Function vs Stored Procedure in SQL Server
Difference between function and stored procedure in SQL Server. Here you have a comparison table on Function vs Stored Procedure.
Hash Code Encryption with HASHBYTES in SQL Server
Encrypting a string using hash code algorithm in sql server using the HASHBYPES function. Hash Code Encryption using MD2, MD4, MD5, SHA, SHA1, SHA 256 & 512
Find Size Of Tables In Database – SQL Server
Easy method to find the size of tables in an SQL Server database. Get the size of all the tables in a database using SSMS standard report and queries.
SQL Server: Concatenate Multiple Rows Into Single String
Combine multiple rows into one string in SQL Server. Simple query in SQL Server to concatenate multiple rows Into single string.
Check If Column Exists In Table Of SQL Server
Tips and tricks to check if column exists in a SQL Server database table. Also find the list of all tables and stored procedures having the column name.
Fix for “unable to load client print control” Error
Steps to fix the error “unable to load client print control” received during printing reports SQL Reporting Services reports.