Chapter 10 LINQ stored procedure not in my pubs db

mangel · April 1st, 2011, 07:19 PM

Does anyone have the SQL Server code for this sp:

usp_Get_Authors_By_State

My pubs doesn't have it.

Thanks.

ksharkey · April 1st, 2011, 11:01 PM

Quote:

Originally Posted by mangel

Does anyone have the SQL Server code for this sp:

usp_Get_Authors_By_State

My pubs doesn't have it.

Thanks.

Hello,

That stored procedure (and a few others) is defined in the examples.sql file. That should be in the sample code, let me know if not.

mangel · April 2nd, 2011, 02:11 AM

What chapter are they in?

ksharkey · April 2nd, 2011, 01:28 PM

Quote:

Originally Posted by mangel

What chapter are they in?

It's in the chapter 10 code, along with a batch file if you prefer the command-line, or you can use SQL Server Management Studio to load it.

mangel · April 2nd, 2011, 02:49 PM

Thanks Kent. All stored procs installed.