Viewing 15 posts - 31 through 45 (of 146 total)
You don't need VALUES (that's if you're not doing a select for the insert, but instead a list of static values).
INSERT INTO @multiVariable
SELECT ID, fName, address, state FROM baseTableExample;
Just...
February 7, 2020 at 9:22 pm
Thank you. Since my original post, I have determined that each query tab is a session because each tab has it's own unique SPID.
we didn't know that you...
February 7, 2020 at 8:04 pm
Thank you. Since my original post, I have determined that each query tab is a session because each tab has it's own unique SPID.
February 7, 2020 at 3:33 am
Would you believe... both.
If you look at an execution plan that is in row mode, not batch mode, it's actually doing all the commands it does, one row at...
February 1, 2020 at 12:16 am
A CTE is essentially just a materialised view of the data set, so it points to the actual underlying objects used.
This is what I suspected. When you say a...
February 1, 2020 at 12:12 am
MVDBA,
This part of your post really cleared things up for me about what exactly an instance is. Sounds like each time you install SSMS, that installation is called an instance. ...
February 1, 2020 at 12:07 am
That worked. When I do CREATE TABLE or INSERT INTO, the table name doesn't need quotes. How do you know when a table name needs quotes?
January 26, 2020 at 4:30 am
I think I've got it now. Thank you.
January 15, 2020 at 10:35 pm
Thank you everybody. I tried a division by zero to force an error and the CATCH block did execute.
January 14, 2020 at 10:45 pm
November 18, 2019 at 1:57 am
I think you need a new CycleParts table with two columns CycleId and PartId. You need 2 foreign keys on this table. One pointing to the Cycle table the...
November 18, 2019 at 12:59 am
This makes sense. Thank you.
October 13, 2019 at 11:23 pm
You say you were "about" to create a new table. Did you actually try to finish that task?
Thanks for pointing that out. I meant to say I did create...
September 27, 2019 at 5:11 am
I tried another simple stored procedure above, which I executed. It didn't display the results window for the SELECT statement result at this time.
Then I right clicked the procedure and...
September 11, 2019 at 1:03 am
The Visual Studio query editing environment is largely, but not perfectly, the same as writing it in SSMS. The core behaviors are the same. I'd say that people who...
September 6, 2019 at 2:40 am
Viewing 15 posts - 31 through 45 (of 146 total)