Tag Archive : SQLServer 2005 Management Studio

Where is the Connection String ?

Posted on May 27, 2009 in: SQLServer 2005|Post Comment

3
Digg me

Is this a bug in SQL Server 2005 Sp3 or a feature ?

SQL Server 2005 Management Studio Sp2

SQL Server 2005 Management Studio Sp3

Where is the Connection String ? How are we supposed to import data from ODBC data sources ?

How to Save Query results as .CSV or Excel file using SQLServer 2005 Studio

Posted on June 11, 2008 in: Database, SQLServer 2005|1 Comment

0
Digg me

Here is the simple way to save query results as .csv or .xls  file using SqlServer Management Studio.

Execute your query

Example : Select * from AdventureWorks.Person.Address
Right Click on Left top corner

Select “Save Result As” to save as .csv file

OR

Select “Copy” and paste the result in an Excel sheet.