Viewing 15 posts - 1 through 15 (of 107 total)
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
If you run it a million times. In this case here the OP has no 'from' clause so it only executes once. I actually did read your article a...
September 6, 2019 at 2:36 am
A simple Scalar Function will cause the code to take about 7 times longer than either inline code or an iTVF that acts like a scalar function. Please see...
September 6, 2019 at 2:22 am
Micheal,
Unless you're just trying something simple out to learn how to use stored procedures, this should definitely NOT be a stored procedure. Which is it? Just a simple example...
September 6, 2019 at 2:16 am
In any case, if you use them, you still want to ensure you have a GO after the end of your procedure definition.
For parameters, you can use @area as...
September 6, 2019 at 2:13 am
Blake,
I started reading that link.
sp_dropserver <old_name\instancename>;
GO
sp_addserver <new_name\instancename>, local;
GO
I just have a few issues.
August 31, 2019 at 12:47 am
I think I see it now. I created two diagrams. One to show how I think the System Catalog Views, System Views, System Catalog and System tables are related.
Another one...
August 30, 2019 at 10:23 pm
Gerard,
I forgot to consider the possibility of reserved words. Thank you.
August 30, 2019 at 9:54 pm
It is the login used by the connection to the instance. Renaming computers with SQL installed can require multiple steps to ensure that SQL is "synched" with the name...
August 14, 2019 at 12:22 am
Jeff,
I will take a look at the tally function article and see what I can find out. It is probably above my skill level but eventually I will need to...
August 13, 2019 at 1:23 am
Viewing 15 posts - 1 through 15 (of 107 total)