Home » SQL Database »
SQL Database
SQL Server Tutorials By Pradeep Raturi- This website provides a SQL server, SSRS, Power BI, Python, Azure basics and advanced tutorials for beginners and professionals .You will find out a step-by-step
SQL SERVER NVARCHAR
SQL Server NVARCHAR is used to store uniqcode string data of variable length, it can store both unicode and non unicode strings.
SQL SERVER VARCHAR
SQL Server VARCHAR Data Type is used to store non-unicode string data of varaible length.
Generate calendar table in SQL Server
How to Display calendar dates for any n numbers of years in SQL Server?
SQL Server Download links
Following are the links to download SQL Server 2019 and Database sample files
How to split comma separated string values into columns
SQL Server CHAR data type is used to store non-Unicode string data of fixed-length.
SQL Server OFFSET FETCH
SQL Server OFFSET FETCH clauses are used to set the limit to number of rows returned by a query.
SQL Server Verbose Truncation Warnings
SQL Server Verbose Truncation Warnings
Sometimes we receives data truncation error in SQL Server such as “String or binary data would be truncated” and it does not specify exact source of error in terms of Database name, table name , column name and truncated values.
SQL Server @@SPID
SQL Server @@SPID
SQL Server @@SPID is a SQL Server configuration function that is used to return the session id of current user process.
SYNTAX
@@SPID
SQL Server @@Version
SQL Server @@Version is a configuration function that returns system and build information for the current installation of SQL Server. SYNTAX @@Version Return Type of… Read More »SQL Server @@Version
SQL SERVER SP_MONITOR
SP_MONITOR is a SQL Server Database Engine system stored procedure which is used to Display statistics about Microsoft SQL Server.
SYNTAX
EXEC sp_monitor
SQL Server STRING_AGG Function
SQL Server STRING_AGG() Function is string function which concatenates values for any given string expressions and separate them a specified separator.
It does not add the separator at the end of the result string.
String expression values are implicitly converted to string types and then concatenated.
SQL Server Format Function
The SQL Format function is a SQL Server string function which is used to format the specified value in the given format such as to format the date/time values and number values.
How to display currency symbol in SQL Sever
How to Display currency symbol in SQL Sever?
Sometimes we are required to display a currency symbol along with the amount in query result set, It becomes challenge to displaying a currency symbol with amount.
How to get the sizes of all databases on a SQL Server
How to get the sizes of all databases on a SQL Server ?
SQL Server Lag Function
SQL Server LAG() function is a Analytics Functions that provides access to a row at a given physical offset that comes before the current row.
SQL Server Lead Function
SQL Server LEAD() function is a Analytics function that provides access to a row at a specified physical offset which follows the current row.
Basically, LEAD() function provides access to a row at a given physical offset that follows the current row.
SQL Server NEWSEQUENTIALID()
SQL Server NEWSEQUENTIALID() function is used to generate incremental unique values of type uniqueidentifier.