Today, I worked on automating the process of importing a structured .csv file into a table using SQL Server Management Studio (SSMS). Since I am working with a desktop-based SQL Server database, the ...
#SQLServer Script for archiving data in small batches If you are planning to Archive large tables in SQL Server, Don't just use one massive DELETE because you may end up filling up your logs and if ...
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 ...