Question and Answer #5

Question – Out of below 2 servers, We need to find which one is 'Microsoft Azure Synapse Analytics'? Other might be 'SQL Database'.1️⃣ "s1.database.windows.net"2️⃣ "s2.database.windows.net" How to find? 💡 For "Dedicated SQL pool (formerly SQL DW)" , the endpoint would be same as SQL Database ".database.windows.net" [Still pricing tier is different: cDWU vs DTU/vCore]Under "Azure Synapse Workspace"… Continue reading Question and Answer #5

FB Group Questions · Q & A · Real Scenario Logic's · User Q & A

SQL Question and Answer #4

Featured Arulmouzhi ELeave a comment

Question - What is Attribute, Tuple, Domain and Degree? Thinking that it will be useful to know some of the Basic Term definitions. Inspired from this Question. Attribute Basic, Rows are Records, Columns are Attributes of a Table. Tuple Tuple is a Single row of a Table. Domain Domain is the set of possible data… Continue reading SQL Question and Answer #4

Play in SQL · Q & A · Real Scenario Logic's

SQL Question and Answer #3

Featured Arulmouzhi E3 Comments

Question Pic - Try yourself before checking Answer below! Question pic There can be 'n' number of answers for the above question. Among those, Below we have given one. Please comment your other methods of doing it. Because Sharing is Caring! From 'Thursday, March 05 2020' To '2020-03-05' SQL Script DECLARE @date VARCHAR(50) = 'Thursday,… Continue reading SQL Question and Answer #3

Q & A · Real Scenario Logic's

SQL Question and Answer #2

Featured Arulmouzhi E2 Comments

Everything we see is a perspective, not the truth. Question Pic Question SQL Script SELECT $42; SELECT $ 42; SELECT $ 42; SELECT $ 42; Q & A Will Line 1 Query Run without any error? If 'Yes', what's the Result? If 'No', Why it throws error? Keep Guess.... The Answer is Yes, Line 1… Continue reading SQL Question and Answer #2