Buy Questpond's video subscriptions on
huge discount
.
Online: 2731
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
Can we update DATETIME2 columns that are defined as GENERATED ALWAYS ON in Temporal Table?
Posted by
Bandi
on 8/31/2017 | Category:
Sql Server Interview questions
| Views: 6891 |
Points: 40
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Select from following answers:
Yes
No
None
All Above
If you try to update those two columns, SQL throws below exception
Cannot update GENERATED ALWAYS columns in table ‘DBName.dbo.Table1’.
Show Correct Answer
|
Alert Moderator
Bookmark It
< Previous :
Can we TRUNCATE a Temporal Table?
Next > :
What happens if you define DATETIME2 columns as Nu ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
What happens if you define DATETIME2 columns as Nullable in Temporal t ...
which of the following clause is used to define DATETIME2 columns in T ...
what are the columns to be defined for Temporal Table?
can we create Temporal Table with out Primary Key column?
which options makes a SQL table as temporal table in SQL Server 2016?
which of the following SQL statement is used to remove a log file call ...
Which of the following tool is used to identify rules and patterns in ...
what is the alternate option to maintain log/history tables in SQL Ser ...
Latest Interview Questions
Which one is Server type state management?
Which one is Client type state management?
Disadvantages of using LINQ?
What will be the output of --Input Script --Declare a sample table ...
Extension when LINQ to SQL is used in C#?
What will be the output of DECLARE @string VARCHAR(20) = 'Hell ...
What is Live Unit Testing?
What will be the output of the below TSQL Script? DECLARE @t TABLE( ...
More ...
Show Correct Answer