help on index and trigger - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

help on index and trigger

Author

Topic

ameya_amu
Starting Member

25 Posts

Posted - 2006-08-16 : 06:39:40

Hello Friends,

I am new to sql server. i am not understanding use of index and trigger. Please can any one help me by providing links or examples.

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-08-16 : 06:49:19

for Index check out this thread
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=70451

for Triggers

They are Events which are fired when any DML(Insert,Update,Delete)
Statements are executed on the particular table.

Its always good read about any topic on Book online, you will get same
simple samples over there to make your fundamental clear.

Hope this helps.

Chirag

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-08-16 : 06:50:02

An index is like the index of a book. It will help you find things faster.
Triggers are automatic code snippets that are executed whenever a change is made to the data in a table. With SQL Server 2005, there are also triggers for detecting whenever the layouts are changed.

Peter Larsson
Helsingborg, Sweden

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-08-16 : 06:55:11

also refer this sites.

http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

Chirag

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-08-16 : 06:56:53