<li style="list-style-type: none;">

1. Yes

<li style="list-style-type: none;">

1. Yes, and a lot more. On some Fact tables in data warehouses it's not uncommon to have over 100 foreign keys...

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...

This makes sense.  Thank you.

Thanks for pointing that out.  I meant to say I did create...

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...

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...

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...

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...

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...

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...

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.

1. In the code above, when they say old_name...

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...

Gerard,

I forgot to consider the possibility of reserved words.  Thank you.

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...

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...