|
|
-
|
|
What is MSX / TSX in SQL Agent ?...
|
|
-
|
|
While database is recovering, after which phase will the database be available/online?...
|
|
-
|
|
what are the Out puts of below Statements?...
|
|
-
|
|
how can you find Server Edition?...
|
|
-
|
|
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?...
|
|
-
|
|
I have a stored procedure like below and have created a temporary table inside it and have not written any drop statement for this Temporary Table.
Now when i execute this procedure for first time it will create the temporary table. Now when i run this procedure for second time, will it execute successfully or it will throw and an error stating "Table already exists in database".
Test procedure.
CREATE procedure [dbo].[testtemptable]
as
begin
create table #testtemptable
(
a varchar(10) null
)
end...
|
|
-
|
|
When you create a stored procedure you provide an option with RECOMPILE
What does this do?...
|
|
-
|
|
In SQL SERVER, what are EXCEPT and INTERSECT?...
|
|
-
|
|
Which database will affect if we install service pack in SQL Server?...
|
|
-
|
|
In SQL Server, how do you find un-used stored procedures and un-used views?...
|
|