sql-server
Jboss - Strange exception after auto-reconnecting to XA datasource
I\'m using a XA datasource on Jboss 6, using <check-valid-connection-sql> and <background-validation-millis> to auto-reconnect when one of the connections is dead. This works, but the prob[详细]
2023-04-12 22:33 分类:问答What happens to Jobs scheduled when SQL Server Agent is stopped?
On our SQL Server theres a SQL Job which is ran every hour. On one particular hour it doesn\'t seem like the SQL Job was ran, and that was due to the SQL Ser开发者_运维知识库ver Agent being stopped du[详细]
2023-04-12 22:25 分类:问答How to limit number of concurrent file downloads for the number of requests?
I ha开发者_如何学Pythonve created an MVC.Net application and there is a download page from where users can download the setup file of approx 5MB in size. This setup file is generated dynamically when[详细]
2023-04-12 22:16 分类:问答SELECT COL1+COL2 as CalcColumn,* FROM TABLE WITH (NOLOCK) WHERE 100<COL1+COL2
In a SELECT statement using a condition based on a calculated value, is it possible to include that calculated value without computing the calculated value twice - o开发者_开发知识库nce in the selecti[详细]
2023-04-12 21:55 分类:问答Entity Framework / SQL Server strange decimal division behaviour
I have a table in my SQL server 2008 R2 database which includes two nullable decimal(16,6) columns.Let\'s call them column1 and column2.[详细]
2023-04-12 21:30 分类:问答TSQL - Return recent date
Having issues getting a dataset to return with one date per client in the query. Requirements: Must have the recent date of transaction per client list for user[详细]
2023-04-12 21:19 分类:问答Distinct across similar records in SQL Server 2008 database
I have a SQL Server 2008 database. This database has a table called Product, Order, and OrderProduct. These three tables look like the following:[详细]
2023-04-12 20:34 分类:问答SQL Server / ODBC scrollable result set performance
I\'ve got an application connecting to a SQL Server database via ODBC, and providing query functionality through a Web interface. In order to map the datab开发者_StackOverflow中文版ase onto our web fr[详细]
2023-04-12 20:22 分类:问答Convert SQL Server T-SQL wide result to readable text format
I have the f开发者_如何学Goollowing T-SQL (SQL Server 2008) and I need to email the result using database mail.[详细]
2023-04-12 20:18 分类:问答How to run (execute) .sql file in SQL Server 2005? [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, references,or expertise, but this question will likely solicit debate, a[详细]
2023-04-12 20:04 分类:问答