The difference between WHERE and HAVING filters in Transact-SQL queries is that WHERE clause is a filter of all the data, while HAVING filters the GROUP BY data. I’ve prepared a simple example.
The cursors in MS SQL Server are not the best way to manipulate the data, because they need more recourse. If you can escape the usage of cursors, do it. OK, the cursors give us a flexible way of manipulating the information. You can imagine a bundle of information, that we use for move through [...]
My ex-colleague asked me how to insert query result in a variable for generate report in Microsoft SQL Server. After few explanations I noticed that she has decided to use SSIS (SQL Server Integration Services) to automate. She sent me an example in which she uses YEAR(), MONTH() and DAY() functions.
I was interested of the different SQL “accents”. According to Microsoft SQL Server learning books, we query like this:
SELECT
*
FROM
table1 INNER JOIN table2
ON table1.PK = table2.FK
GO
I use Windows XP and I’m not sure when I’m gonna start using Windows 7. That’ s why I have installed it on a Virtual PC for quick preview. Today I found a post and I Googled it as “Windows 7 God Mode” to check what’s going on :-)
It looks like very smart hidden tool [...]
I have e-mail accounts, forum or blog accounts, banking accounts, BIOS and many more passwords. Several months ago I decided to collect all these passwords in a file. The idea of storing them in Excel file I realised as not so good and I asked for software, that encrypts my data. I found very cool [...]