Geek Logbook

Tech sea log book

Common table expressions

Specifies a temporary named result set, known as a common table expression (CTE). Microsoft Documentation Although there are some time around us the first time someone asked me about it I was confused: I haven’t know its proper definition until that momento. In fact, the common table expressions where added to the SQL standard in

Know your String Connection using SQL

I was looking how to know my server on the internet, and I’ve found this interesting question in Stackoverflow: How to get the connection String from a database. And one question give us an example of how do it using SQL: And it Works properly: