Re: How do update data more convient?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Hi
Why not use Stored procedures.Its a simple SQL statement. on fly should
be used when your query is really really on fly , for instance a
complicated search screen.
-------
Regards ,
C#, VB.NET , SQL SERVER , UML , DESIGN Patterns Interview question book
http://www.geocities.com/dotnetinterviews/
My Interview Blog
http://spaces.msn.com/members/dotnetinterviews/

.



Relevant Pages

  • Re: Sessions and Pagination Problem
    ... I don't get an error with the query. ... I have multiple if statements that append "AND"'s to the SQL statement ... If you click on page numbers and the prev or next links, ...
    (comp.lang.php)
  • Re: query wont return results
    ... Following is the SQL statement of my query ... FROM (tblCourses INNER JOIN tblHoles ON tblCourses.CourseID = ... Post the SQL statement of it. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: How to find duplicate records in ASP.net-Access !
    ... take the data set and query it with distinct keyword. ... My Interview Blog ... Prev by Date: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: When do I open my Recordsets?
    ... > So if I build an SQL statement using parameters in the query SQL View, ... > I call the query, then I don't have to worry about what I am doing in the ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • Basic SQL
    ... I am trying to write a sql statement that gives me the records that ... have multiple values for column b, but cannot figure it out - can ... The results of the query when running against the above data ... Prev by Date: ...
    (comp.databases)