skip to main | skip to sidebar

Dot Net Sample Chapters And Resources

Microsoft Visual Studio Standard 2005 | Microsoft Visual Studio Standard 2005 Upgrade
Microsoft Visual Studio Professional w/MSDN Professional 2005 renewal
Microsoft Visual Studio Team Edition for Software Architect 2005 w/MSDN Premium Renewal

Thursday, December 11, 2008

The Ten Most Asked SQL Server Questions And Their Answers

Check out this blogpost titled The Ten Most Asked SQL Server Questions And Their Answers



Here is what is in that post

1) Selecting all the values from a table for a particular date
2) Search all columns in all the tables in a database for a specific value
3) Splitting string values
4) Select all rows from one table that don't exist in another table
5) Getting all rows from one table and only the latest from the child table
6) Getting all characters until a specific character
7) Return all rows with NULL values in a column
8) Row values to column (PIVOT)
9) Pad or remove leading zeroes from numbers
10) Concatenate Values From Multiple Rows Into One Column

So check it out here: The Ten Most Asked SQL Server Questions And Their Answers

Posted by Denis at 2:40 PM

Labels: Database, SQL Server 2000, SQL Server 2005, SQL Server 2008

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)
Subscribe in a reader

Blog Archive

  • ►  2010 (2)
    • ►  April (1)
    • ►  January (1)
  • ►  2009 (16)
    • ►  September (8)
    • ►  August (2)
    • ►  June (1)
    • ►  April (1)
    • ►  March (4)
  • ▼  2008 (83)
    • ▼  December (3)
      • SQL Server 2005 Service Pack 3 has been released
      • CHESS: An Automated Concurrency Testing Tool
      • The Ten Most Asked SQL Server Questions And Their ...
    • ►  November (1)
    • ►  October (6)
    • ►  September (2)
    • ►  August (5)
    • ►  July (5)
    • ►  June (3)
    • ►  May (7)
    • ►  April (10)
    • ►  March (11)
    • ►  February (11)
    • ►  January (19)
  • ►  2007 (424)
    • ►  December (49)
    • ►  November (33)
    • ►  October (30)
    • ►  September (30)
    • ►  August (57)
    • ►  July (45)
    • ►  June (60)
    • ►  May (48)
    • ►  April (47)
    • ►  March (14)
    • ►  February (4)
    • ►  January (7)

Label Cloud

Links

  • ASP.NET Hacks
  • Database Blogs On Less Than Dot
  • SQL Server Programming Hacks
  • SQL Server Programming Forum
  • Less Than Dot
  • Photographs Of Places, Things And People
  • ASP.NET Library
  • Google Interview Questions
  • Technology News, Earnings, Mergers And Acquisitions
  • otherthingsnow
  • SQL Server Code,Tips and Tricks, Performance Tuning