In Sql Server STR() function converts a numeric value to character data. STR() function allows us to specify the total length and number of decimal places to be included when it is converted to character data. Continue reading “STR(), CHAR(), and ASCII() function in SQL Server”
DATALENGTH function returns the number of bytes used to represent any expression. DATALENGTH is especially very useful with varchar, varbinary, text, image, nvarchar, and ntext data types because these data types can store variable-length data. Continue reading “DATALENGTH() AND COL_LENGTH() in SQL Server”
ISNULL function replaces NULL values with the specified replacement value. you can use ISNULL as Continue reading “ISNULL in SQL Server”
When we want to use Checking or Condition upon an aggregate column with Group By clause in Select statement then we cannot use Where statement with aggregate column, in this case we use Having clause. Continue reading “SQL Having Clause”
When we want to perform calculation on any column like Sum or want to use aggregate functions like Min, Max in our Select statement then we use GROUP BY statement. GROUP BY statement returns result across multiple records and group the results by one or more desired columns. Continue reading “SQL Group by Clause”
The INSERT INTO statement is used to insert a new row in a table. You can add the single record or multiple records into the table using Insert statement. Continue reading “Insert Statement in SQL Server”