SqlServer-QA.net

This is for newbies who struggle to understand how single quotes work in SQL Server I have seen newbies worrying why the following doesnt work SELECT columns from mytable where col ='Lifco's' When you specify a value which has single quote, you need to double it SELECT columns from mytable where col ='Lifco''s' The following may be ...

Still most of the users in SQL Server 2005 are afraid of using SSIS - SQL Server Integration Services for their ETL process and procedures. I would say the newbie users are in luck to obtain help easily on the web by referring to the blogs and forums/newsgroups in this cyber age. In this regard Microsoft Documentation team has given ...

I have multiple access dbs that i would like to import into ms sql 2005 workgroup server with the eventual intent of creating reports by querying the import dbs. Any suggestions on how to begin such a project?  wannadba1

Thanks so much!  These look like great places to start. Thanks again!

I am an absolute beginner to the database world.  I have been thown into database testing and know nothing.  I have searched the internet for some of the key words I have heard our developers use, however, I need a good starting point (preferrably a book) that will go through the basics - what are the different types of queries, what are ...

Please post your basic questions about usage of SQL Server in your arena in order to help you get the directive of required information. Thanks