Interview Questions On Sql Server -Part 2
1. What is the difference between the Union and Union All?
1) Union is used to select distinct data from the...
2010-01-31
1,986 reads
1. What is the difference between the Union and Union All?
1) Union is used to select distinct data from the...
2010-01-31
1,986 reads
1. What are the Sql Joins?Sql Joins are the way to get data from many tables based on some logical...
2010-01-31
1,932 reads
1. What is the Normalization?Normalization:-Normalization can be defined as the process of organization the data to reduce the redundant table...
2010-01-31
2,172 reads
Views:- View can be described as virtual table which derived its data from one or more than one table columns.It...
2010-01-31
1,705 reads
Normalization :- Normalization can be defined as the process of organization the data to reduce the redundant table data to the...
2010-01-26
2,799 reads
First Normal Form (INF):- A table is said to be in a First Normal Form (1NF)if it satisfy the following...
2010-01-26
788 reads
Second Normal Form (2NF) :-A table is said to be in its Second Normal Form if it satisfied the following...
2010-01-26
3,645 reads
Third Normal Form (3NF) :- A table is said to be in the Third Normal form (3NF) if it satisfy the...
2010-01-26
2,237 reads
Indexes-Indexing is way to sort and search records in the table. It will improve the speed of locating and retrieval...
2010-01-03
774 reads
Indexes-Indexing is way to sort and search records in the table. It will improve the speed of locating and retrieval...
2010-01-03
933 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers