i'm new using SQl Server Management Studio...and i have my project (Pharmacy) all i did was the tables and the relationships....and i have to create procedures ...... if any one can help me with them and explain it to me...besides something known as TRIGGERS...how are these created too

thanks alot

You may start from this link http://msdn.microsoft.com/en-us/library/ms191436.aspx and follow the links from it.

Few more links

http://www.sql-server-performance.com/articles/dba/stored_procedures_basics_p1.aspx

http://www.coderecipes.net/sql-stored-procedure-tutorial.aspx

http://www.mssqltips.com/tutorial.asp?id=160

see this

http://www.sqlteam.com/article/an-introduction-to-triggers-part-i 

>if any one can help me with them and explain it to me...besides something known as TRIGGERS...how are these created too

Whilst there are a few situations where triggers are necessary, they are best avoided. Instead look to encapsulationg the required logic in stored procedures.

all these links provided are really helpfull but i just need simple explaination (the format) on how to write the following:

1. Procedures ( and its type )  [so that i could apply more than 1 procedure on my project]

2. Triggers ( with the types )

3. Order Triggers [ i don't know if this is its correct name but all i know is that it helps arrange the triggers in order of function, which one to be executed first in case of more than 1 trigger ]

4. Rules [ how to enable a rule and disable it on the system for example: (DISABLE IT FROM 4 P.M. UNTIL THE NEXT DAY 8 A.M) ]

Considering item 4 - you almost certainly need to use stored procedures and / or functions, as they can include logic that varies by time of day.

Ordering of triggers is a challenge - far better to use a combination of stored procedures and user functions.

I suggest you start by reading the SQL Books On-Line.

Given the specialist nature of your question, it would be better asked at:

• SQL Server Team http://www.sqlteam.com/forums/
• SQL Server Central http://www.sqlservercentral.com/
• SQL Server at MSDN http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1

Please post link(s) to any threads you raise on those forums so that other may follow you.

One further point - please provide a more meaningful subject line in future and avoid the use of words like "Urgent". With the exception of the MSFT team, we are not paid to answer questions on this forum and there are contributors to this forum that will actually ignore threads with a title such as "urgent help". Please help us to help you by using a concise but meaningful title.

Hi,

TATWORTH:

Whilst there are a few situations where triggers are necessary, they are best avoided. Instead look to encapsulationg the required logic in stored procedures.

Yes I agree with TATWORTH.

I found some collectionreagrding sql stuff

There are videos and as well as source codes in both vb.net And c#.net .

http://www.asp.net/learn/sql-videos/

http://www.asp.net/learn/data-videos/

Follow Below Link

It Contains Pdf  And As well As Source codes in Both Vb.net And C#.net That Will Guide U.

http://www.asp.net/learn/data-access/

Refer These Also

http://www.w3schools.com/sql/
http://www.sqlservercentral.com/Articles/
http://www.sqlcourse.com/
http://msdn.microsoft.com/en-us/sqlserver/default.aspx
http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx
http://www.microsoft.com/learning/2005/sql/default.mspx
http://www.baycongroup.com/basic_sql_commands.htm
http://en.wikipedia.org/wiki/SQL
http://forums.asp.net/thread/2809250.aspx

Ado.net Tutorials 

http://www.sitepoint.com/article/introduction-ado-net/
http://www.w3schools.com/aspnet/aspnet_dbconnection.asp
http://www.codeproject.com/kb/database/SQLConnectBymysorian.aspx
http://aspnet.4guysfromrolla.com/articles/032702-1.aspx
http://en.wikibooks.org/wiki/ASP.NET/Database

http://www.startvbdotnet.com/ado/default.aspx
http://www.devarticles.com/c/a/ADO.NET/A-Practical-Comparison-of-ADO-and-ADO.NET/1/
http://en.wikipedia.org/wiki/ADO_vs_ADO.NET

 
 

Procedures Links

http://databases.about.com/od/sqlserver/a/storedprocedure.htm
http://www.sql-server-performance.com/articles/dba/stored_procedures_basics_p1.aspx
http://www.sqlteam.com/article/stored-procedures-returning-data
http://msdn.microsoft.com/en-us/library/aa174792.aspx

Triggers Links

http://msdn.microsoft.com/en-us/library/sdk3bcyw(VS.80).aspx
http://www.codeproject.com/KB/database/SquaredRomis.aspx
http://www.sql-server-performance.com/articles/dev/triggers_2000_p1.aspx
http://msdn.microsoft.com/en-us/library/ms189799.aspx

Views Links

http://www.w3schools.com/SQL/sql_view.asp
http://www.sql-server-performance.com/articles/dev/views_in_sql_server_p1.aspx
http://www.techonthenet.com/sql/views.php
http://msdn.microsoft.com/en-us/library/aa937438(SQL.80).aspx

Indexes links
http://www.mssqlcity.com/Tips/tipInd.htm
http://www.odetocode.com/Articles/237.aspx
http://www.simple-talk.com/sql/learn-sql-server/sql-server-index-basics/
http://forums.asp.net/p/1337024/2697193.aspx#2697193
http://www.paladn.com/sql-server-indexes.htm
http://www.mssqltips.com/tip.asp?tip=1206
http://www.odetocode.com/Articles/70.aspx
http://www.sqlteam.com/article/sql-server-indexes-the-basics

Dark-Angel:

i'm new using SQl Server Management Studio...and i have my project (Pharmacy) all i did was the tables and the relationships....and i have to create procedures ...... if any one can help me with them and explain it to me...besides something known as TRIGGERS...how are these created too

This is like asking "I want to build a house.  Can someone show me how?"  Please be more specific, or it's impossible to provide a meaningful answer.

what do your procedures need to do?

what does your schema look like?

why do you think you need triggers?

what are the triggers supposed to do?

are you trying to just get something working? or does it need to run fast?

this is an ASP.NET forum.  are you also trying to interface your DB to a web page?

You might consider posting your current schema and a first attempt at writing a stored procedure.  That will give us something to go on.

ok ... sorry for interrupting...but  i didn't know about ASP that much...i'll look for SQL forums....anyways thanks for your help and replies :)