sql-server Archives - Page 31 of 39

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

Why doesn’t the following work? SELECT name FROM (SELECT name FROM agentinformation) I guess my understanding of SQL is wrong, because I would ...

I want to update the top 100 records in SQL Server. I have a table T1 with fields F1 and F2. T1 has ...

I have the below error when I execute the following script. What is the error about, and how it can be resolved? Insert ...

How do you return 1 value per row of the max of several columns: TableName...

I am using SQL Server 2008 Management Studio and have a table I want to migrate to a different db server. Is there ...

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

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

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

Is it possible to specify a condition in Count()? I would like to count only the rows that have, for example, “Manager” in ...