I would like to ask, where there is about a stored procedure source code examples?

Category: C/C++ -> C Author: sxfylcysxfylcy Date: 2004-05-06 23:24:58
 
sxfylcysxfylcy
2004-05-06 23:24:58
I encountered some problems, I would like to ask, where there is a stored procedure on the source code examples? ? Who told me that I would send anyone 50
aileen_tang
2004-05-06 23:46:15
USE pubs

IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'au_info_all' AND type = 'P')
DROP PROCEDURE au_info_all
GO
CREATE PROCEDURE au_info_all
AS
SELECT au_lname, au_fname, title, pub_name
FROM authors a INNER JOIN titleauthor ta
ON a.au_id = ta.au_id INNER ; JOIN titles t
ON t.title_id = ta.title_id INNER JOIN publishers p
ON t.pub_id = p.pub_id
GO
jiangdan_9
2004-05-07 00:20:46
add, is sql_server7.0
benny_y
2004-05-07 00:38:06
you want WINDOWS API source code thing?