Viewing 9 posts - 916 through 924 (of 924 total)
Hi,
I've also worked in several development environments where 2000 and 2005 have had to sit alongside each other, with no problems.
March 25, 2009 at 9:41 am
Hi,
Could you post the code that you are trying to run and the error that you are getting? This will help us see your problem.
Thanks.
March 25, 2009 at 4:29 am
Hi,
Write a function that takes the parameters needed and returns the value that you require and you can use that function within the Select.
March 24, 2009 at 4:34 am
My thanks to everyone who replied. I've managed to get what I wanted - a rewrite!
It is going to be the SP that I wrote and a slight change to...
March 24, 2009 at 2:28 am
Thanks for the reply to you both.
It needs to be a view because deep within the bowels of a VB system it is geared towards opening a table, and specify...
March 23, 2009 at 8:11 am
Bulk Insert in it's most basic form:
Create a temporary table that reflects the structure of the data you are inserting.
Place the text file you are importing onto a drive that...
March 12, 2009 at 5:54 am
Hi Ashok,
Is the C: drive that you have placed the file onto the same C: drive that SQL Server is using? If your SQL Server is running from another server...
March 12, 2009 at 5:40 am
Hi Shiva,
If you want to import an XML file purely via T-SQL, have a look at these examples:
http://msdn.microsoft.com/en-us/library/ms191184.aspx
http://weblogs.sqlteam.com/mladenp/archive/2007/06/18/60235.aspx
which explains how to import the XML data from...
February 27, 2009 at 2:21 am
Hi Ian,
I have to agree with GermanDBA regarding the speed of the import.
Some time back I had to import large XML files into a 2005 DB with T-SQL, and although...
February 18, 2009 at 3:51 am
Viewing 9 posts - 916 through 924 (of 924 total)