Category Archive: T-SQL

Aug 21 2016

Learning SQL Server Data Tools (SSDT)

If you want to learn the SQL Server Data Tools (SSDT) I definitely recommend watching the Pluralsight course Visual Studio Data Tools for Developers. It is a 3 hours long course from Deborah Kurata that provides a great introduction to it. SSDT is a collection of tools for developers that helps you to work with SQL Server inside …

Continue reading »

Permanent link to this article: http://www.andreaangella.com/2016/08/learning-sql-server-data-tools-ssdt/

Jun 02 2014

Stored Procedure to Calculate Expressions

I was reading the section Character Functions in the Chapter 2 of the book Querying Microsoft SQL Server 2012 and pretty soon I get bored of trying individually the various functions on strings available in T-SQL. Then, I challenged myself to write a stored procedure (this is my first one) to evaluate an arithmetic expression with …

Continue reading »

Permanent link to this article: http://www.andreaangella.com/2014/06/stored-procedure-to-calculate-expressions/