|
|
-
|
|
Recently in an interview i faced following questions.
Is it possible to call a trigger from another trigger?
Is it possible to call a trigger directly?...
|
|
-
|
|
How to change the length of a column defined with a Primary key constraint?...
|
|
-
|
|
Which Key Constraints enforces Enitity Integrity ,Referential Integrity and Domain Integrity?...
|
|
-
|
|
Which command is used to re-seed the identity value?...
|
|
-
|
|
Recently i came across this questions, "Is it possible to create a trigger on a table, which is in another database"...
|
|
-
|
|
What is Rainbow table?...
|
|
-
|
|
Which data types are Special Data types in SQL Server?...
|
|
-
|
|
Is it possible to call a function and stored procedure from a select statement?...
|
|
-
|
|
Suppose we have a table whose structure is given below
Create table addcounter(
counterid int identity(1,1)
)
Now how can we insert values in the table?...
|
|
-
|
|
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...
|
|