Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Interview Questions
How will you create a DML Trigger?
Posted By :
Posted Date :
April 21, 2011
The procedure to create a DML trigger is :
CREATE TRIGGER (TRIGGER_NAME)
AFTER (INSERT OR UPDATE OR DELETE)
PRINT 'THIS IS DOTNETSPARK'
You can also find related Interview Question to
How will you create a DML Trigger?
What is Private Constructor? and it's use? Can you create instance of a class which has Private Constructor?
When a class declares only private instance constructors, it is not possible for classes outside the program to derive from the class or to directly create instances of it. (Except Nested classes)
Make a constructor private if:
1) You want it to be available only to the class itself. For example, you might have a special constructor used only in the implementation of your class' Clone method.
2) You do not want instances of your component to be created. For example, you may have a class containing nothing but Shared utility functions, and no instance data. Creating instances of the class would waste memory.
Which index option causes SQL Server to create an index with empty space on
the leaf level of the index?
What are the requirements to create a CLR based user-defined type?
CLR must be enabled for the instance and A class created with a CLR-compatible language.
What do you need to specify to create a linked server?
OLE DB Data Source
To create a string literal exclude escape sequence
@string. With adding @ at the beginning you can escape literal
What is a trigger?
Triggers are basically used to implement business rules. Triggers is also similar to stored procedures. The difference is that it can be activated when data is added or edited or deleted from a table in a database.
What command is used to create a table by copying the structure of another table?
CREATE TABLE .. AS SELECT command
To copy only the structure, the WHERE clause of the SELECT command should contain a FALSE statement as in the following.
CREATE TABLE NEWTABLE AS SELECT * FROM EXISTINGTABLE WHERE 1=2;
If the WHERE condition is true, then all the rows or rows satisfying the condition will be copied to the new table.
How u can create XML file?
To write Dataset Contents out to disk as an XML file use:
Can I create your own custom templates in Sharepont?
Yes you can. You can have templates for business plans, doctor's office, lawyer's office, Educational, health etc and if you want to share with anyone else in SharePint community you can upload your own SharePoint templates to Microsoft website.
You cannot create an Index on a column of the following data type
Is it possible to create Cluster Index on Unique Key Column?
Unique key column by default creates a non-cluster index on the column. Primary key creates cluster index on the column. The only difference is Unique key column allows only one null value. So is it possible to have cluster index on Unique key column?
The answer is YES. Though Unique key allows null value but it still maintains the uniqueness of the column.
Which SQL command is used to create a set of privileges that can be granted to users or to other roles?
Is it possible to create cookies with keys? Explain using some example.
Yes, it is possible to create cookies with keys.
Cookies is a dictionary at the time of initialization, if key is specified with it. (You can determine whether cookie is dictionary or not using HasKeys property. )
For an example:
Response.Cookies("Testcookie")("key1") = "key1"
Response.Cookies("Testcookie")("key2") = "key2"
After this if you make assignment like,
Response.Cookies("Testcookie") = "noKey"
Then," key1" and "key2" of cookie("Testcookie") will be deleted.
What will you do if you need to create clustered index on more than one field? Is it possible?
The answer is yes and no.
You can create clustered index only one clustered index in table.
Either you can create index on entire table or you can create clustered index on a view covering entire table.
Suppose, you have created table with following:
CREATE TABLE [dbo].[Table1](
[field1] [int] IDENTITY(1,1) NOT NULL,
[field2] [nchar](10) ,
[field3] [nchar](10) ,
) ON [PRIMARY]
Create index on entire table:
CREATE INDEX idx_coverTable ON Table1(field1, field2) INCLUDE (field3, field4)
Create clustered index on a view covering entire table:
CREATE VIEW v1111 with SCHEMABINDING
SELECT field1, field2, field3, field4 FROM dbo.Table1
CREATE UNIQUE CLUSTERED INDEX idx_viewClustered ON dbo.v1111(field1, field2, field3, field4)
Quick Links For Interview Questions Categories:
Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.
So, Start looking our
section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.
Hall of Fame
Terms of Service
Tell A Friend