| Prevent a row from being deleted (8 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspsqlhowto] to [ngfx sqlclient] by Tim Tim.Musschoot@rug.ac.be I am trying to write a trigger on SQL2K that will examine the values of a row that is attempting to be deleted and raise an error (and halt the delete) if the value of column A "FOO" Being the newbie to triggers I am, I have absolutely no idea how to do this. Heres what I have so far: CREATE TRIGGER GroupMembership Prevent... |
|
| trigger/sp to run dts (6 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [aspsqlhowto] to [ngfx sqlclient] by Tim Tim.Musschoot@rug.ac.be Can I use a stored procedure to run a dts package? If yes, what context will the dts package be called under if the stored procedure is called from the web. My dts package uses a connection which accesses a local odbc connection. It will bomb if the context is not correct. I initially wanted to call the dts package from th... |
|
| Select Statement Help (2 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Moved from [ngfx io] to [ngfx sqlclient] by Victor Von Doom doctordoom@aspelite.com Hey All, How 2 get a single record from a select statement which will produce 100 of records in output using T SQL. I want a 10th record from that output. Thanking U. Biplab Washington DC's Largest FREE Email service. http://www.DCemail.com A Washington Online Community Member http://www.DCpages.com Promote your gr... |
|
| stored procedure not returning value... (3 replies) |
| ASPFriends.com 'ngfx-sqlclient' list |
| Hey folks, Some gremlin has come and transformed my code overnight so that it no longer works. I swear I didn't touch it. :) Very simple: I have a sproc that should return a value. It's no longer returning that value. (the actual error message is 'can't transform from type DBNull to Integer', on the line with ***) Here's the code & sproc... can you see the problem? Dim cmd2 as new SQLCommand("sp P... |
|
