No announcements
Found 1526122 threads
-
1 Votestrigger problem inserting null values??
im much confused in writing the trigger i mean i want to know the trigger is fired this is what i want to achieve, thats why i am inserting values into another ...Answered | 21 Replies | 8780 Views | Created by chandu123 - Sunday, October 3, 2010 10:39 AM | Last reply by Erland Sommarskog - Wednesday, October 6, 2010 9:59 PM
-
0 Votes
auto trigger insert null values with random min wit
User-1716253493 posted Not sure about your requirement, seem like you want do like this Insert into yourtable (name,intime,outtime) values ...Unanswered | 2 Replies | 199 Views | Created by Anonymous - Wednesday, March 24, 2021 1:15 PM | Last reply by Anonymous - Wednesday, March 24, 2021 7:43 PM -
0 Votes
Random Values
0 begin set @numbah = round(((@upperBound - @lowerBound - 1)*rand())+@lowerBound,0) if @allowDupes = 1 or (NOT exists (select * from @result where @numbah = number) and @allowDupes = ...Answered | 5 Replies | 1552 Views | Created by Milli_22 - Monday, June 23, 2014 3:04 PM | Last reply by --CELKO-- - Tuesday, June 24, 2014 3:05 AM -
1 Votes
Inserting null values and NO values null
Excel source can return null values when text and numbers are mixed in one column.Answered | 1 Replies | 5501 Views | Created by SBolton - Friday, April 16, 2010 8:00 PM | Last reply by Miloslav Peterka - Friday, April 16, 2010 8:49 PM -
2 Votes
Triggers with OLD and NEW Values
In an after trigger, the columns in the affected rows are the after-images and contain the same values as those found in the virtual inserted table.Answered | 11 Replies | 6367 Views | Created by Mazhar_Parkar - Thursday, October 16, 2014 4:43 AM | Last reply by Mazhar_Parkar - Tuesday, November 18, 2014 7:14 AM -
0 Votes
Inserting default value instead of null
are you defining the column as NOT NULL, and explicitly specifying NULL for that column in the insert statement?Answered | 4 Replies | 10371 Views | Created by RAGS1109 - Monday, April 16, 2012 10:06 PM | Last reply by vinaypugalia - Tuesday, April 17, 2012 6:10 AM -
1 Votes
Inserting null values
Use IsNULL(PlanIND,'R3') in your insert statement this will insert R3 where you have null value.Answered | 2 Replies | 3831 Views | Created by Aaban_M - Wednesday, August 5, 2009 7:19 AM | Last reply by richbrownesq - Wednesday, August 5, 2009 7:21 AM -
0 Votes
Trigger FOR INSERT and FOR AFTER INSERT
CREATE TABLE YourTable(FieldA VARCHAR(20),IamCol2 VARCHAR(20)) CREATE TABLE DimensiontTbl (FieldA VARCHAR(20)) INSERT INTO DimensiontTbl ...Answered | 3 Replies | 1356 Views | Created by MaxShapiro - Thursday, March 19, 2015 9:50 PM | Last reply by Eric__Zhang - Friday, March 20, 2015 3:36 AM -
0 Votes
how to get a trigger to fire (Instead of trigger for handling null values) ?
Bending the data definition to work around an issue like this may allow invalid/undesirable data to end up in the database (NULL values for fld3).Answered | 15 Replies | 3471 Views | Created by Rich P123 - Tuesday, August 9, 2011 9:15 PM | Last reply by Erland Sommarskog - Wednesday, August 10, 2011 10:04 PM -
0 Votes
trigger throws an error of Cannot insert the value NULL into column 'TableID'
Trigger is a high-maintenance database object!Answered | 5 Replies | 7918 Views | Created by G2010West - Wednesday, June 29, 2011 6:09 PM | Last reply by Kalman Toth - Monday, July 4, 2011 3:02 PM -
3 Votes
Auto increment value in insert statement
Your insert method is wrong in sql .Answered | 9 Replies | 40768 Views | Created by rguarnieri - Tuesday, September 11, 2012 3:53 AM | Last reply by rguarnieri - Tuesday, September 11, 2012 12:17 PM -
2 Votes
Trigger - Table - Pre insert to check duplicate values
set nocount on; create table dbo.timesheet ( timesheetid int identity(1,1) not null, empno int not null, tsdate date not null, ...Answered | 6 Replies | 2899 Views | Created by gselvam1 - Wednesday, December 30, 2015 2:04 AM | Last reply by Sam Zha - Monday, January 11, 2016 7:16 AM -
0 Votes
insert a null value into a date field
Most likely, there is a trigger on the table that replaces the NULL with the magic value of 1 Jan 1990.Answered | 8 Replies | 12115 Views | Created by John Mendes - Friday, November 1, 2013 1:03 PM | Last reply by Gert-Jan Strik - Saturday, November 2, 2013 2:38 PM -
0 Votes
Triggers for insert
You can define these default values in table creation itself.Answered | 3 Replies | 3879 Views | Created by Millette - Thursday, April 29, 2010 8:13 AM | Last reply by Millette - Thursday, April 29, 2010 12:48 PM -
3 Votes
INSERTING NULL VALUES
To add to above NULL is not regarded as a value in sql server under default conditions.Answered | 6 Replies | 887 Views | Created by I4QR1A - Friday, November 14, 2014 3:51 PM | Last reply by Visakh16 - Friday, November 14, 2014 5:52 PM -
0 Votes
identify default min value
A field is {year, month,day, hour, minute, second} within a temporal value.Answered | 7 Replies | 2551 Views | Created by kavithma - Friday, January 10, 2014 4:38 PM | Last reply by --CELKO-- - Friday, January 10, 2014 8:53 PM -
0 Votes
insert to null value
This problem cannot be addressed in the query but can be fixed with a change to the children_id column to allow NULL values.Answered | 1 Replies | 1418 Views | Created by hamonbatra - Friday, December 20, 2013 1:13 AM | Last reply by Dan Guzman - Friday, December 20, 2013 3:04 AM -
1 Votes
insert null value in a textbox
i have a textbox which have a decimal value 0.5.Answered | 1 Replies | 2237 Views | Created by emmy_23 - Tuesday, March 12, 2013 9:50 AM | Last reply by FarnhamSurrey - Tuesday, March 12, 2013 3:17 PM -
4 Votes
Bulk Insert with Null Value
BULK INSERT is a binary tool, and is not the most flexible guy in town.Answered | 10 Replies | 1507 Views | Created by Hrishi K - Thursday, December 10, 2015 6:59 PM | Last reply by André Renato Furtado - Friday, December 11, 2015 2:34 PM -
0 Votes
Allow null values+INSERT INTO
I'm not sure I understand why this allows null and my posted INSERT didn't?Answered | 6 Replies | 3051 Views | Created by quarck2 - Sunday, March 3, 2013 7:20 PM | Last reply by quarck2 - Thursday, March 7, 2013 4:47 PM - Items 1 to 20 of 1526122 Next ›
No announcements
