No announcements
Found 2503920 threads
-
2 Votes
nulls in pivoted view: error in updating base table that does not allow nulls
I should have pasted the sql ssms was generating, but the problem is solved now anyway.Answered | 8 Replies | 3344 Views | Created by TechVsLife2 - Sunday, August 7, 2011 6:59 PM | Last reply by TechVsLife2 - Monday, August 8, 2011 6:29 PM -
0 Votes
strange GUID does not allow null problem!
I managed to find out the problem.Answered | 3 Replies | 4666 Views | Created by Jes_1111 - Monday, January 21, 2008 12:45 PM | Last reply by Cesc.S - Sunday, January 3, 2010 11:58 PM -
0 Votes
sql to set allow null
To allow NULL use the below --exist column ALTER TABLE tbl ALTER COLUMN col INT NULL --New ...Answered | 4 Replies | 37058 Views | Created by bahushekh - Monday, January 31, 2011 8:19 AM | Last reply by Uri Dimant - Monday, January 31, 2011 9:57 AM -
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 | 2959 Views | Created by quarck2 - Sunday, March 3, 2013 7:20 PM | Last reply by quarck2 - Thursday, March 7, 2013 4:47 PM -
1 Votes
Allow Nulls into SQL Trigger
Make the vendor liable for legal problems.Answered | 5 Replies | 2882 Views | Created by NealRodruck - Thursday, August 30, 2012 10:40 PM | Last reply by --CELKO-- - Sunday, September 2, 2012 2:21 AM -
0 Votes
relationships allow null values
HI, I have two tables that are related 1: N, but I want that relationship's the foreign key allows null values.Answered | 2 Replies | 2029 Views | Created by nicolasInter - Friday, June 1, 2012 8:33 PM | Last reply by Kivito - Friday, June 1, 2012 8:46 PM -
6 Votes
Problem allowing null values in parameter ~ [Report Builder 3.0]
Hi, Based on your description, you are experiencing the problem when you are creating the parameter by Get values from a query, the parameter have the null values ...Answered | 22 Replies | 16044 Views | Created by ISC. Diana De La Torre - Wednesday, October 1, 2014 2:09 PM | Last reply by RodrigoCampos - Wednesday, June 7, 2017 5:42 PM -
0 Votes
UPDATE + allow null
It does not work due to cardinality problems; Google it!Answered | 4 Replies | 1205 Views | Created by quarck2 - Thursday, March 7, 2013 5:27 PM | Last reply by --CELKO-- - Thursday, March 7, 2013 8:04 PM -
9 Votes
SSRS dropdown should allow null value
Does anyone have a better answer than "It's your query that doesn't return any NULL's"?Answered | 22 Replies | 77445 Views | Created by prathalye - Thursday, April 1, 2010 2:59 PM | Last reply by Stephen Strom - Monday, April 6, 2015 6:46 PM -
2 Votes
CreateToolWindow2 problem with dynamic guid
I believe the problem is that Guid.ToString() does not format the string the way that CreateToolWindow2 expects.Answered | 4 Replies | 5262 Views | Created by hudgeo - Tuesday, July 8, 2008 6:04 PM | Last reply by DonVadicastro - Friday, February 18, 2011 10:43 AM -
0 Votes
'Does not allow new values' meaning?
hi Bellow is the example with different constraint ,like not null for does not allow null ,without any key allow null and ...Answered | 6 Replies | 885 Views | Created by indu07 - Tuesday, February 4, 2020 7:40 AM | Last reply by Laxmidhar sahoo - Wednesday, February 5, 2020 7:09 AM -
0 Votes
Alter numeric column to allow NULL
select cast (1.34 as numeric ) select cast (1.34 as numeric(7,4)) Have a look ...Answered | 4 Replies | 7915 Views | Created by miruan - Tuesday, February 4, 2014 5:43 AM | Last reply by sqlsaga - Tuesday, February 4, 2014 5:59 AM -
0 Votes
Check for null does not work anymore
In this case, the problem was not immediately apparent since the query requires a scan, and no results could be retrieved within the first page's execution time.Answered | 6 Replies | 896 Views | Created by Elmar Maan - Monday, April 13, 2015 10:22 AM | Last reply by Aravind Ramachandran - Tuesday, April 14, 2015 12:27 AM -
0 Votes
Nullable Guid still NOT NULL on db generation
[Users] ( [Id] UNIQUEIDENTIFIER NOT NULL, [Name] NVARCHAR (MAX) NULL, [DefaultCurrencyId] UNIQUEIDENTIFIER ...Answered | 3 Replies | 3618 Views | Created by Arumsoft - Monday, September 14, 2015 11:03 PM | Last reply by Fred Bao - Monday, September 21, 2015 2:07 AM -
0 Votes
ISA11 field does not allow for a ^ but does allow U
The problem is that when I use the ^ in the elegibility transaction, biztalk will process the file with no problems.Answered | 4 Replies | 9381 Views | Created by Carlos T. _ - Thursday, October 28, 2010 12:06 PM | Last reply by Carlos T. _ - Thursday, October 28, 2010 7:37 PM -
0 Votes
Configuring Lookup to allow NULLs
SELECT {lookup column}, {return column} FROM {lookup table} UNION ALL SELECT NULL, {null ...Answered | 9 Replies | 7020 Views | Created by UltraDev - Wednesday, June 5, 2013 9:16 AM | Last reply by M Vega - Wednesday, June 5, 2013 12:57 PM -
1 Votes
Null values are being inserted in columns not allowing Null values
SQL Server will not allow NULL values to be inserted into columns that do not allow NULL.Answered | 3 Replies | 5800 Views | Created by Mahesh C Sharma - Saturday, January 14, 2012 5:27 AM | Last reply by Dan Guzman - Saturday, January 14, 2012 2:31 PM -
0 Votes
Problem with report checkboxes and null values
There are religious wars in the db world about whether Boolean fields should allow Nulls or not.Answered | 10 Replies | 7098 Views | Created by Wcalcote - Thursday, July 7, 2011 11:28 PM | Last reply by David-W-Fenton - Wednesday, July 13, 2011 9:23 PM -
0 Votes
GUID Problem in C#...
It is not your cast that is failing, you don't need a cast because GetGuid already returns a Guid.Answered | 3 Replies | 3434 Views | Created by Tushar Capoor - Monday, July 28, 2008 8:03 PM | Last reply by Tushar Capoor - Monday, July 28, 2008 8:29 PM -
0 Votes
Suggestion: Allow column drop if value is null or default
Does this make sense, or is there something I'm missing about your situation?Answered | 5 Replies | 3268 Views | Created by EricDAllen - Wednesday, June 13, 2012 4:33 PM | Last reply by Gert Drapers (MSFT) - Saturday, June 16, 2012 7:26 PM - Items 1 to 20 of 2503920 Next ›
No announcements