sprocs

I'm hoping others will be willing to share their top N lists of things you should not do in tsql sprocs and user defined functions.

ASP.NET Forums joeastral 2010

I'm hoping others will be willing to share their top N lists of things you should not do in tsql sprocs and user defined functions.

ASP.NET Forums joeastral 2010

Also, you can't do sprocs in Access, nor CTEs, which are the best way to do paging. gavinharriss

ASP.NET Forums 2009

Following that I rewrote the sprocs using sp_executesql until I could implement full-texting for search (which I've already done); next up is a smart table partitioning scheme.

SSWUG.ORG Articles 2009

Kind of a pain, but not terrible; this user only had about 20 sprocs he could select.

ASP.NET Forums golddog 2009

It can find the database fine -- it just never bothered to create all the tables and sprocs it was supposed to!

ASP.NET Forums aaava 2009

Kind of a pain, but not terrible; this user only had about 20 sprocs he could select.

ASP.NET Forums 2009

I even went to the trouble of taking all the aspnetdb. mdf tables / sprocs / views etc and moving them into my personal. mdf and I renamed the personal. mdf, etc.

ASP.NET Forums psully1876 2008

The wizard allows you to select a database, and then the tables, views and sprocs within it that you want to build a LINQ to SQL data model around:

ScottGu's Blog 2008

-- Configure the web app user whose credentials will be used by the web app to connect and execute sprocs.

unknown title 2008