Viewing 15 posts - 2,071 through 2,085 (of 5,109 total)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 11, 2018 at 1:48 am
It's a truncation error, not a conversion. Increase the size of the Length, it seems 50 is not large enough. Assuming it is mapping to ENTERVALUE, it's (about) 462 characters...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 10, 2018 at 2:56 pm
Yes, just set the font size on that column. Have you tried?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 10, 2018 at 11:20 am
Sounds like you need a Calendar table: http://www.sqlservercentral.com/articles/calendar/145206/
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 10, 2018 at 8:19 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 10, 2018 at 8:08 am
Thanks for this. Yes this was old legacy 2000 databases! Will explain this then.
Thanks...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 10, 2018 at 7:54 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 10, 2018 at 7:51 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 10, 2018 at 7:40 am
Are you sure Sharky? I just ran the following on SQL Server 2012 (SP4-GDR) (KB4057116) - 11.0.7462.6 (X64), Microsoft SQL Server 2008 (SP4-GDR) (KB4057114) - 10.0.6556.0 (Intel X86) and Microsoft SQL...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 10, 2018 at 7:23 am
Sample data in the form of an image isn't very helpful, most of the time. Other people can't interact with it; you can't copy the text and create a table...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 10, 2018 at 7:18 am
Welcome to SSC. You might want to respond to the comments on the identical question you posted on StackOverflow though, rather than posting a new topic on a different website:...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 10, 2018 at 5:07 am
What do you mean "run the file"? You don't "run" an mdf file, you attach it to a SQL Server Instance. Is that what you're trying to do?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 10, 2018 at 3:45 am
I'm not really sure what you mean by "Will it Recursive?". Do you mean, will it end up self triggering? If so, no; the trigger is on TABLE1...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 10, 2018 at 3:33 am
Do you need to retain the old ID? If not, then simply exclude it from your list of columns in your INSERT and the new table will give the email...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 9, 2018 at 11:52 am
I doubt you really need an application to do this. Getting the last (full) backup date for a database, for example is quite simple:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 9, 2018 at 11:49 am
Viewing 15 posts - 2,071 through 2,085 (of 5,109 total)