Home ›
All Tags » sql » Null (RSS)

Browse by Tags

Related Posts

  • insert columns but get error about null datetime field

    Hi there, I am doing an INSERT into a table. I have a "DateCreated" field and I have set the field to ALLOW NULLS = FALSE but set the default value to getdate() When I execute the stored procedure it tell me "SqlException: Cannot insert the value NULL into column "DateCreated"...
    Posted to Data Access and ObjectDataSource Control (Forum) by mongoose_za on 06-11-2009, 12:00 AM
    Filed under: null, SQL, stored procedure, datetime

  • Null in ms sql date field

    I have a date field in SQL that allows Null values. LastCheckedIn (allow null checked) On my web form, there's a TextBox called txtLastCheckedIn. I want the user to be able to leave it blank if the item has not been checked in before, in which case there should be a null in the DB. But the first...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by corbybender on 03-03-2009, 12:00 AM
    Filed under: Null, sql, date

  • help please, no matter what i do... Cannot insert the value NULL into column

    hello there. i need your help. i have a very simple insert form. but its not working... here is my html/aspx code: "C#" MasterPageFile= "~/gdMasterPage.master" AutoEventWireup= "true" CodeFile= "inserttest.aspx.cs" Inherits= "admin_inserttest" Title=...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by dj5000 on 07-20-2008, 12:00 AM
    Filed under: SQL, Data, null

  • Using Case Statement in Where clause for datediff function

    I am trying to use a case statement in my where clause to do a datediff so that when my close_date is null it will use getdate() instead of the close_date column. With the code poste below I receive the following error: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '>'. SELECT ...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by cgreene.gsu on 07-18-2008, 12:00 AM
    Filed under: slq 2005, SQL, SQL Server 2005, "T-SQL", case datetime, Data, DATEDIFF NULL, datediff sql sql2000 sql2005, DB NULL, getdate() SQL Server 2005, where, "Dynamic SQL", Select * from tablename where column1 = (), .NET SQL Server 2005, date sql, null, "SQL Server", null value column, "ASP.NET and SQL Server"

  • Select query -with a NULL FK- return nothin!

    Hi, I'm trying to select this sql statement, which selects some items from 3 tables: mail, SysUsers and projects table. The query works fine when I pass parameter @messageId and the FK [mail.projectId] is NOT null. But when it is null, the query doesn't return any rows, although it is not the...
    Posted to Data Access and ObjectDataSource Control (Forum) by jocker_wow on 11-28-2007, 12:00 AM
    Filed under: null, sql, FK, Select

  • problem with retrieving/displaying data based on form input

    Hi, I've developed a form which accesses a database through a data layer and sends parameters based on the form input. I have written the following code which works by checking if the textbox is empty and passing a null value as a string to the search parameter in the query, of which there are five:...
    Posted to Data Presentation Controls (Forum) by tomosap on 02-22-2007, 12:00 AM
    Filed under: Null, parameter, problem, querystring, records, rows, search, sql, sqldatasource, string, table adapter, textbox, Updateparameters, VB, access database, ADO.NET, ASP.net 2.0 GridView InsertParameters ControlParameter PropertyName, data, data access layer, database, databinding, datasource, If Statement, method, SELECT, FORM, GridView, label, GridView asp.net

  • setting empty text box input on form to null parameter for sql

    Hi, I'm pretty new to ASP.NET and VB, but I'm working on a project which is essentially a staff directory. Using VS 2005, I've setup a basic grid view which connects to an object which connects via a data layer to a SQL database with Name, Surname, Email, Extension No and Department fields. I have it...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by tomosap on 02-19-2007, 12:00 AM
    Filed under: mysql, Null, rows, specific record, sql, sqldatasource, string, table adapter, textbox, VB, data access layer, database, datatagrid navigarion paging style, dataview, If Statement, SELECT, FORM
Page 1 of 1 (7 items)

Contact | Advertise | Issue Management by Axosoft's OnTime | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.