No announcements
Found 2087456 threads
-
2 Votescreate table with timestamp column
Alternative method by creating default constraint CREATE TABLE [dbo].Answered | 2 Replies | 1235 Views | Created by niklasrene - Thursday, July 2, 2015 10:06 AM | Last reply by SaravanaC - Thursday, July 2, 2015 10:54 AM
-
0 Votes
Update timestamp column in existing table
Hi Friend, You don't update the timestamp column - a timestamp (now renamed rowversion) column is automatically updated by ...Answered | 2 Replies | 5273 Views | Created by Matthieu71 - Monday, August 19, 2013 1:35 PM | Last reply by vijayalaxmi_atyam - Tuesday, August 20, 2013 5:21 AM -
3 Votes
rowversion datatype changed to timestamp in table's column
"timestamp" is.Answered | 3 Replies | 2897 Views | Created by Manoj Pandey (manub22) - Friday, December 23, 2011 12:05 PM | Last reply by Richard Brown (CFCU) - Wednesday, December 10, 2014 8:28 PM -
0 Votes
How to BULK INSERT Data to Table with Timestamp Column?
Other Option: Create a simple view with all columns, but without the timestamp column, then you can use that view to load the data.Answered | 5 Replies | 6547 Views | Created by chcw - Sunday, July 29, 2018 9:39 AM | Last reply by Tom Phillips - Monday, July 30, 2018 2:41 PM -
0 Votes
Replication on timestamp column
Table has about 30 indexes (too many for my taste).Answered | 2 Replies | 1770 Views | Created by simonxy - Thursday, June 13, 2013 9:47 AM | Last reply by simonxy - Monday, June 17, 2013 8:57 AM -
0 Votes
Adding Timestamp column in Datatable
Hi Shiv455; The SQL server data type of timestamp is a autogenerated column in a table and therefore you can't assign a value to it.Answered | 1 Replies | 4703 Views | Created by shiv455 - Wednesday, December 7, 2011 2:17 AM | Last reply by Fernando Soto - MCSD - Wednesday, December 7, 2011 4:38 AM -
0 Votes
timestamp columns
If you mean a T-SQL TimeStamp/RowVersion column then M does not support this.Answered | 3 Replies | 5547 Views | Created by gdimauro - Monday, May 4, 2009 6:21 AM | Last reply by Anthony C Bloesch - Wednesday, May 6, 2009 6:42 PM -
0 Votes
Insert with timestamp column
Alternatively you could add the timestamp column to the other table and your SQL will start working, but you're still better off naming the columns in case ...Answered | 4 Replies | 6492 Views | Created by WIJ - Friday, April 1, 2011 8:08 PM | Last reply by vinaypugalia - Saturday, April 2, 2011 4:42 AM -
2 Votes
Add two timestamp columns
Abi, As pointed out by Olaf, you are looking for the DATETIME type and not TIMESTAMP.Answered | 4 Replies | 5353 Views | Created by IamProgrammer - Tuesday, March 18, 2014 2:47 PM | Last reply by IamProgrammer - Thursday, March 20, 2014 4:52 AM -
1 Votes
How to tranfer a column with TimeStamp datatype
Table Y will be created with a schema matching that of X, and the timestamp values are preserved.Answered | 8 Replies | 24068 Views | Created by Gaurav 17 - Monday, May 16, 2011 12:42 PM | Last reply by Erland Sommarskog - Friday, October 6, 2017 2:37 PM -
5 Votes
INSERT...SELECT command with a timestamp column
Make sure your ts field is the last column in the table and that all the columns match between the old and new table 2.Answered | 14 Replies | 100118 Views | Created by ciaotz - Tuesday, October 21, 2008 11:06 AM | Last reply by stevensrf - Monday, July 1, 2019 10:01 PM -
1 Votes
Add 2 timestamp column in drived table in ssis
duplicate ofAnswered | 7 Replies | 938 Views | Created by Vipin jha - Wednesday, February 3, 2016 9:47 AM | Last reply by Srinivasa Rao Gude - Wednesday, February 3, 2016 10:39 AM -
0 Votes
Inconsistant values in Timestamp column
Transactional Replication---->Production Database(Tier 2) Productionl Database 1(Tier 1) tables do not have a column with data type ...Answered | 13 Replies | 5227 Views | Created by Spandan Buch - Wednesday, February 23, 2011 5:02 AM | Last reply by Kalman Toth - Sunday, March 6, 2011 10:35 AM -
0 Votes
Selecting rows based on Timestamp column
ROWVERSION is an 8 byte binary datatype that increments database-wide for each change of a row of every table that contains that column.Answered | 11 Replies | 6874 Views | Created by rockstar2831 - Monday, November 18, 2013 10:40 PM | Last reply by Vedran Kesegic - Tuesday, November 19, 2013 8:55 AM -
0 Votes
Power Pivot Memory Error when importing tables with a timestamp column
Hi Ed, If you're using PowerPivot, the only way seems to be to deselect the columns with the timestamp type in the Preview before doing the import.Answered | 3 Replies | 1855 Views | Created by RobertJ0101 - Friday, May 20, 2016 9:51 AM | Last reply by RobertJ0101 - Sunday, October 30, 2016 4:27 PM -
1 Votes
Adding TIMESTAMP to existing tables ... again ...
Columns with data type TIMESTAMP are special ... you can't specify a default value for them, you can't supply a value for them, and - in this case - if you add a ...Answered | 9 Replies | 15374 Views | Created by Adrian Pell - Wednesday, May 18, 2011 6:13 PM | Last reply by Gert Drapers (MSFT) - Friday, May 20, 2011 6:09 PM -
0 Votes
Temporarily Disable Timestamp Column (rowversion)
The timestamp column is updated automatically.Answered | 2 Replies | 4994 Views | Created by TSD123 - Tuesday, November 20, 2012 12:33 PM | Last reply by Uri Dimant - Tuesday, November 20, 2012 12:42 PM -
0 Votes
how to disable select of a timestamp column upon the update of the table
The concurrency mode on all the fields, including the timestamp column is set to "none".Answered | 3 Replies | 3657 Views | Created by voilbak - Tuesday, December 14, 2010 9:23 PM | Last reply by voilbak - Thursday, December 16, 2010 7:53 AM -
0 Votes
Timestamp
Timestamp is NOT a datetime datatype.Answered | 3 Replies | 4976 Views | Created by muzzettemm1 - Monday, September 27, 2010 5:12 AM | Last reply by Atif-ullah Sheikh - Monday, September 27, 2010 6:08 AM -
0 Votes
Migrate data error with DB2 Timestamp column
Hi Li Fan, Since SSMA 6.0 for DB2 cannot properly handle the DB2 timestamp column, I recommend you configure linked server between SQL Server and DB2, then pull ...Answered | 5 Replies | 2145 Views | Created by Li Fan - Monday, July 13, 2015 1:31 PM | Last reply by Lydia Zhang - Thursday, July 23, 2015 2:13 AM - Items 1 to 20 of 2087456 Next ›
No announcements
