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,998 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,998 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,944 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,179 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,724 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,809 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
794 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,658 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,241 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
783 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
949 reads
By Vinay Thakur
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer...
Next up in my series talking about The Burrito Bot is diving into the...
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
Comments posted to this topic are about the item Unraveling the Mysteries of the...
Comments posted to this topic are about the item QUOTENAME Behavior
Good Morning. I have a T-SQL Script which has been developed to execute a...
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers