Recent comments
Author: Rajib
Calender
<<  February 2012  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
2728291234
567891011
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 2.7 by 6 people

    • Currently 2.666667/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