I need to write a SQL query to filter a table on 4 potential columns from another table of the filter values.
I am tearing my hair out on this one.Recently (about a month or so ago) some stored procedures we have on our SQL 2000 server stopped sending emails.We have several versions of the same stored proc in
I\'ve got a database running on a clients SQL Server 2000 box where the transaction log file is only 1MB in size. This seems very perculiar.
I\'m struggling with a SQL question.. We use enterprise manager to communicate with SQL Server 2000. Background:
I am using SQL Server 2000. I need to store an image in my database. I am in middle of my analysis that whether I need to create a new table in m开发者_StackOverflow社区y application\'s database or I
Using Microsoft Sql 2000 I have a requirement to be able to email a monthly report that details a number of events.
We have about 150 old style queries and views that use the *= and =* type ANSI92? join. Does anybody know of a tool / method or script that could help with the conversion or do we have to just slog th
I\'m currently using IIS7.5 on Windows Server 2008 R2... I\'ve got it setup to run PhP (5.2.17 AND 5.3), and at some point I had MySQL 5.5 too...
I have two SQL Server machines, server1 and server2 that are redundant and have the same data. My application开发者_开发百科 wants to select data from a table in the msdb database every 1 second. But
I\'m attempting to group contiguous date ranges to show the minimum and maximum date for each range. So far I\'ve used a solution similar to this one: http://www.sqlservercentral.com/articles/T-SQL/71
加载中,请稍侯......