This post is about which string functions there are in Transact-SQL. They allow to modify data you have, make custom queries to select records from database tables. To know them is very important for any developer – using string functions is very good way to decrease load from application server without adding it to SQL because […] Read more»
Another way for using conditions in Transact-SQL besides IF…ELSE is CASE operator. The syntax is some different from IF…ELSE but in some cases more readable. CASE also uses the word “THEN”. Read more»
On Microsoft.com you can download Microsoft® SQL Server® 2012 Express. It’s a free software for home use – education, tests or something like this. When you click “Download” link on a page http://www.microsoft.com/en-US/download/details.aspx?id=29062, you can see a list of versions for downloading. Which one to choose? Read more»
In this post I will write about SQL conditions. It seems to me that construction “IF … ELSE” you can find in any language. Transact SQL is not exclusion. Let’s see IF … ELSE in action on the sample below. Read more»
There are two functions for converting SQL data types from one to another. They are CAST and CONVERT. The second function is the best solution for converting datetime to format you need. Read more»
There are several ways to make a copy of database table in MS SQL Server. I write down some ways to make a copy of table. Which way to choose is your choice according to table structure, indexes and your wish to make something manually. Read more»
I don’t often use SQL queries but sometimes I have to. And every time it’s the same – I use search engines to find documentation, especially about work with datetime fields. During these readings I found out at least 3 ways to select records with date I need. Read more»
I was creating a simple tool to work with database table. When I coded a part of updating table records I got some errors. One of them was: Fixing C# and GridView error – String or binary data would be truncated. The statement has been terminated Read more»
Below I described two string javascript functions that I often forget. Read more»
It’s good to be dbowner in MS SQL server, but it’s easy to forget about permissions for other users. I created a procedure and tried to execute it from technical account. And I’ve got the error that user can not execute procedures. Read more»
