|
|
-
|
|
Name 3 ways to get an accurate count of the number of records in a table?...
|
|
-
|
|
Is it possible to call a function and stored procedure from a select statement?...
|
|
-
|
|
When you create a stored procedure you provide an option with RECOMPILE
What does this do?...
|
|
-
|
|
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...
|
|
-
|
|
Suppose you have Employee_mst table now how to find store procedure uses this Employee_Mst table? ...
|
|
-
|
|
What are the magic tables in SQL Server?...
|
|
-
|
|
Which database will affect if we install service pack in SQL Server?...
|
|
-
|
|
If a table has no clustered index defined on it, What it will be called?...
|
|
-
|
|
What is the difference between Union and Union All?...
|
|
-
|
|
In SQL SERVER, what are EXCEPT and INTERSECT?...
|
|