Use custom-built .NET Framework 4.0 classes to connect an ASP.NET Web application to a SQL Server 2012 database. In my recent article, I showed how to connect .NET 4.0 C# and Visual Basic applications ...
Technology Toolbox: VB.NET, C#, SQL Server "Yukon" All versions of SQL Server prior to SQL Server "Yukon" provide two ways to write procedural code that executes inside the database. The usual way is ...
The Microsoft OLE DB Provider is an SQL tool that enables developers to write code that provides an application with ADO access to an SQL database. The OLE DB Provider is not installed by default when ...
Microsoft has a guide on naming conventions for C#, etc. Is there something similar for SQL Server?<BR><BR>i.e. names for tables, columns, stored procedures, stored procedure variables, ...
I have written an application that takes in a fixed-width file (thanks in no small part to advice I recieved in a seperate thread) and then dissasembles each line, runs a fairly meaty SQL SELECT query ...
A best practice when generating DataSet objects is to minimize the number of records returned by SqlDataAdapter objects. This works for VS.NET applications whose users have direct network connections ...
Today is the first day of Microsoft's Ignite 2018 conference in Orlando, and it announced SQL Server 2019, a public preview of which will be available today. The promise of the new database management ...