CodeSmith Community
Your Code. Your Way. Faster!
All Tags » Stored Procedures » .netTiers (RSS)

Browse Site by Tags

Showing related tags and posts accross the entire site.

  • Generated SQL: ANSI NULLS : SET TO OFF BY DEFAULT

    Hi, By default .nettiers generates all stored procedures with ANSI NULLS set to OFF. e.g SET ANSI_NULLS OFF We are using a SQL Server 2005 Indexed View, which must use SET ANSI_NULLS ON for any CRUD operations. I understand that using ANSI_NULLS OFF specifies SQL-92 compliant behavior of the Equals ...
    Posted to .netTiers - General Support (Forum) by james.smith@adactus.co.uk on 06-26-2008
    Filed under: .netTiers, SQL View 2005, ANSI_NULLS, stored procedures, ansi nulls, sql server

  • Only update modified fields

    I'd like to see the update routines only update the fields that have been modified. As it is, I need to ensure that I have either gotten the record from the database, update the data, and then update the database; or that I have gotten all fields from the client application. Right now, we're...
    Posted to .netTiers - Feature Requests (Forum) by ChuckB on 01-17-2008
    Filed under: entities improvement suggestion, Stored Procedures, custom stored procedures, .netTiers, OnColumnChanged
Page 1 of 1 (2 items)
Copyright © 2008 CodeSmith Tools, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems