IT Nursery
I am involved in a data migration project. I am getting the following error when I try to insert data from one table into another table (SQL Server 2005):...
I have recently been running into many different areas of SQL Server that I normally don’t mess with. One of them that has me confused is the area of...
How to convert a string to integer using SQL query on SQL Server 2005? 4 Answers 4
I’m writing an SQL Query, where a few of the columns returned need to be calculated depending on quite a lot of conditions. I’m currently using nested case statements,...
SELECT logcount, logUserID, maxlogtm , DATEDIFF(day, maxlogtm, GETDATE()) AS daysdiff FROM statslogsummary WHERE daysdiff > 120 I get “invalid column name daysdiff”. Maxlogtm is a datetime field. It’s the...
We have client app that is running some SQL on a SQL Server 2005 such as the following: BEGIN TRAN; INSERT INTO myTable (myColumns ...) VALUES (myValues ...); INSERT...
I want to get only Time from DateTime column using SQL query using SQL Server 2005 and 2008 Default output: AttDate == 2011-02-09 13:09:00 2011-02-09 14:10:00 I’d like this...
I’ve seen similar errors on SO, but I don’t find a solution for my problem. I have a SQL query like: SELECT DISTINCT a.maxa , b.mahuyen , a.tenxa ,...
I want to update two tables in one go. How do I do that in SQL Server 2005? UPDATE Table1, Table2 SET Table1.LastName="DR. XXXXXX", Table2.WAprrs="start,stop" FROM Table1 T1, Table2...
I can extract the month and day by using Day(Date()), Month(Date()). I can’t extract hours, with HOUR(Date()). I get the following error. 'HOUR' is not a recognized built-in function...