Click here to Skip to main content
15,885,366 members
Home / Discussions / Database
   

Database

 
AnswerRe: Optimizing query Pin
Kjetil Svendsen6-Jul-08 21:34
Kjetil Svendsen6-Jul-08 21:34 
Questionscript Pin
rezarafiee6-Jul-08 2:15
rezarafiee6-Jul-08 2:15 
AnswerRe: script Pin
Saksida Bojan6-Jul-08 3:26
Saksida Bojan6-Jul-08 3:26 
AnswerRe: script Pin
Pete O'Hanlon6-Jul-08 9:14
mvePete O'Hanlon6-Jul-08 9:14 
QuestionEmail Alert after Insert on table Pin
obarahmeh5-Jul-08 21:42
obarahmeh5-Jul-08 21:42 
AnswerRe: Email Alert after Insert on table Pin
N a v a n e e t h6-Jul-08 4:15
N a v a n e e t h6-Jul-08 4:15 
GeneralRe: Email Alert after Insert on table Pin
obarahmeh6-Jul-08 23:52
obarahmeh6-Jul-08 23:52 
GeneralRe: Email Alert after Insert on table Pin
N a v a n e e t h7-Jul-08 0:38
N a v a n e e t h7-Jul-08 0:38 
obarahmeh wrote:
.but I could not make the scenario that check If Insert has happenned...


Ok - Say your table has 2 columns, "id" and "name". Now to get latest items inserted and not emailed, we need to add one more flag say "emailed" which will have a value "y" if email is sent. When new rows are inserting, set this filed value as "n".

In your SQL job, you can select records which has "emailed" flag value as "n". These will be the records that are newly inserted and pending to be emailed.

Hope this helps

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

QuestionOleDb INSERT statement, works if I do NOT prepare it, fails if I do... Pin
kfrankinmn5-Jul-08 20:57
kfrankinmn5-Jul-08 20:57 
AnswerRe: OleDb INSERT statement, works if I do NOT prepare it, fails if I do... Pin
Kjetil Svendsen6-Jul-08 22:22
Kjetil Svendsen6-Jul-08 22:22 
GeneralRe: OleDb INSERT statement, works if I do NOT prepare it, fails if I do... Pin
kfrankinmn7-Jul-08 2:06
kfrankinmn7-Jul-08 2:06 
GeneralRe: OleDb INSERT statement, works if I do NOT prepare it, fails if I do... Pin
Kjetil Svendsen7-Jul-08 21:01
Kjetil Svendsen7-Jul-08 21:01 
QuestionUpdate transaction makes no changes to database Pin
Nigel Mackay5-Jul-08 20:52
Nigel Mackay5-Jul-08 20:52 
QuestionOracle InstantClient Pin
Muammar©5-Jul-08 19:41
Muammar©5-Jul-08 19:41 
QuestionSQL Server 2005 and vb.net >>>> Connection String Pin
kindman_nb5-Jul-08 12:37
kindman_nb5-Jul-08 12:37 
AnswerRe: SQL Server 2005 and vb.net >>>> Connection String Pin
N a v a n e e t h5-Jul-08 16:44
N a v a n e e t h5-Jul-08 16:44 
QuestionApostrophe In Field-Value Problem Pin
xbiplav5-Jul-08 10:57
xbiplav5-Jul-08 10:57 
AnswerRe: Apostrophe In Field-Value Problem Pin
Kjetil Svendsen6-Jul-08 22:35
Kjetil Svendsen6-Jul-08 22:35 
QuestionNeed tips for designing Database for multilingual websites (6 different languages) Pin
amistry_petlad5-Jul-08 4:46
amistry_petlad5-Jul-08 4:46 
Questionselect problem Pin
Stephan Hoppe4-Jul-08 12:24
Stephan Hoppe4-Jul-08 12:24 
AnswerRe: select problem Pin
leoinfo4-Jul-08 14:59
leoinfo4-Jul-08 14:59 
GeneralRe: select problem Pin
Stephan Hoppe5-Jul-08 6:13
Stephan Hoppe5-Jul-08 6:13 
QuestionHow to get date only from the table Pin
BalasubramanianK4-Jul-08 3:20
BalasubramanianK4-Jul-08 3:20 
AnswerRe: How to get date only from the table Pin
leoinfo4-Jul-08 3:50
leoinfo4-Jul-08 3:50 
QuestionTrouble joining between 3 tables Pin
dlarkin773-Jul-08 10:14
dlarkin773-Jul-08 10:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.