Skip to content
Advertisement

Cannot insert the value NULL into column

I’m having some problems. I am trying to get a table to update, however it is not updating because one of the fields contains rows with a NULL value. Heres the original query which gives no error: Now, the nextUpdate column might be NULL, so I am trying to accommodate for that with this query: You can see I’ve added

Convert SQL Server DateTime object to BIGINT (.Net ticks)

I need to convert a DateTime type value to BIGINT type in .Net ticks format (number of 100-nanosecond intervals that have elapsed since 12:00:00 midnight, January 1, 0001). The conversion should be perform in Sql server 2008 using T-SQL query For example: will convert to: Answer I have found a CodeProject article that may assist: Convert DateTime To .NET Ticks

Creating a view for summary

I have a table of questions. The questions can be high priority, low priority, open/answered. What is the best way to create a summary. Should I use a view or several stored procedures? Table …