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.

 663 total views,  3 views today

Read More...

How to get identity column without using actual column name?


How to Find out Identity Column Without Using Column Name ?

 77 total views,  1 views today

Read More...

SQL Server ISNUMERIC Function


SQL Server ISNUMERIC( ) function is System Functions which is used to check if the expression is valid numeric type or not.

 121 total views,  1 views today

Read More...

SQL Server Computed Columns


A computed column is a virtual column which is used to add a new column to a table with the value derived from the values of other columns in the same table.

Computed column is not physically stored in the table, unless column is marked PERSISTED and it is persisted only if its expression is deterministic.

 226 total views

Read More...

How to create a custom shortcuts in SQL Server


How to create a custom shortcuts for stored procedures in SQL Server ?

 130 total views

Read More...

SQL Server CUBE


CUBE operator is used to calculate subtotals and grand total for all combinations of grouping columns specified in the GROUP BY  clause.

 396 total views

Read More...

SQL Server GROUPING SETS


SQL GROUPING SETS allows computing multiple GROUP BY clauses in a single statement.  The results of GROUPING SETS are the equivalent of UNION ALL of the specified groups.

 246 total views,  2 views today

Read More...

Temporary table / temp table in SQL Server


Temporary or Temp tables are tables that exist temporarily on the SQL Server.

 462 total views,  1 views today

Read More...

SQL SERVER TRY_CAST()


SQL Server TRY_CAST() Function is a conversion functions that is used to cast a value to a specified data type.

 293 total views,  1 views today

Read More...

SQL Server CTE


SQL Server CTE (Common Table Expression) is temporary result set that is used to reference within another SELECT, INSERT, UPDATE, or DELETE statement.

 183 total views,  2 views today

Read More...

SQL Server Interview Question & Answer Quiz on CREATE statement


SQL Server Interview Question & Answer Quiz on CREATE statement

 86 total views

Read More...

SQL SERVER Interview Q & A QUIZ on SUBSTRING()


SQL interview question and answer on Substring function

 407 total views,  6 views today

Read More...

SQL Server DENSE_RANK()


The DENSE_RANK() is a Ranking function that is used to assign ranks to rows in partitions with no gaps in the ranking values.

 138 total views,  1 views today

Read More...

SQL RANK()


The RANK()  function is a window function that is used to assign a rank to each row in the partition of a result set.

 218 total views

Read More...

SQL SERVER EXCEPT


The SQL EXCEPT clause is used to combine two SELECT statements and returns rows from the first SELECT statement that are not returned by the second SELECT statement. 

 109 total views,  1 views today

Read More...

SQL SERVER INTERSECT


The SQL INTERSECT clause is used to combine two SELECT statements, but returns rows only from the first SELECT statement that are identical to a row in the second SELECT statement.

 97 total views,  1 views today

Read More...

SQL SERVER User Defined Table Type and Table Valued Parameters


The Concept of User Defined table type and table valued parameters were introduced in SQL server 2008.

 1,820 total views,  13 views today

Read More...

Get the definitions of Stored procedures, User Defined functions and Triggers in SQL


How to get the full text descriptions / definitions of any stored procedures , UDF  or triggers in SQL ? There are many ways to get the definition of any Stored Procedure, UDF and triggers…

 382 total views

Read More...

SQL Unique Key Constraint


A unique key constraint is a set of one or more than one columns of a table that uniquely identify a record in a database table.

 108 total views,  1 views today

Read More...

SQL Q & A on SELECT Statement


Q 1 > SELECT Count(1) as Output 1> NULL 2> Error 3> 1 4> Invalid select statement Answer   Q 2 > SELECT Count(*) as Output 1> NULL 2> 1 3> Error 4> Invalid select…

 153 total views

Read More...