Questions tagged [sql-server-2005]
Use this tag for questions specific to the 2005 version of Microsoft's SQL Server.
sql-server-2005
18,355
questions
17
votes
6
answers
7k
views
How do I Transform Sql Columns into Rows?
I have a very simple problem which requires a very quick and simple solution in SQL Server 2005.
I have a table with x Columns. I want to be able to select one row from the table and then transform ...
42
votes
6
answers
7k
views
Paging SQL Server 2005 Results
How do I page results in SQL Server 2005?
I tried it in SQL Server 2000, but there was no reliable way to do this. I'm now wondering if SQL Server 2005 has any built in method?
What I mean by paging ...
13
votes
5
answers
5k
views
SQL Server 2005 For XML Explicit - Need help formatting
I have a table with a structure like the following:
LocationID
AccountNumber
long-guid-here
12345
long-guid-here
54321
To pass into another stored procedure, I need the XML to look like this:
<...
20
votes
8
answers
11k
views
Have you ever encountered a query that SQL Server could not execute because it referenced too many tables?
Have you ever seen any of there error messages?
-- SQL Server 2000
Could not allocate ancillary table for view or function resolution.
The maximum number of tables in a query (256) was exceeded.
-- ...
26
votes
2
answers
9k
views
Why doesn't SQL Full Text Indexing return results for words containing #?
For instance, my query is like the following using SQL Server 2005:
SELECT * FROM Table WHERE FREETEXT(SearchField, 'c#')
I have a full text index defined to use the column SearchField which ...
15
votes
1
answer
870
views
Client collation and SQL Server 2005
We're upgrading an existing program from Win2k/SQL Server 2k to Windows 2003 and SQL Server 2005 as well as purchasing a new program that also uses 2k3/2k5. The vendor says that for us to host both ...
31
votes
3
answers
12k
views
Why doesn't VFP .NET OLEdb provider work in 64 bit Windows?
I wrote a windows service using VB that read some legacy data from Visual Foxpro Databases to be inserted in SQL 2005. The problem is this use to run fine in Windows server 2003 32-Bits, but the ...
30
votes
14
answers
8k
views
Deploying SQL Server Databases from Test to Live
I wonder how you guys manage deployment of a database between 2 SQL Servers, specifically SQL Server 2005.
Now, there is a development and a live one. As this should be part of a buildscript (standard ...
89
votes
4
answers
52k
views
SQL Server 2005 implementation of MySQL REPLACE INTO?
MySQL has this incredibly useful yet proprietary REPLACE INTO SQL Command.
Can this easily be emulated in SQL Server 2005?
Starting a new Transaction, doing a Select() and then either UPDATE or ...
89
votes
5
answers
97k
views
How to export data from SQL Server 2005 to MySQL [closed]
I've been banging my head against SQL Server 2005 trying to get a lot of data out. I've been given a database with nearly 300 tables in it and I need to turn this into a MySQL database. My first ...