Assume that you have a table which contains alphabetic, numeric, alphanumeric string, and special characters and you are asked to fetch only alphanumeric string from… Read More »How to fetch alphanumeric string from table
20,587 total views, 8 views today
SQL Vulnerability Assessment (VA) is an easy to use tool that you can use to identify, track, and remediate potential database vulnerabilities. The VA service… Read More »SQL Vulnerability Assessment
1,744 total views
How to find and separate the numbers, letters and special characters from string? Suppose you a column in table which contains a mix words which… Read More »Separate numbers, letters and special characters from string
11,073 total views, 4 views today
A correlated subquery is a subquery that uses the values of the outer query and it is evaluated for each row processed by the outer… Read More »SQL Correlated Subquery
2,704 total views
Blocking occurs when a process hold a lock and other process has to wait till the first process completes.
9,143 total views, 2 views today
CUBE operator is used to calculate subtotals and grand total for all combinations of grouping columns specified in the GROUP BY clause.
2,276 total views
Temporary or Temp tables are tables that exist temporarily on the SQL Server.
2,764 total views
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.
1,624 total views
The Concept of User Defined table type and table valued parameters were introduced in SQL server 2008.
26,170 total views, 6 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,872 total views, 1 views today
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,695 total views
What is the Difference between SQL Truncate and SQL Delete statements in SQL Server ?
2,150 total views, 1 views today
How to copy a data of table from another database in SQL Server?
Suppose, you have a database1 and table1 and one another database2 and table2 in SQL server.
Now you are required to select data of a table1 of database1 from database2 of table2.
What would be a query for that?
26,516 total views, 6 views today
It fires in response to LOGON events of SQL Server is raised .
A LOGON Triggers can be useful in may ways, such as to restrict number of connection made by a Login or to prevent a user from logging-in outside .
1,797 total views