sturner (7/23/2013)

---

Yeah, there is something sort-of fishy about a design that would incorporate that kind of [il]logic in a trigger. But without seeing more information about this entire design there...

i'd consider rewriting the trigger to support multiple rows by joining to the tables instead .

something like this looks right to me:

edit: Exactly what sturner was thinking. I'm too slow!,...

i think the issue is really that the trigger is not updating anything, right, and not that the trigger does not fire?

my first guess would be that the inner condition...

david.ostrander (7/23/2013)

---

Hello –

I currently have an SSIS package running and the first part of it deletes all data in (Table A) but saves the rows with the PIT of...

well, assuming this section is still in your original script

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N' [product]]') AND type in (N'U'))

note that it is looking for a...

what is the...

well, you are mixing up DML and DDL, and they should be completely seperate steps...first alter the tables if needed, then do your transaction.

something like this, and note i explicitly...

well, i don't have a products table, to alter, and it was not included in your sample script, so here's mny best guesses:

you don't have GO statements after your...

TYPE is a keyword, so you'll need to put it in brackets:

ALTER TABLE product

ALTER COLUMN [TYPE] VARCHAR(25) NOT NULL

all of the DotNet versions install side by side in the %windir%\Microsoft.NET folders, they never overwrite each hooter, so you won't have an issue.

you'll just end up seeing a...

via TSQL, the best answer is no, you cannot install a new SQL instance via TSQL.

it has to be done from the operating system side, with the example parameters supplied...

i think i'd export the tables out to a different database, restore, and then delete and insert back into the original table...but if you've got foreign keys involved, that would...

i would guess it's due to the joins:

bd.SORTUSER_EMPID = ed.[Employee ID]

i think maybe one column is an integer or numeric column, and the other is varchar?

due to data type precedence,...

my concerns mirror steve's;

If this was a suite of web pages i dropped into a virtual folder on my own IIS server, yeah it would probably be a good idea.

If...

for me, it doesn't matter if it's entity framework or an ADO connection or anything else. it doesn't make a real difference in what it's going to do.

in our shop,...