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
 Select help

Author  Topic 

btisdabomb2
Starting Member

12 Posts

Posted - 2006-06-19 : 10:39:43
This is my first time using SQL Server, anyways I have a select statement...

SELECT LinkName
FROM SWLinks
WHERE deletedts is null

I saved it as a stored procedure called ssp_SW_AllLinks What I need to do is call this stored procedure in a VB.NET application and have it give me all the link names that it returns. How would I do this?

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2006-06-19 : 13:49:28
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_vbcode/html/vbtskCodeExampleExecuteStoredProcedureThatReturnsValue.asp

Help us help YOU!
Read this blog entry for more details: http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx

*need more coffee*
SELECT * FROM Users WHERE CLUE > 0
(0 row(s) affected)
Go to Top of Page

btisdabomb2
Starting Member

12 Posts

Posted - 2006-06-19 : 14:10:40
Sorry Im new to this and I have no clue. Thanks for the link though, that helped.
Go to Top of Page

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2006-06-21 : 11:11:03
Glad it helped. Feel free to ask any other questions when you have them.

Help us help YOU!
Read this blog entry for more details: http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx

*need more coffee*
SELECT * FROM Users WHERE CLUE > 0
(0 row(s) affected)
Go to Top of Page
   

- Advertisement -