Tags » Query

Query Letters 101: Letters and Agents

At this point I’ve taken one online course, attended several panels on the topic, and spoken to several agents and industry reps about them: I’m talking query letters. 401 more words


[VB.NET] INSERT,UPDATE and DELETE with ExecuteStoreCommand

In this post I will show you how to perform SQL command operation using ExecuteStoreCommand with Entity Frameworks

   Using ctx = New in4MaticEntities(SetConnectionString())

      Dim rows As Integer

      rows = ctx.ExecuteStoreCommand("UPDATE MYTABLE SET CUSTOMER =0 WHERE CUSTOMER=NULL")
      debug.print("Alterated rows: " & If(row > 0, row.ToString, "nothing") 
      rows =ctx.ExecuteStoreCommand("DELETE FROM MYTABLE WHERE CUSTOMER = 10") 
      debug.print("Alterated rows: " & If(row > 0, row.ToString, "nothing") 

      rows =ctx.ExecuteStoreCommand("INSERT INTO MYTABLE (CUSTOMER) VALUES (10)") 
      debug.print("Alterated rows: " & If(row > 0, row.ToString, "nothing") 

   End Using
Catch ex As Exception
End Try

The unknown query

The young man tugged at my heart.

It was not his appearance that bothered me but rather the pale aura surrounding him.  That pale aura which defines a human in confusion. 277 more words


Be Fruitful and Multiply

Source: Be Fruitful and Multiply

While this title sounds like it may be about a Bible story or specific verse, it’s not. Be Fruitful and Multiply is for writers! 22 more words

The Writing LIfe

MS Dynamics GP - Receivable Trial Balance (Historical)

Receivable(AR) Historical Trial balance is most wanted request from all Dynamics Customers.
Thus, I would like to share the query which I have developed to fulfill this requirement. 429 more words


Limited Visibility

I’ve nearly completed the revision of Three Empty Frames, Book One in the Bucks County Novels. However, I may not be able to query an agent with that book. 201 more words