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.
8,170 total views
How to Find out Identity Column Without Using Column Name ?
1,086 total views
Temporary or Temp tables are tables that exist temporarily on the SQL Server.
2,586 total views
SQL Server CTE (Common Table Expression) is temporary result set that is used to reference within another SELECT, INSERT, UPDATE, or DELETE statement.
3,582 total views
SQL Server Interview Question & Answer Quiz on CREATE statement
1,471 total views
SQL interview question and answer on Substring function
3,732 total views, 1 views today
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.
1,786 total views, 1 views today
Q 1 > SELECT Count(1) as Output 1> NULL 2> Error 3> 1 4> Invalid select statement Answer Q 2 > SELECT Count(*) as… Read More »SQL Q & A on SELECT Statement
1,780 total views
A PRIMARY KEY constraint uniquely identifies each record in a table .
1,441 total views
A foreign key is a key used to link two tables together. This is sometimes also called as a referencing key , usually a primary key table is considered as a parent table while a foreign key table is considered as a child table .
2,464 total views