SQL Server Performance

related to asp.net

Discussion in 'Non-Transact SQL Developer Performance Tuning' started by pushpendra, Mar 14, 2007.

  1. pushpendra New Member

    As i m a new in sqlserver2000 so please let me know the answer of this querry.

    I have a column name date_of_birth in a database and i want to insert the user's date of birth in the database from the three dropdownlists name ddl1, ddl2 and ddl3.
    so please let me know how i code to do it successfully.
  2. MohammedU New Member

    Either you have to create procedure or sql statement to insert the data..

    SQL statement...
    INSERT INTO TABLENAME (Date_of_birth,.....,....)
    ..............................

    procedure...

    CREATE PROC PROCEDURENAME
    @DBO ....,
    @....
    AS
    INSERT INTO TABLENAME (Date_of_birth,.....,....)
    ..............................

    MohammedU.
    Moderator
    SQL-Server-Performance.com
  3. Madhivanan Moderator

    Also, Visit www.aspnet.com and go thru the code there

    Madhivanan

    Failing to plan is Planning to fail
  4. Adriaan New Member

    Another point is the usual confusion for newbies between the INSERT and UPDATE action queries.

    INSERT is when you add a completely new row to a table.

    UPDATE is when you insert a new value into a column on an existing row.

Share This Page