Recent posts
Recent comments
Author: Rajib
Calender
<<  July 2010  >>
MoTuWeThFrSaSu
2829301234
567891011
12131415161718
19202122232425
2627282930311
2345678
Blogroll
    rajib.bahar , Posted At 9/29/2009 7:25:00 AM

    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;


    Digg It!DZone It!StumbleUponTechnoratiRedditDel.icio.usNewsVineFurlBlinkListFacebook

    This posting is provided "AS IS" with no warranties, and confers no rights. It does not reflect any one's opinion other than the author.

    Currently rated 3.0 by 5 people

    • Currently 3/5 Stars.
    • 1
    • 2
    • 3
    • 4
    • 5

    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 



    Digg It!DZone It!StumbleUponTechnoratiRedditDel.icio.usNewsVineFurlBlinkListFacebook

    This posting is provided "AS IS" with no warranties, and confers no rights. It does not reflect any one's opinion other than the author.

    Be the first to rate this post

    • Currently 0/5 Stars.
    • 1
    • 2
    • 3
    • 4
    • 5