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.
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...)
When I tried to add html to data for my GridView control, I could only see html code. I could see "<span class="myhtmlclass">my text</span> from SQL request</span>. But I wanted to wrap my content with <span> tags. (read more...)
Field with autoincrement is very useful thing and it's often used in MySQL. In MSSQL you can also need to use this tool. There are two ways to do it. (read more...)
When I wanted to get the ID of clickable element using jQuery, I have found out that I don't remmember such a simple thing. I had to look for it. And I've found it 🙂
I had buttons with class "phonebtnCall" and some IDs. I wanted to know which of buttons was clicked. (read more...)
When user tells you that he has got an error using SharePoint portal service, you ask him about the page he was, which buttons he clicked and, if user hasn’t still closed browser, ask to send you screenshot of the error. It contains very useful information – CorrelationId. (read more...)
