Hi!Thank you for trying! But This isn't truly a comma delimited file (like a CSV). The number of commas varies for each row and there's that slash mark in there that indicates the logical end of the record (not the physical end), so using DTS or Bulk Insert isn't an option. I thought about that, […]
2004-09-05
It sounds as if the actual generation of the Identity is not in the scope of the call to SQL Server. For example (since I know nothing of the structure of the interface) assume a call to a stored procedure that verifies data, then makes a call to a second SP to perform the actual […]
2004-05-11
How could I copy several tables from one owner to other in the same database ????? I have a database with around 150 tables with constraints checking several relationships, indexes, etc. (but without store procedures) I want to copy all of them to other owner (that I already have), in this case the destination owner […]
2004-05-11
1 reads
I have a case like this:table a - has one filed with statusIDtable b - has one filed with statusIDc - status code tbl - statusID(int,4), status Decription (char, 20)When I want to pull the description for the statuses I have in "a" and "b" for a particular custID (they will be always different) I could use:select * from a […]
2004-03-24
3 reads
HiFor my project i am trying to create an online registering system. The users enter all of the required info through the form it is then handled on the server by asp scripts.I have to tables resident and householdresident table:----------------------------------------Personal_ID (PK) | Name | DOB | Household_ID Household table:----------------------------------------Household_ID (PK) | Address | Post Code The problem i […]
2004-03-04
2 reads
After adding your account to the group you just have to log off and then log on in the client. Also, make sure you have the same Service Pack on both the server and the client.
2003-12-17
Oops. Was that QOD 26/11 was it? And there's already a thread discussing it? And it's already been adequately explained? I'll just crawl back under my rock and hope the site administrators will delete this totally useless thread. Cheers, - Mark
2003-11-26
1 reads
brianr - just type CHECKPOINT into QA I had a similar issue recently so I ended up writing milestone messages to a dummy table rather than using PRINT. I could then query the table (using WITH (NOLOCK) for good measure) so see how far things had progressed
2003-07-24
1 reads
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-23
i would suggest you add two more new columns to your source table DateCreated and DateModified. first time you dump all the records from source to destination. later you can store the maxdate of datecreated column destination table somewhere and look for records that are added after that date in the source . sameway you […]
2003-06-19
1 reads
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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