Learning of Sql using Sp(Store Procedure)

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

Learning of Sql using Sp(Store Procedure)

Author

Topic

feejaz
Yak Posting Veteran

68 Posts

Posted - 2007-12-05 : 03:30:07

Hi,
Can any body tell me how can I learn about Sql. I am now a days learning asp.net using C#. bUT can not under stand how to work with database.
Can any body tell me the online book that is easy to learn (Examples etc ).

Feejaz.

Navi

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-12-05 : 03:36:34

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

Madhivanan

Failing to plan is Planning to fail

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2007-12-05 : 04:08:53

Also the Books Online that comes with SQL Server , is very useful , once you know some of the basics

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com

feejaz
Yak Posting Veteran

68 Posts

Posted - 2007-12-05 : 05:19:22

Sorry,
Ithink I could not the message properly, I know anbout some thing but not very much. I want to know about how can make a connection of database in language. Get the Quries etc.
You can say it ADO

Feejaz.

Navi

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2007-12-05 : 05:26:15

For setting up the connection string you can check out the site...

www.connectionstrings.com

Chirag

http://www.chirikworld.com

feejaz
Yak Posting Veteran

68 Posts

Posted - 2007-12-05 : 06:26:12

Thanks for answering,

But I am searching like this type of study.
// Define database connection
SqlConnection conn = new SqlConnection("Server=localhost\\SqlExpress;Database=Abc;"+"IntegratedSecurity=True");
// Create command
SqlCommand comm = new SqlCommand(
"SELECT EmployeeID, Name FROM Employees", conn);
// Open connection
conn.Open();
// Execute the command
SqlDataReader reader = comm.ExecuteReader();
// TODO: Do something with the data
// Close the reader and the connection
reader.Close();
conn.Close();

Navi

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-12-05 : 07:12:47

Try sample codes at www.asp.net

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources