sql-server-2008

相关标签：javascript jquery android 多少钱 iPhone

Running queries against multiple servers?

I am not sure what the best design pattern for this problem is so any suggestions would be greatly appreciated. I have two SQL Servers A (with DBs P,Q,R) and B (with DBs X,Y,Z).[详细]

2023-04-13 07:03 分类：问答
Assign case statement result to variable

When I try to run the following statement, I get this error: \"A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.\"[详细]

2023-04-13 06:51 分类：问答
A Tool for Comparing Result Sets From Stored Procedures Across Multiple Databases - SQL Server 2008

We are updating numerous stored procedures that touch nearly every transaction in our database.What I\'m wondering is if there is a tool out there where we could have it run the two stored procedures[详细]

2023-04-13 05:36 分类：问答
sql foreign key error

i want to create these two tables but i\'m getting an error which says SECTION keys that being referenced by foreign keys of HOLD are not primary key. as it\'s seen in the query they are primary keys.[详细]

2023-04-13 04:39 分类：问答
Updating row in table based on sub query on same table

I have a column in \'tableA\' which i would like to update with the result from the following query. Basically the 5th date column will be the maximum date from the other 4 columns on the same row.[详细]

2023-04-13 04:27 分类：问答
Executing SSIS Package as SQLAgent Job

I have a SQL Server 2008 SSIS job which executes some Win 32 exe files. This job runs fine when i execute the job through BIDS (On Windows 2008 box). Now i have deployed the package in MSDB database a[详细]

2023-04-13 04:26 分类：问答
Row concatenation with FOR XML, but with multiple columns?

I often use queries like: SELECT * FROMThisTable OUTER APPLY (SELECT (SELECT SomeField + \' \' AS [data()][详细]

2023-04-13 04:00 分类：问答
Deleting Related Rows in a Many-to-Many Relationship

I\'m deleting a row in a table that is on one site of a many-to-many relationship. I would also like to delete any related rows on the other side of that relationship.[详细]

2023-04-13 02:35 分类：问答
JOINING comma separated values

I have 2 tables as below: TABLE:CITY CITY_ID CITY ---------------- 1London 2Chicago 3Newyork 4Delhi TABLE:TRAIN[详细]

2023-04-13 02:11 分类：问答
In Sql Server 2008,How to number shipments for each customer

I have two tables : Customer ------>> Shipment I want to give each shipment a unique number for each customer, for example[详细]

2023-04-13 01:17 分类：问答