sql-server Archives - Page 13 of 16

Does a foreign key automatically create an index?

I’ve been told that if I foreign key two tables, that SQL Server will create something akin to an index in the child ...

May 6, 2022
0 Comments

Get list of databases from SQL Server

How can I get the list of available databases on a SQL Server instance? I’m planning to make a list of them in ...

May 6, 2022
0 Comments

What is the use of GO in SQL Server Management Studio & Transact SQL?

SQL Server Management Studio always inserts a GO command when I create a query using the right click “Script As” menu. Why? What ...

May 6, 2022
0 Comments

Cannot Connect to Server – A network-related or instance-specific error

I get the following error when trying to connect to SQL Server: A network-related or instance-specific error occurred while establishing a connection to ...

May 5, 2022
0 Comments

How do you specify a different port number in SQL Management Studio?

I am trying to connect to a Microsoft SQL 2005 server which is not on port 1433. How do I indicate a different ...

May 5, 2022
0 Comments

Select columns from result set of stored procedure

I have a stored procedure that returns 80 columns, and 300 rows. I want to write a select that gets 2 of those ...

May 4, 2022
0 Comments

SQL Client for Mac OS X that works with MS SQL Server [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, ...

May 4, 2022
0 Comments

Why use the INCLUDE clause when creating an index?

While studying for the 70-433 exam I noticed you can create a covering index in one of the following two ways. CREATE INDEX ...

May 4, 2022
0 Comments

Should you choose the MONEY or DECIMAL(x,y) datatypes in SQL Server?

I’m curious as to whether or not there is a real difference between the money datatype and something like decimal(19,4) (which is what ...

May 3, 2022
0 Comments

Pad a string with leading zeros so it’s 3 characters long in SQL Server 2008

I have a string that is up to 3 characters long when it’s first created in SQL Server 2008 R2. I would like ...

May 3, 2022
0 Comments