thomasemp (9/26/2011)

---

I have created a trigger for a particular table.While i insert a record the trigger is working perfectly but while i use SqlBulkCopy to upload records from excel to...

that is by design. all bulk copying, whether using bcp.exe , BULK INSERT or via a SQLBulkCopy, triggers are not executed by default.

there is a flag you can set...

does this do what you are asking?

it seems a little round about, but it works with the sample data given.

/*

--Results

transaction_idtype

1A

1B

5A

5B

5B

*/

With mySampleData (transaction_id,type)

AS

(

SELECT 1,'A' UNION ALL

SELECT 1,'B' UNION ALL

SELECT 2,'A' UNION...

none of the above.

go to this page:

sql 2005 sp4

and download either the 32bit or 64 bit of Service pack 4.

that service pack is designed to upgrade any type of instance...

try something like this to track down the non numeric values:

SELECT DISTINCT '>' + [test] + '<' FROM K

WHERE ISNUMERIC([test]) = 0

maybe it's a value like 'NA" or 'N...

In programming languages, a function can do everything a Subroutine can do, plus return a value.

in SQL it is...

nothing is ever equal to or not equal to null; since null is undefined, nothing can match it, even another null.

you have to us the IS function instead:

SELECT

...

besides 'N/A' it...

yes you are correct.

a sysadmin login can do everything.

a login with sysadmin priviledges performs work at a database level is performed in the context of the user dbo , which...

you'll need to cast or convert; you cannot compare strings like that; you run into trouble with greater than and between and stuff not behaving the way the value of...

vikramp 2790 (9/26/2011)

---

my procedure runs successfully except for first insert query does not insert rows into the table but auto increments id. but Other querys execute successfully. I...

InfiniteError (9/26/2011)

---

thanks guys for all the answers.

Sorry if my example is not that clear. My example assume that all are the same (same number of records, indexes, where clause). Honeslty...

InfiniteError (9/26/2011)

---

hey guys, need help on this one. I have a .net application, On sql side,Is it much faster to execute sp rather that inline statement? meaning from .net i...

dave i think it is C:\WINDOWS\system32\msorcl32.dll or C:\Program Files\Common Files\System\Ole DB\msdaora.dll as part of any MDAC that got installed (uusally already there);

my first recommendatino would be to change that to a larger Initial Size, which depends a lot on how big it is rig now. if it's 2Gig in size right...