Forum Replies Created
Viewing 15 posts - 76 through 90 (of 5,109 total)
-
Reply To: Return a set of rows between 2 values (multiple times)
So where do these linked integers come from? Why, for example, is
1linked to1,2, and3, but the numbers8to14only linked to8?Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Reply To: Are the posted questions getting worse?
Shifting gears a bit, I'm hoping this year that work will be happy to pay (or at least contribute) to me getting out and going to some SQL based events...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Reply To: how to make a col in a table after checking its existence, in one stmt
I can barely read those images, so I'm not sure what it's trying to show anyone. Can you elaborate?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Reply To: Are the posted questions getting worse?
Jonathan AC Roberts wrote:What I find extremely frustrating is when someone writes SQL code that joins multiple tables without prefixing the column names with their originating table or alias using dot notation....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Reply To: Are the posted questions getting worse?
Jonathan AC Roberts wrote:What I find extremely frustrating is when someone writes SQL code that joins multiple tables without prefixing the column names with their originating table or alias using dot notation....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Reply To: Are the posted questions getting worse?
I will admit, and though I know it shouldn't, it does amuse me when I see code that has something like this:
SELECT *
FROM dbo.MyTable MT ;WITH (NOLOCK)
...Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Reply To: Are the posted questions getting worse?
Brandie Tarvin wrote:Forget leading commas. Let's debate leading semi-colons. @=)
.Please no >_< .Leading commas I accept as a preference, but leading semicolons are another matter entirely, lol .Those are like starting...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Reply To: how to make a col in a table after checking its existence, in one stmt
No, there is no syntax to
ALTERa table andADDcolumn only if it doesn't exist, and (presumably)ALTERthe column if it does like, for example,CREATE OR...Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Reply To: Can an INSERT statement block SELECT statements?
Just to prove Grant's statement a little more, here's a quick demo.
So you can see that the first
SELECT, which wants rows on or after the current...Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Reply To: Can an INSERT statement block SELECT statements?
Just to prove Grant's statement a little more, here's a quick demo.
So you can see that the first
SELECT, which wants rows on or after the current...Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Reply To: Ownership chaining
This implies that the ownership chain is being broken somewhere; the point of ownership chaining is that you don't need to give explicit access to the objects. Who are the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 15 posts - 76 through 90 (of 5,109 total)