Viewing 15 posts - 3,076 through 3,090 (of 13,469 total)
sturner (7/23/2013)
July 23, 2013 at 1:05 pm
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!,...
July 23, 2013 at 11:53 am
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...
July 23, 2013 at 11:44 am
david.ostrander (7/23/2013)
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...
July 23, 2013 at 10:34 am
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...
July 23, 2013 at 9:34 am
riya_dave (7/23/2013)
i created 2 different script ,i run first thats alter table and add new column
then i am running another that insert and update table
still getting same error
what is the...
July 23, 2013 at 9:15 am
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...
July 23, 2013 at 8:55 am
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...
July 23, 2013 at 8:01 am
TYPE is a keyword, so you'll need to put it in brackets:
ALTER TABLE product
ALTER COLUMN [TYPE] VARCHAR(25) NOT NULL
July 23, 2013 at 7:52 am
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...
July 23, 2013 at 6:27 am
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...
July 23, 2013 at 5:19 am
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...
July 23, 2013 at 5:08 am
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,...
July 22, 2013 at 12:15 pm
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...
July 22, 2013 at 9:41 am
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,...
July 22, 2013 at 6:30 am
Viewing 15 posts - 3,076 through 3,090 (of 13,469 total)