No announcements
Found 2213718 threads
-
0 VotesAdding a value to a new column
I am adding a new column to a table.Answered | 4 Replies | 1526 Views | Created by Davis Farmer - Monday, July 29, 2013 10:43 PM | Last reply by Davis Farmer - Tuesday, July 30, 2013 1:14 PM
-
1 Votes
Gridview - Adding new column
I have the same problem that i need to add new column to the datagridview at runtime.Answered | 6 Replies | 4203 Views | Created by husna_ - Wednesday, September 9, 2009 1:45 AM | Last reply by liurong luo - Monday, September 14, 2009 6:35 AM -
1 Votes
Invalid column name after Adding New Column
Hi, In SQL08, I've added a column to a table.Answered | 2 Replies | 11141 Views | Created by Ahren33 - Monday, September 14, 2009 2:47 PM | Last reply by Adam Haines - Monday, September 14, 2009 2:59 PM -
2 Votes
Adding a New Date Column
or if you want an empty date column: NULL(DT_DATE) Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com ...Answered | 4 Replies | 786 Views | Created by Adam Quark - Friday, February 13, 2015 9:40 PM | Last reply by Adam Quark - Monday, February 16, 2015 9:08 PM -
0 Votes
Adding a new column in update query
You can not add a new column in an update query (if the column is not defined in the table).Answered | 1 Replies | 6019 Views | Created by PendekantiS - Friday, September 24, 2010 10:42 PM | Last reply by Naomi N - Friday, September 24, 2010 11:20 PM -
0 Votes
Trouble adding new column to custom newForm.aspx
Click on the Content Type(s) and find the column which is having the issue.Answered | 4 Replies | 15155 Views | Created by run4it - Thursday, July 25, 2013 10:43 PM | Last reply by DhirajDJ - MSFT - Wednesday, October 16, 2013 1:13 PM -
3 Votes
adding new row to column dynamically
Dropping and adding columnss every day, is just wrong.Answered | 7 Replies | 2607 Views | Created by Rahul Kumar (Rahul Vairagi) - Saturday, August 25, 2012 7:17 AM | Last reply by Erland Sommarskog - Monday, August 27, 2012 9:06 PM -
2 Votes
adding new column names with a twist
If so, your original requirement is easy enough to satisfy using ALTER TABLE ADD COLUMN command in a loop.Answered | 4 Replies | 3861 Views | Created by Dan10nis - Monday, May 2, 2011 7:43 PM | Last reply by Dwntrdr - Wednesday, May 4, 2011 7:35 PM -
0 Votes
Automatically adding new tables/columns to replication
You are correct - columns cjhanges/additions will be replicated by default in SQL 2005.Answered | 4 Replies | 9579 Views | Created by Yitzhakov - Tuesday, March 31, 2009 2:35 PM | Last reply by Hilary Cotter - Wednesday, April 1, 2009 9:26 PM -
1 Votes
Push columns to right when adding new columns in powerpivot
>>Is there a way to insert new columns so the alert doesn't pop up and the notes don't get overwritten?Answered | 1 Replies | 989 Views | Created by Phar1402 - Thursday, August 23, 2018 4:48 PM | Last reply by willson yuan - Friday, August 24, 2018 3:30 AM -
0 Votes
Adding new computed column in SQL Server table
Ok then you've to do it like this Add a new column in DimProduct to correspond to CalendarDate in DimCalendar You can set a FK to ...Answered | 11 Replies | 1160 Views | Created by RP Reddy - Thursday, February 15, 2018 10:04 AM | Last reply by Uri Dimant - Thursday, February 15, 2018 1:16 PM -
0 Votes
Adding a new column from a table to a SQL view
As you mentioned you need to add a column from a different table, you need to join the table appropriately with the existing table so that you maintain the data integrity and add the ...Answered | 4 Replies | 2555 Views | Created by Anu9 - Monday, November 2, 2015 6:29 PM | Last reply by Krantionline29 - Wednesday, December 2, 2015 11:55 PM -
1 Votes
Adding a new not null column to an existing table?
>>>After doing this, the table is altered with the new column and updated with the new column values.Answered | 4 Replies | 1338 Views | Created by fahma23 - Wednesday, February 11, 2015 12:06 AM | Last reply by fahma23 - Friday, February 13, 2015 12:00 AM -
0 Votes
Adding a new Column in derived transformation using C#
On the surface it seems to me this article has all you need: SSIS : Adding a Derived Column to a SSIS package with C# (Part VI) ...Answered | 1 Replies | 1098 Views | Created by vivek89 - Tuesday, January 21, 2014 1:03 PM | Last reply by ArthurZ - Tuesday, January 21, 2014 3:59 PM -
0 Votes
Adding a column to the end of a table
You can alter the table by addind a new column and by set a default value wouldn't effect the table data.Answered | 3 Replies | 7470 Views | Created by dhinged - Tuesday, February 8, 2011 8:58 PM | Last reply by Civic1986 - Wednesday, February 9, 2011 10:56 AM -
0 Votes
Adding Text to a Column
As a workaround, create a new column in library and then add description to it.Answered | 2 Replies | 1759 Views | Created by SamWD1989 - Monday, September 23, 2013 11:49 PM | Last reply by Hemendra Agrawal - Tuesday, September 24, 2013 8:57 AM -
1 Votes
Adding column in middle of the Table
Unfortunately, to add a column in the middle of list of columns, you need to take the long way: create a new version of the table, copy data over, migrate indexes, triggers, ...Answered | 5 Replies | 7729 Views | Created by AnbuS - Tuesday, February 9, 2016 2:09 PM | Last reply by Erland Sommarskog - Tuesday, February 9, 2016 10:49 PM -
0 Votes
Effect adding new column for primary key
Secondly, instead of just creating a random column for replication, you should look at the existing columns in your table to see whether there is ...Answered | 3 Replies | 4203 Views | Created by kneeah - Friday, June 24, 2011 3:21 AM | Last reply by Mr. Wharty - Friday, June 24, 2011 3:49 AM -
0 Votes
sp_repladdcolumn does not allow adding columns of datatypes that are new to this release.
This procedure should not be used on columns with data types that were introduced in SQL Server 2005 or SQL Server 2008.Answered | 2 Replies | 1614 Views | Created by SKumar99 - Saturday, March 22, 2014 1:53 AM | Last reply by SKumar99 - Saturday, March 22, 2014 2:01 PM -
0 Votes
Running Table valued function after adding a new column
Hi, When table valued functions are creted retrun columns are also stored, so when you add column that list of TVF columns will not change and ...Answered | 4 Replies | 5740 Views | Created by OmriN - Wednesday, August 18, 2010 8:44 AM | Last reply by Chintak Chhapia - Wednesday, August 18, 2010 9:10 AM - Items 1 to 20 of 2213718 Next ›
No announcements
