What will be the values returned by the COUNT(*) statements ? (select - ProProfs Discuss
Topics
Products
Follow Us:

What will be the values returned by the COUNT(*) statements ? (select the answer that show the 3 values in correct order)CREATE TABLE #TempTable (RowID INT)CREATE TABLE UserTable (RowID INT) BEGIN TRAN INSERT UserTable (RowID) VALUES (1)ROLLBACK INSERT UserTable (RowID) VALUES (2) BEGIN TRAN INSERT #TempTable (RowID) VALUES (1)ROLLBACK INSERT #TempTable (RowID) VALUES (2) DECLARE @TableVariable TABLE (RowID INT) BEGIN TRAN INSERT @TableVariable (RowID) VALUES (1)ROLLBACK INSERT @TableVariable (RowID) VALUES (2) SELECT COUNT(*) FROM UserTable SELECT COUNT(*) FROM #TempTableSELECT COUNT(*) FROM @TableVariable DROP TABLE #TempTableDROP TABLE UserTable

This question is part of SQL Server TSQLQuiz - 8
Asked by Gunax, Last updated: Mar 29, 2020

+ Answer
Request

1 Answer

gunax

Gunax

Answered Jan 05, 2019

1,1,2
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.