Viewing 15 posts - 2,281 through 2,295 (of 3,221 total)
I have used the OPENROWSET command to export data from a 2000 DB to a CSV file using this code:
--OPENROWSET to Text file From DB table to text file.
--Text...
November 27, 2009 at 2:10 pm
John Paul-702936 (11/27/2009)
--------------------------------------------------------------------------------
Please .......Pleaseeeeee
Reply Please ........................
Bitbucket did. What about his reply (which did answer your question on deleting records in related tables) was not sufficient?
--------------------------------------------------------------------------------
Gail Shaw
My guess it the...
November 27, 2009 at 1:19 pm
The table can be modified to allow for cascading deletes which is discussed in BOL at:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/54ca1d10-5106-4340-bde4-480b83e7e813.htm
Read carefully the reference in its entirety. As noted if 3 or more tables...
November 27, 2009 at 11:45 am
Duplicate posting at:
http://www.sqlservercentral.com/Forums/Topic825684-1291-1.aspx
Please answer in above forum
November 27, 2009 at 11:30 am
TheSQLGuru
Thank you for the rcommendation.
November 27, 2009 at 11:16 am
Trying using Books On Line (BOL) the help file for SQL server. You will find a listing of 20 such items. Select the one you want and read.
November 27, 2009 at 7:52 am
ashok
CREATE TABLE #Books(BookName VARCHAR(20), Price MONEY, Author VARCHAR(50))
INSERT INTO #Books
SELECT 'C++', 150, 'kanithkar' UNION ALL
SELECT 'C++', 150, 'kanithkar' UNION ALL
SELECT 'C#', 150, 'kanithkar' UNION ALL
SELECT 'Net', 250, 'smith' UNION ALL
SELECT...
November 26, 2009 at 10:51 am
How are you doing the import from the Excel spread sheet.? Using SSIS or a T-SQL statement using OPENROWSET, Bulk copy?
November 26, 2009 at 9:19 am
Garadin
Perhaps, no, I was off base, having only experimented with 6 and 8 characters in the random string. For grins and giggles and to help some other OP...
November 23, 2009 at 6:35 pm
Garadin
And even though these random string generators may be very good for what they do, none of them get you out of having to do a loop to create...
November 23, 2009 at 3:07 pm
[Dave Ballantyne (11/22/2009)
--------------------------------------------------------------------------------
Here's another method (requires 2005+)
Heh... I always have to laugh at articles like that... they talk about performance and "better" ways to do things but they all end...
November 22, 2009 at 4:26 pm
MissyDaisy modify your T-SQL as:
--Your T-SQL
select distinct top 10 customerid, NTILE(10) OVER(ORDER BY CustomerID ) from @SampleInput
--Modifed T-sQL
select distinct top 10 customerid, NTILE(10) OVER(PARTITION BY customerID ORDER BY CustomerId...
November 22, 2009 at 10:40 am
Sharul Nizam
Is your question about how to use that fantastic function developed by
Lynn Pettis ? Assuming it is here is a start .
If it is to insure the string...
November 22, 2009 at 8:36 am
Now I do not really know why you are doing these calculations, but you could add one more item to the code to give you an overall view of the...
November 20, 2009 at 4:01 pm
Is this what you mean?
CREATE TABLE #T(tmessage VARCHAR(200))
INSERT INTO #T
SELECT 'Short' UNION ALL
SELECT 'Longer' UNION ALL
SELECT 'Even a longer message' UNION ALL
SELECT 'A realy realy realy extra long message'
select SUM(200...
November 20, 2009 at 3:32 pm
Viewing 15 posts - 2,281 through 2,295 (of 3,221 total)