|
|
-
Manoj Commented 12 Months ago through Interview Questions | 1 Point
I think compile and syntax verification (or parsing) are 2 different things.
What I think is it does the syntax verification only not compile when you create it for the first time. That's why it even creates an SP even if you involve a table that does ...
|
-
Manoj Commented 12 Months ago through Interview Questions | 1 Point
>>When ever you create a stored procedure, its compiled and the Query execution plan is stored in Cache
I don't agree with the above stmt, when you create an SP, its not compiled nor its plan is created. It is compiled when it is executed for the fir...
|
-
Manoj Commented 2 Years ago through Interview Questions | 1 Point
Yes, got your point.
But your point #2 is misleading, it should have mentioned about dealing with duplicate rows....
|
-
Manoj Commented 2 Years ago through Interview Questions | 1 Point
So, you mean to say that UNION will not work here, right?
But here is the code with both UNION & UNION ALL & it works perfectly:
CREATE TABLE tblStudents(
[Studentid] [int] IDENTITY(1,1) NOT NULL,
[Firstname] nvarchar(50) ,
[Lastname] nva...
|
-
Manoj Commented 2 Years ago through Interview Questions | 1 Point
Can you elaborate your point #2, an example would be gr8....
|
-
Manoj liked 2 Years ago through Interview Questions | 1 Point
Interview questions and answers on various SQL Server areas such as Database Administration, TSQL Development, BI etc....
|