Even in a Code First environment, you can call a stored procedure from a DbContext object. But it's a lot easier if you use the visual designer. I frequently get asked if Entity Framework (EF) in a ...

The PHP development language provides you with a "prepare" function to send a prepared statement to a SQL database. You can use full, inline SQL statements in the prepared statement function or send ...

Entity Framework 6 gives you a variety of ways to call stored procedures that return data and capture the results those procedures return. Here's a look at all of them. In an earlier column, I showed ...

I still do development in old style ASP pages with vbscript for a bunch of internal apps for my company. I've recently started converting some of these pages that used to simply use recordset objects ...

We have a server with full text searching enabled and another where it is not. We have a stored proc that checks if full text indexing is enabled and runs a search query as appropriate but the issue ...

Execute SQL tasks run stored procedures or SQL queries from SSIS packages. A task executes any SQL statements that have been passed to it in sequential order. It provides you with a handy way to store ...

[PROGRAMMERS REPORT, OCTOBER 8, 2002] -- Among the finger-pointing games in development today, none are more common than those accompanying the discussions between application developers and database ...

NetCOBOL for .NET's verifiable code combined with Microsoft SQL Server "Yukon" support for Common Language Runtime server-side procedures enables reuse of COBOL routines. At the opening of Microsoft ...

The basic concept of recursion is straightforward: a given chunk of code calls itself until some boundary condition is reached. Arthur Fuller demonstrates how to use recursion in T-SQL. TechRepublic’s ...