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): Msg 8152, Level 16, State 13, Line 1 String or binary data would be truncated. The source data columns match the data type and are within … Read more
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 Logins and Users. Seems like it should be a pretty simple topic… It appears that each login can only have 1 user and each user can … Read more
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, but its getting messy. Is there a better (more organised and/or readable) way? (I am using Microsoft SQL Server, 2005) A simplified example: SELECT col1, col2, … Read more
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 little stuff that drives me crazy. 9 Answers 9
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 INTO myTable (myColumns …) VALUES (myValues …); INSERT INTO myTable (myColumns …) VALUES (myValues …); COMMIT TRAN; It is sent by one long string command. If … Read more
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 output: AttDate Time == 2011-02-09 13:09:00 13:09 2011-02-09 14:10:00 14:10 18 Answers 18
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 , b.tenhuyen , ISNULL(dkcd.tong, 0) AS tongdkcd FROM phuongxa a , quanhuyen b LEFT OUTER JOIN ( SELECT maxa , COUNT(*) AS tong FROM khaosat WHERE CONVERT(DATETIME, … Read more
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 T2 WHERE T1.id = T2.id AND T1.id = ‘010008’ 10 Answers 10
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 name. How can I extract hours? 12 Answers 12
