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.
| Author |
Topic |
|
born2acheive
Yak Posting Veteran
65 Posts |
 Posted - 2006-12-01 : 04:17:16
|
| hi, i am new to stored procedures,i know how to write a simple stored prodedure like as follows:CREATE PROCEDURE login_select(@username varchar(50),@password varchar(50)) as select count(*) from login where username=@username and password =@passwordGObut i want to know more than this ie loops and some extra tough things.so please give me some efficient links to study about spc's.help me please |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-01 : 04:29:48
|
| Look here:[url]http://www.sqlteam.com/item.asp?ItemID=563[/url]Also google out, there are plenty of free tutorials available out there and of course, go through the BOL!Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2006-12-01 : 04:30:44
|
Try not to use loops !!!Visit this site regularly.Read some of the peoples blogs (On this site under weblogs)Browse through the script Library on this site.Look at some of Madhivanan's posts - he has a standard Lern SQL post where he provides links to SQL Learning websites.Duane.  |
|
|
|
born2acheive
Yak Posting Veteran
65 Posts |
Posted - 2006-12-01 : 04:33:27
|
| thank you harsh_athalye and ditch. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
help regarding stored procedures