Viewing 15 posts - 1 through 15 (of 155 total)
Indeed, the syntax of the FOR SYSTEM_TIME AS OF clause allows only a constant or a variable, not a column.
To overcome this limitation, you can use a table-valued...
September 10, 2018 at 1:05 am
Hello, McShorty
The problem is indeed a known bug in SQL Server 2000 SP4, but it is not documented in any KB (as far as I know). The bug is fixed...
February 15, 2009 at 1:05 pm
This looks like a homework assignment, and we don't like solving homeworks for others.
See example D in http://msdn.microsoft.com/en-us/library/ms175972.aspx and try to modify it yourself to fit your purpose.
Razvan Socol
SQL Server...
December 29, 2008 at 3:44 am
You can try something like this:
SELECT * FROM (
SELECT * FROM DB1.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='TableA'
) a FULL OUTER JOIN (
SELECT * FROM DB2.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='TableA'
) b ON a.COLUMN_NAME=b.COLUMN_NAME
WHERE a.COLUMN_NAME IS NULL...
December 29, 2008 at 3:37 am
Hello, Albert
Here is my list of SQL version lists:
For SQL Server 2005:
http://www.sqlservercentral.com/columnists/sjones/2960.asp
http://www.aspfaq.com/sql2005/show.asp?id=20
SQL 2008 / 2005 / 2000 / 7.0:
http://sqlserverbuilds.blogspot.com/[/url]
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
SQL Server 2000:
http://www.aspfaq.com/SQL2000Builds.asp
SQL 2005 post-SP2 hotfixes:
http://support.microsoft.com/kb/937137
SQL 2000 post-SP4 hotfixes:
http://support.microsoft.com/kb/894905
SQL 2005 / 2000...
May 8, 2008 at 9:39 am
KB Article 937137 documents the SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released.
Razvan
July 3, 2007 at 2:34 am
Here are some new builds:
9.00.3175 KB936305
9.00.3171 KB937745
9.00.3169 KB937041
9.00.3166 KB936185
9.00.3155 KB933499
9.00.3155 KB933808
9.00.2233 KB933499
9.00.2229 KB935446
9.00.2151 KB904244
9.00.1554 KB926292
Razvan
June 27, 2007 at 11:41 pm
9.00.3033 is the December 2006 CTP for Service Pack 2
9.00.3027 is the November 2006 CTP for Service Pack 2
9.00.2040 is the March 2006 CTP for Service Pack 1
9.00.2027 is Service...
May 29, 2007 at 10:47 am
If you use dynamic SQL, you can use something like this:
DECLARE @String char(20), @stmt nvarchar(500)
SET @String='416E6E61737461736961'
IF @String LIKE '%[^0-9A-F]%' RETURN
SET @stmt='SELECT CONVERT(char(10),0x'+@String+')'
EXEC (@stmt)
And if you want to convert the whole...
May 17, 2007 at 4:56 am
You can either uninstall the KB 932555 hotfix (if you don't use those SSIS features) or contact Sage Software support for an updated version of their software.
Anyway, you should open...
May 3, 2007 at 11:47 am
Cullen,
Version 9.00.2050 is not SP2, it's just a post-SP1 hotfix. SP2 is 9.00.3042
Razvan
May 3, 2007 at 11:12 am
The script posted in this article should come with a big warning: "The xp_delete_file procedure is undocumented and therefore unsupported!".
Here is what a MS employee (Terrence Nevins, SQL Server...
April 18, 2007 at 2:17 am
Here are 4 new hotfixes (april 2007), for the same problem (regarding scripts in SSIS):
- post-SP1 hotfix version 9.00.2221, downloadable from KB article 931593.
- post-SP1 hotfix version 9.00.2050, KB...
April 11, 2007 at 2:31 am
Peter, the following code:
select cast(cast(getdate() as int) as datetime)
will give incorrect results if the time is in the afternoon.
However, the code that Simon wrote:
July 20, 2006 at 2:05 am
Nice work, R2ro! It seems that your function is the best, so far. Here are some timings (in ms) for the three versions (counting the rows in the result, for the...
July 20, 2006 at 12:28 am
Viewing 15 posts - 1 through 15 (of 155 total)