I use the ConnectionStrings.com site many times. Whehter it's MS SQL server or Oracle or MySql, they have the useful snippet of code for the connection string. It usually saves me time from looking up the manual. I thought I would dedicate this entry just for them.
If you don't know what connection string is then you are lucky to be reading this entry. In short, connection string is what defines how we connect to data sources and destinations. It enables application to talk to the database so that information is persisted in the RDBMS or target data structure.
A sample connection string may look like this... (Yes... I borrowed the connection string below from their site :) )
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
By Rajib Bahar at September 12, 2009 18:00
Filed Under:
Obama Health Care Speech At Target Center In Minnesota Part 1
http://www.youtube.com/rajib2k5
Tags:
I use these cheatsheets related to TSQL and/or SQL server from time to time.
I can not count on my memory, but, it would be nice to have a photographic one.
Enough of my rambling, here is the list:
TSQL Cheatsheet found at Scribd - http://www.scribd.com/doc/399147/TSQL-Cheat-Sheet
SQL Server Cheatsheet found at Scribd - http://www.scribd.com/doc/15235350/SQL-Server-TSQL-Cheatsheet
Dave Pinal or SQL Authority's Cheatsheet - http://www.pinaldave.com/sql-download/SQLServerCheatSheet.pdf
Did I miss any good ones? I'll update this