Viewing 15 posts - 1,021 through 1,035 (of 5,109 total)
In other news, what do you do when 2 CLI languages for your OS's isn't enough: Introduce a third: https://devblogs.microsoft.com/commandline/introducing-windows-terminal/
I admit I haven't read too far into it, but I...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 7, 2019 at 1:05 pm
Are you familiar with the book mentioned? I need to import data from MySQL db. Database n table is created as you can view in ssis screenshot. I cant...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 7, 2019 at 10:28 am
What you're after here is SQL Server Agent. The documentation will likely tell you everything you need to know. I suggest having a read and a go yourself first,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 7, 2019 at 10:21 am
Testing some other words, in case it's the fact that it's the word user
Table:
My Column: [My Column]
[My Column]
Values: [values]
[values]
Edit: Looks...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 7, 2019 at 10:09 am
I'm surprised that select * from user is even working. USER is a Reserved Keyword in SQL Server, and (Ideally) shouldn't be used for object names. If you have...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 7, 2019 at 9:30 am
I didn't see the need to add a comment. The other answer is shown as accepted with multiple positive votes. The bad answer has now 2 negative votes (one...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 7, 2019 at 8:04 am
Like the article. I'd like to point to the fact that "PRINT @sql;" is limited to 4000 characters, therefore I use "SELECT CAST('<root><![CDATA[' + @sql + ']]></root>' AS XML)".
I...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 7, 2019 at 7:55 am
Ahh, if that's the format and requirement, then this is a more "complete" solution (assumes that the ID column will always be called Id) that inserts the data into the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 3, 2019 at 8:42 am
So, assuming I understand correctly, your data looks like this:
CREATE TABLE dbo.ETLData (ROW_NUM int,
...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 3, 2019 at 8:16 am
Hello, Data are in a sql Server table. I used excel just for illustrate my issue.
So the data is stored in a delimited format in your Table? This sounds...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 2, 2019 at 9:15 pm
They must also be pre-Windows 7. I believe that's when the snipping tool was first included in the OS.
I hope not, anyone me older than Windows 7 is...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 2, 2019 at 8:43 pm
Your data looks like a odd mix of an excel file and a CSV. If you were sticking to one technology this would actually be easier. Phil raises some good...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 2, 2019 at 6:45 pm
Coalesce() with two arguments is equivalent to IsNull() ... might as well save yourself some typing
Actually, Phil, I feel I need to correct you on that one. ISNULL and...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 2, 2019 at 4:15 pm
Have you ever encountered some code that makes you feel that you need wine instead of coffee to fix it? Or is it just me? I'm working on a...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 2, 2019 at 2:32 pm
Out of interest, why not use the GUI? Looks like your statement should be this though:
SELECT @SQL = '-SQL ''RESTORE DATABASE ' + DatabaseName + ' FROM...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 2, 2019 at 10:50 am
Viewing 15 posts - 1,021 through 1,035 (of 5,109 total)