For questions specific to the 2005 version of Microsoft's SQL Server.
3
votes
4answers
821 views
Reverse the order of words in TSQL
I would like to know how (if it is possible) to reverse the order of words returned from a TSQL string (varchar).
I know about the TSQL REVERSE function but the also reverses the letters in the word ...
0
votes
1answer
10 views
Update trigger inserts a new record but the insert trigger will not fire
SQL Server 2005 or 2008:
I have an UPDATE trigger that will insert a new record into the same table only if a certain status field is changed.
The new record does get created properly so the UPDATE ...
1
vote
1answer
23 views
Membership SHA1 hash not the same for all users
I have a user table that was in plain text and migrated it to Membership provider.
Using ColdFusion (current system) I managed to HASH one user's password (test user) and it matched perfectly. But ...
17
votes
8answers
7k views
SQL Server Temp Tables and Connection Pooling
I have a multi-user ASP.NET app running against SQL Server and want to have StoredProcA create a #temptable temp table - not a table variable - to insert some data, then branch to StoredProcB, ...
0
votes
2answers
39 views
Copying from one “not null” column to another gives a “Cannot insert null value into column.”
I'm currently trying to copy all data from one table to another as the second table is ordered a bit differently I'm using the following SQL script to do so:
USE LoanersTest
DROP TABLE LoanerItems1
...
0
votes
1answer
13 views
MSSQL 2005 Query to insert value as bonus on the current value?
I've got a table with column Points in it. Players at the moment have points but I want to add to all players +100 Points to their current ones. How the SQL query will look like ?
Thank you.
0
votes
3answers
26 views
how to copy top 1000 records from 7000 records in existing table to other new table
I have a table A which consists more than 7k records,Now i am creating a new table B .In my new table B I need to copy only 1000 records from table A which has more than 7000 records.
No condition ...
0
votes
0answers
15 views
Sporadic connect errors from PHP to MS SQL
I am working on a site written in PHP (running on a Windows Server under Apache) with MS SQL Server 2005 as database (on another Windows Server).
This error occurs sporadically when running ...
4
votes
3answers
6k views
Copy entire database contents (schema and data)
I need to copy the contents (tables, views, procs, DATA, etc.) of a SQL Server database and copy it to another SQL Server database. I need to do this entirely in a script as I am not able to carry ...
0
votes
2answers
27 views
Unsure as to how to join two working queries together
I have two queries that function perfectly. I'd like to join the two queries together, but I can't figure out how to do this.
I have an SQL Server table structured as follows :
Table name : ...
1
vote
4answers
11k views
How to open .mdf and .ldf files?
How to open .mdf and .ldf files ?
These files were created using SQL 2005. I just installed SQL 2008.
I am unable to open this file. What am I am missing here ?
-1
votes
2answers
19 views
Data from remote mssql server to my(own) mysql server
I would like to get data from remote MSSql server to local MySql server. The MSSql server would be populated automatically by the third party I just want to get that data from the database to my mysql ...
1
vote
2answers
63 views
LEFT JOIN Significantly faster than INNER JOIN
I have a table (MainTable) with a bit over 600,000 records. It joins onto itself via a 2nd table (JoinTable) in a parent/child type relationship:
SELECT Child.ID, Parent.ID
FROM MainTable
AS ...
7
votes
5answers
15k views
Linking Users to Login after restoring a SQL Server 2005 database
I wish to move a database between two servers, I have backed the database up from the first server and done a database restore on the 2nd server, so far so good.
However our application make use of a ...
3
votes
3answers
4k views
how to parse xml with special character in sql server
I am getting following error when i add < in my xml,
Msg 9455, Level 16, State 1, Line 6 XML parsing: line 4, character 14,
illegal qualified name character
How can i parse xml with these ...
