Difference between char and nchar : MS SQL Server Datatypes
A database has a vast collection of data stored in an organized format. A database might contain a variety of data values stored in it.… Read More »
Tag Archives: SQL-Server
SQL Server LEAD() function Overview
At many instances, user would really like to check the worth of the present row with the worth of the subsequent row. to resolve this… Read More »
Find Duplicates in MS SQL Server
We could use the following methods to find duplicate values in a table. GROUP BY clause. ROW_NUMBER() function. 1. Using the GROUP BY clause to… Read More »
Delete Duplicates in MS SQL Server
Duplicate values in any table might be due to the poor table design or unwanted data from other sources. To delete the duplicate data from… Read More »
Numeric and Date-time data types in SQL Server
MS SQL Server supports a wide range of data types. There are a few more important data types that are included in the article. In… Read More »
text, ntext, binary, varbinary and varbinary(max) in MS SQL Server
Character (char) and variable character (varchar) are used in storing fixed length of words. These data types are used for creating databases on small scale.… Read More »
DROP FUNCTION and its Parameters
DROP FUNCTION : This statement could be used to remove an existing user-defined function. Syntax : DROP FUNCTION [ IF EXISTS ] schema_name.function_name; Example – … Read More »
RANK() Function in SQL Server
The RANK() function is a window function could be used in SQL Server to calculate a rank for each row within a partition of a… Read More »
NTILE() Function in SQL Server
NTILE() function in SQL Server is a window function that distributes rows of an ordered partition into a pre-defined number of roughly equal groups. It… Read More »
Blocking in SQL Server
Blocking in SQL servers happens when a connection to SQL server blocks one or more query, and another connection to SQL server requires a conflicting… Read More »
Sequence with examples in SQL Server
Sequence : A sequence is a list of numbers, in an ordered manner. For example, {1, 2, 3} is a sequence and {3, 2, 1}… Read More »
Orphan User in SQL Server
Orphan users are the users which are available in the database level but their mapped logins not available in the server level. Orphan users are… Read More »
ALTER SCHEMA in SQL Server
The ALTER SCHEMA statement used to transfer a object from a schema to another schema in the same database. Syntax : ALTER SCHEMA target_schema_name TRANSFER… Read More »
DROP SCHEMA in SQL Server
The DROP SCHEMA statement could be used to delete a schema from a database. SQL Server have some built-in schema, for example : dbo, guest,… Read More »
Check Constraint in MS SQL Server
Check Constraint : It is used alongside relational operators to check whether a value satisfies the condition or not (boolean). If the condition is satisfied,… Read More »
