Viewing 15 posts - 361 through 375 (of 3,232 total)
crookj (8/13/2010)
Speaking of Jason.....I heard that Michael Myers (Halloween) wore a Cpt James T Kirk mask that was painted white. Anyone else here this?
Joe
True. I've heard that before too....
August 13, 2010 at 3:20 pm
Ray K (8/13/2010)
CirquedeSQLeil (8/13/2010)
ch ch ch ch (softly - name that theme music)Friday the 13th. (Where's Jason?)
My thoughts exactly!
August 13, 2010 at 11:46 am
David Benoit (8/12/2010)
Ray K (8/12/2010)
David Benoit (8/12/2010)
Ray K (1/12/2010)
In perusing these forums, I'm noticing a great deal of geographic diversity (which...
August 12, 2010 at 10:16 am
The statement you provided will delete from table1 only.
August 6, 2010 at 11:50 am
Brandie Tarvin (8/6/2010)
John Rowan (8/6/2010)
Brandie Tarvin (8/6/2010)
Drain Bramage!I wonder how many people will recognize where that phrase came from. @=)
I've been using it so long, I can't pinpoint where it...
August 6, 2010 at 10:54 am
Brandie Tarvin (8/6/2010)
Drain Bramage!I wonder how many people will recognize where that phrase came from. @=)
I've been using it so long, I can't pinpoint where it was. Was it...
August 6, 2010 at 9:38 am
You should delete all rows from one table, then all rows from the next, and so forth until you've cleaned out your tables. If you are nervous, do it...
August 5, 2010 at 1:37 pm
There is a property that you can set up on foreign keys that will allow for cascading deletes which is off by default.
But to make sure, I'd have to delete...
August 5, 2010 at 1:23 pm
Ah, your ClientID column needs cast.
INSERT INTO ClientAlias(ClientAlias,ClientID,defaultalias,enrolled)
SELECT Clients.Name + ' (' + CAST(Clients.ClientID as varchar) + ')' as ClientAlias,
Clients.ClientID,
...
August 5, 2010 at 12:48 pm
My bad.....replace the & with +......
INSERT INTO ClientAlias(ClientAlias,ClientID,defaultalias,enrolled)
SELECT Clients.Name + ' (' + Clients.ClientID + ')' as ClientAlias,
Clients.ClientID,
...
August 5, 2010 at 12:42 pm
Well, the first step is deleting data is identifying which data you want to delete. When you have to delete related data from several entities, you need to write...
August 5, 2010 at 12:39 pm
Right, but nowhere in your code do you reference the target databases (outside of your print statement). Your DELETE statement needs to reference the target database name using the...
August 5, 2010 at 10:27 am
It's because you are connected to your master DB. Build out your SQL statement to reference your table with databasename.schemaname.tablename.
August 5, 2010 at 10:18 am
Viewing 15 posts - 361 through 375 (of 3,232 total)