Blog

ImagePrint

How do I rotate a picture?

Often you need to rotate a picture when you are working with digital content that will be published on different websites.  You may need to adjust a photo for several reasons. The default orientation of a photo depends on how the photo was originally taken. Most mobile phones use vertical (portrait) orientation. Desktop computers, on […]

Microsoft SQL Server

MS SQL: Defining Constants in Transact-SQL

Transact-SQL does not offer a good way to support constants in your stored procedures or userdefined functions. This means that you either can choose to hardcode your constants or, the more elegant way, define a userdefined function for each “constant” value. To ensure optimal performance, the schemabinding keyword should be used. Here is an example: In your stored procedure […]

Back To Top