SQL - Connection String Example

Almost every time that I have to manually write a connection string, I have to search www.connectionStrings.com for the right one. It's a good site, they do have the references, but for what I need it's overly complicated.

Below are the connection strings that I use daily


Calling a web service from SQL
Case sensitive SQL queries
Connection String Example
Copy ANY TABLE from one database to another
Create (and restore a database to) a TEST server for app testing
Creating a date calendar table
Find table and field a particular value reside
Find tables that have no permissions granted, and fix them
Get a person's age from their birthdate
Get the text of all the triggers in a database
Group by Grouping Sets example
How to format T-SQL
Insert an image into a SQL table from SQL
Log the user that changed a field
Loop through a string and show ASCII characters
Paging query contest
Parsing @tags from a SQL text field
Query that adds a blank like to the result set if the original resultset has more than one line
Remove unwanted characters from a field in SQL
sp_send_dbmail example
SQL code to resequence a grid
SQL Trigger Nest Level
Strip leading zeros
Suppress the results of a stored procedure
Table Value Constructors

... and you 'll find more on the SQL (General) Menu

VB, VBA connection to SQL 2000 or later:

"PROVIDER=SQLOLEDB;DATA SOURCE=myServerName;INITIAL CATALOG=two;User ID=myUser;Password=myP@ssw0rd;"

RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.

Links
Home
Knowledge Areas
Sitemap

Contact

Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences

SQL - Connection String Example

Related Articles

... and you 'll find more on the SQL (General) Menu