Buy Questpond's video subscriptions on
huge discount
.
Online: 1471
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 >
Post
An Article
An Interview Question
A Forum Post
A Career Advice Question
A Video
A Code
A Job
A Product Catalog
An Interview Experience
A Bookmark
A News
List of interview questions posted by Bandi- Page 1
<< Back to Bandi's profile
311 records found.
Category
Interview Questions Title
Posted
Views
Sql Server
What is the default extended event session to capture Deadlocks?
31-Aug-2017
19355
Sql Server
What is the best alternate for SQL Profiler as it is being deprecated in future releases?
31-Aug-2017
17806
Sql Server
can we drop versioning enabled tables (Temporal table)? DROP TABLE dbo.TableName
31-Aug-2017
18783
Sql Server
Can we mark an existing table as Temporal table?
31-Aug-2017
8931
Sql Server
Can we TRUNCATE a Temporal Table?
31-Aug-2017
10257
Sql Server
Can we update DATETIME2 columns that are defined as GENERATED ALWAYS ON in Temporal Table?
31-Aug-2017
5240
Sql Server
What happens if you define DATETIME2 columns as Nullable in Temporal table ? CREATE TABLE Employee ( [EmployeeID] int NOT NULL PRIMARY KEY CLUSTERED , [Name] nvarchar(100) NOT NULL , [ValidFrom] datetime2 (2) GENERATED ALWAYS AS ROW START NULL , [ValidTo] datetime2 (2) GENERATED ALWAYS AS ROW END , PERIOD FOR SYSTEM_TIME (ValidFrom, ValidTo) ) WITH (SYSTEM_VERSIONING = ON (HISTORY_TABLE = dbo.EmployeeHistory));
31-Aug-2017
5099
Sql Server
which of the following clause is used to define DATETIME2 columns in Temporal Table?
31-Aug-2017
4137
Sql Server
what are the columns to be defined for Temporal Table?
31-Aug-2017
4309
Sql Server
can we create Temporal Table with out Primary Key column?
31-Aug-2017
5025
Sql Server
which options makes a SQL table as temporal table in SQL Server 2016?
31-Aug-2017
3910
Sql Server
You have below table CREATE TABLE Inventory (ItemID int NOT NULL PRIMARY KEY, ProductsInStore int NOT NULL, ProductsInWarehouse int NOT NULL) How to create a computed column that returns the sum total of the ProductsInStore and ProductsInWarehouse values for each row ?
29-Aug-2017
3775
Sql Server
Which Path parameter in the below JSON code snippet would NOT result in an error when used by JSON_VALUE in strict mode? DECLARE @jsonInfo VARCHAR(MAX) SET @jsonInfo = N'{ "info":{ "type":1, "address":{ "town":"Hyd", "state":"TS" "country": "India" }, "tags":["sport", "Water Polo"] }, "type":"Basic" }'
29-Aug-2017
3075
Sql Server
In which order should the below clauses be used in the query that works out the count of products within each category by grouping on the category, filtering by categories that contain more than one product and then sorting the results in category order ?
29-Aug-2017
2789
Sql Server
The id_num column of the below table is an auto increment column but what do the 2 numbers after the IDENTITY clause mean? CREATE TABLE new_employees ( id_num int IDENTITY(100,10), fname varchar (20), minit char(1), lname varchar(30) )
29-Aug-2017
3087
Sql Server
What is wrong with the below T-SQL batch statement ? @find varchar(30); SET @find = 'ABC'; SELECT LastName FROM Person WHERE LastName = @find;
29-Aug-2017
3174
Sql Server
Here is the JSON string DECLARE @jsonInfo VARCHAR(MAX) SET @jsonInfo = N'{ "info":{ "type":1, "address":{ "town":"Hyd", "state":"TS" "country": "India" }, "tags":["sport", "Water Polo"] }, "type":"Basic" }' what is the output of below query ? JSON_QUERY(jsonString, '$.info.address.town')
29-Aug-2017
3387
Sql Server
The table includes a DATETIME column named EventTime that stores the date and time of each Event. There is a non-clustered index on the EventTime column. To create a report that displays the total number of events happened on the current day, You need to write a query that will return the correct results in the most efficient manner. Which T-SQL query should you use?
29-Aug-2017
3410
Sql Server
which inbuilt function can be used to know the id value of the last row that was inserted, rather than re-run another query just to get the maximum id value ?
29-Aug-2017
2944
Sql Server
which of the following clause is used to return SQL resultset in JSON format in SQL Server2016?
29-Aug-2017
2940
Navigate to page:
1
2
3
4
5
6
7
8
...
16