Hide SQL Server database engine instances from network discovery | Cluster instances | Availability Group Name

Hide SQL Server database engine instances from network discovery | Cluster Instances | Availability Groups nameSQL Server Browser listens for incoming requests for Microsoft SQL Server resources and provides information about SQL Server...

Read More

SQL Server Working with NULL | Null Functions | Expressions | Comparisons | Examples

SQL Server Working with NULL | Null Functions | Expressions | Comparisons | Examples  What is a NULL value in SQL?  In SQL, a NULL value helps to identify that particular attribute/column data is not available in the table. As per BOL, "Null (or NULL) is a special marker used in Structured Query Language to indicate that...

Read More

SQL Server RAND() function | Generating random number within the specific range

SQL Server RAND() function | Generating random number in a range In this article, we will see RAND() function and also see how to generate a random number in a range using RAND() function. RAND() Function The RAND function can be used to return a random number. It will return a value between 0 and 1 such as value greater than 0 and less...

Read More

Difference between truncate table and delete table commands with examples

Difference between truncate and delete commands with examples Truncate Truncate is a DDL command. This command is used to delete all the records from the table permanently. Syntax: TRUNCATE TABLE <TABLE_NAME>; Delete ...

Read More

SSMS query editor adding line number | GOTO Line number | SQL Server Management studio

SSMS query editor adding line numbers and GOTO line numberAdding Line NumbersIn SQL Server management studio we have a provision to enable line number in the query editor. For long scripts, it can be helpful in referring to a particular...

Read More

SQL Server Heap Tables | Storage | Forwarding Pointers | Rebuild Heap

What is Heap Table? SQL Server stores a table as a heap or B-tree. If you create a table without index then it is stored as a heap. Similarly, If you create a table with a clustered index, then it is stored as a B-tree. A table can...

Read More

SQL Server accent-insensitive sorts and string comparisons | collation

SQL Server accent-insensitive sorts and string comparisons In general, SQL Server default collation is SQL_Latin1_General_CP1_CI_AS, So by default SQL Server database is always insensitive to the case(CI) and sensitive to the accent(AS) of the characters. In sometimes we need to do accent-insensitive comparisons and sorts. To do such...

Read More