Hello, PLEASE GIVE ME A SOLUTION IM AM USING SQLSERVER 7.0 i have a table which contains the following fields namely refererid,code,name this is just like a referral program a guy can refer 3 guys under him i.e, 3 is referring three guys namely 4 5 8 similarly 4 is referring 9 10 and 11 […]
2002-02-28
2 reads
I am looking for a good way to store heirarchical data. e.g. for Customer data I want to provide my users with a tree view of customer groups that they can customise, and store the path of each customer. I have thought about using a pathing system, with a separator (e.g. "\") and filtering the […]
2002-02-13
2 reads
I have a CSV file of 105k records that when I used DTS, BCP or BULK INSERT the data does not import correctly. The file is formated like ,,,"text",,"text" and so on.. when building a DTS Package I select the row as LF and the Text Deliminator as " and I immediately get a message […]
2002-02-13
4 reads
Discussion, comments, and ratings of items posted to SqlServerCentral.com by Neil Jacobson
2002-02-10
5 reads
How can I add a field to a table after a specific other field? I've tried this but it doesn't work: alter table [mydatabase].[dbo].[tablename] add [Newfield][bit] DEFAULT 0 NOT NULL AFTER [Oldfield]
2002-02-08
1 reads
Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it!
2002-02-06
9,321 reads
I am getting ready to do an upgrade of a fairly large ASP app from 6.5 to 2000. And I was going through a list of the reserved words and found out that catalog is going to be a reserved word in the future release of 2000 SPs. Now this table is a very important […]
2002-02-04
Hi I want to update a table from one server to another server.in my Location i am having a server Name : PROD84 and there is another server in Chicago Server Name: Dev34 i am working on PROD84 Server, i mapped Linked Server DEV34 then i am able to see the Table EMP In my […]
2002-01-30
3 reads
Can anyone tell me why a trigger would not fire when a table is updated from an app, when it fire OK when the same table is updated from query analyser? A similar trigger (generated from the same code)on another table, fires in both instances. I have checked the NOCOUNT is on, and the user […]
2002-01-29
XML support in SQL Server lives up to the hype that's always surrounded XML. Using SQL Server 2000, you can send queries over HTTP, save XML records to the database, and retrieve records via XML. This article shows how you can take advantage of these features in SQL Server 2000 by building a database entry system that keeps track of sales and customer information.
2002-01-28
1,740 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers