Microsoft SQL Server Archives - Page 2 of 2 - Database Tips

Using SQL in Python

February 22, 2019 Database Tips Microsoft Access, Microsoft SQL Server, ORACLE, Python, SQL, SQLite

Python has become one of the most popular programming languages and is used in various contexts, including in WEB applications[…]

Read more

LEAD and LAG: accessing multiple rows without self join

February 12, 2019 Database Tips Microsoft Access, Microsoft SQL Server, MySQL, ORACLE, PL/SQL, PostgreSQL, SQL, Transact-SQL functions

LEAD and LAG are window functions that enable the simultaneous access to a table’s row and to other row related[…]

Read more

Coalesce, NVL, ISNULL, Case, … What should a I use?

January 14, 2019 Database Tips Microsoft Access, Microsoft SQL Server, MySQL, ORACLE, PL/SQL, PostgreSQL, SQL, Transact-SQL functions

There are a lot of options to use when testing for NULL values in SQL. One should use built-in functions[…]

Read more

Using recursive query to find dates without sales

Getting date and time parts from DateTime and SmallDateTime fields

July 23, 2018 Database Tips Microsoft SQL Server, Transact-SQL functions

Microsoft SQL Server supports several data types that can be used to store dates and times. Although some of them[…]

Read more

Database Users and Schemas – concepts and tricks

July 20, 2018 Database Tips Database schemas, Database users, Microsoft SQL Server, MySQL, ORACLE, PostgreSQL

There is some confusion when dealing with some users and schemas. Some DBMS support several schemas per database, while other[…]

Read more