You always wanted to know how to pass arrays to SQL Server? Watch this Ultimate Guide to Table-Valued Parameters! Hello and welcome! My name is Vedran Kesegić and this video is an absolute “must” for database developers. Fast performing database …

How to pass arrays to SQL? TVP – The Ultimate Guide Read more »

Tagged with: , , , , , , ,

Want to learn SQL and need some guidance? SQL is the language you communicate with most of databases today, including SQL Server. Watch these videos: SQL for absolute beginners https://www.youtube.com/watch?v=27axs9dO7AE SELECT basics https://www.youtube.com/watch?v=SoxHivg9Ldw SELECT extended https://www.youtube.com/watch?v=D37_7p0-iKM Subqueries (a bit advanced) …

SQL for absolute beginners Read more »

Did you know that SUM() aggregate can be used together with OVER() clause? A short intro to windowing functions:

The result is graphically visualized by using only SQL Server Management Studio and unicode characters:

Tagged with: , , , ,