We have our SQL server configured to only allow Windows accounts (i.e. not mixed). However, in some cases we are connecting from non-domain boxes and we want to specify a domain account to connect to ...
The SQL Server 2005 database is available in various editions: Enterprise, Standard, Workgroup, Express, Developer, and Mobile. The Enterprise Edition is for enterprise-level applications that require ...
Windows 7 includes an ODBC manager that lets you connect from your desktop to a SQL server. You create a data source name (DSN) to save database setup information, so you can open a connection to the ...
If any of you have any suggestions on managing connection strings for your applications, I'd like to hear it. I know a couple of ways to do it, but I'm looking for the best way.<BR><BR>In .NET 1.1, ...
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 sample data in SQL is provided by Microsoft's AdventureWorks training database, which can be provided both on your own SQL server and directly as an Azure SQL Database. Microsoft provides ...
If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code. You are probably familiar ...