double post

Attention with security. Sometimes SPs execute with admin permissions even when the...

As a developer I actually prefer to use stored procedures. If only SQLServer had a way to organize them in packages just like in Oracle so you wouldn't end up...

Bob Cullen-434885 (1/28/2010)

---

OK. I am in the 17% who got it wrong - I replied "Error". And now I know. But will somebody kindly explain why BIT is treated any...

foxjazz (3/13/2009)

---

also instead of using cursurs like they are now, wouldn't it be easier to say:

foreach( select myfield from tbl where myotherfield > 3)

{

insert into myothertable (myotherfield) values (myfield)

}

I think...

Though I am a database application developer, too, I know that there is more than just database programs out there. There are great programmers writing device drivers or embedded code....

I had to do this for many years. There is no such thing as packages in Oracle. I could never figure out another way, so if there is one I'...

define an output parameter as table and use it as input to ur stored proc

anyway, in Access you would just link the "external data" in File --> external data etc.

use inserted.ID or deleted.ID in the "inserted" or "deleted" table, i.e. the inserted/deleted row

The problem does NOT seem to be the DB but rather a bad application design. Whatever db you use the problem will always be the same and cannot be "solved"...

You could check the data. Maybe records carry a creation date. Not precise but at least an idea.

---- The user can do an ODBC to link to the table and open it in Access, update or insert data.

---- This user can link to that query but cannot...

have you already more info than just a "feeling that they may be corrupt"? What error messages do you receive?

I wonder why a global variable would go out of scope, though

declare @@myvar varchar(50)