Viewing 15 posts - 2,521 through 2,535 (of 3,655 total)
In SQL2000 ROWCOUNT affects all actions, TOP only affects SELECT
In SQL2005 TOP can be used with UPDATEs etc.
Joe Celko has warned me that TOP is not valid ANSI SQL and...
January 18, 2006 at 1:23 am
Drag the ActiveX Script task onto your design pane then double-click it.
Copy and paste the code from the post into the resulting code panel and save it.
Select the ActiveX task...
January 17, 2006 at 11:08 am
I'm not talking about the infestation known to MS Access programmers as cascading.
I have inherrited a database whose lookup tables would give DCPeterson apoplexy. The design was done by...
January 17, 2006 at 9:29 am
In general I agree with this article but there is one massive BUT that has been overlooked here and that is performance.
I have a database where the design of the...
January 17, 2006 at 5:18 am
I have a similar requirement for a date changed Excel file. There are several ways of doing it but I put an ActiveX task as the first step...
January 17, 2006 at 2:13 am
Because of the limitations of the FTP task I resorted to using a Windows CMD file to execute the FTP commands I needed and called these using an Execute Process...
January 16, 2006 at 5:09 am
The idea is that you get a performance boost however in most small to medium installations the extra administrative hassle just isn't worth it.
The theory is that searching an index...
January 13, 2006 at 12:00 pm
Our apps are .NET and C++ based so we use NUNIT to devise a long list of test scripts. Come service pack time we simply rerun the NUNIT...
January 13, 2006 at 6:16 am
You should have
an Icon for a server that represents you connection to your SQL Server.
An Icon for your text file that represents you CSV file.
A connecting line between the...
January 12, 2006 at 10:39 am
Are you allowed to change your database recovery mode to BULK LOGGED?
January 12, 2006 at 4:33 am
DTS's can be as simple or as complex as you want.
You can import/export from/to a variety of different sources. For example, I had a datawarehouse that needed to almagamate...
January 11, 2006 at 12:29 pm
Just for the sake of testing change your INSERT INTO query to SELECT INTO TestTable
That way
INSERT INTO MarketRiskdev.dbo.Import_Argentina
SELECT * FROM TestTable
should work. If it doesn't you will be closer...
January 11, 2006 at 12:01 pm
bcp is very fast at extracting or importing data.
As Data Transformation Services suggest they can do just about anything you want to data. DTS includes a specific task that...
January 11, 2006 at 11:57 am
I'm just wondering why you are using SQL Query Analyser to do this?
Is is just for a quick one off?
If you have to do it more regularly then consider using...
January 11, 2006 at 11:54 am
Recognition, visible results, the desire to fund a decent mid-life crisis.
January 11, 2006 at 5:50 am
Viewing 15 posts - 2,521 through 2,535 (of 3,655 total)