SQL Server Developer Center
 
Sign in
United States (English)Drop down arrow
Brasil (Português)Česká republika (Čeština)Deutschland (Deutsch)España (Español)France (Français)Indonesia (Bahasa)Italia (Italiano)România (Română)Türkiye (Türkçe)Россия (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語)
 
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
Ask a question
Quick access
  • Forums home
  • Browse forums users
  • FAQ
Announcement: 3

SQL Server Samples and Community Projects announcement

  • Link
    How to Use this Forum - Please Read Before Posting
    Mr. Wharty Tuesday, October 02, 2012 4:49 AM

    Welcome to the SQL Server Samples and Community Projects Forum.

    This forum is the place to discuss all things "samplish" in the SQL Server community and samples space, whether it's an "official Microsoft sample" or a community project in CodePlex or Code Gallery. This is*not* the place to discussion specific nuances of T-SQL syntax or wage data modeling methodology wars: there are lots of other forums for those purposes. This one is for questions about samples, community projects and conversations between the collaborators that build them.

    Some examples of projects that are open for discussion can be found here: http://www.codeplex.com/SqlServerSamples. It doesn't have to be listed there to be fair game, but it's a good bet that it is fair game if it's already listed there.

    Below are a few guidelines to help you find your answer quickly and also to help the people who answer the questions, answer yours correctly.

    • Is your question about SQL Server Samples and Community Projects . If it's not please locate the correct forum otherwise your question may be moved, closed/locked or deleted.
    • Try searching the forum . Search the forum to see if your question has been asked before and answered.  If you cannot find what you are looking for, please start a new thread rather than adding to an old one as some people do not see answered questions in their forum views so you may not get the assistance you're looking for.
    • Don't be brief . The more information you can give in your question, the better the response will be.
    • Check your alerts . You can subscribe to a question so that you can see any update on it (ReferSetting up your alerts below).
    • No Spam. Spamming will have your thread deleted and may also result in your account being banned.
    • Be polite.  You will get better assistance if you're polite to other members so no flaming or trolling.  If you persist with flaming or trolling, your accountmay get banned.
    • Mark your question answered. If someone answers your question please mark their reply as the answer to your question. You can also mark multiple replies as answers if you think they answered your question.  Marking replies not only assists others with similar questions, it also let's people know that you're grateful for their assistance.

    Dead thread/Answer policy.

    Where possible the moderators will allow sufficient time for the original poster to come back and mark the replies to their questions as answers. The amount of time is at the discretion of the individual moderator but is suggested that it will be declared dead after a week if the original poster does not respond . We will always try to be fair and mark suitable replies as answers.

    Setting up your alerts

    If you are having trouble receiving alerts on the threads you have created or replied to please see thisthread for troubleshooting advice.

  • Link
    Samples bugs and suggestions.
    David Reed (Glacier Peak) Monday, February 02, 2009 4:26 PM
    All of the work items for our community projects and product samples are in TFS on CodePlex. If you want to report a bug, suggest a change for an existing sample or suggest a new sample, create a work item in the appropriate project so that our community team (not just Microsoft employees) can vote on them, help us triage and prioritize them.

    For example, here's the URL for the work items for AdventureWorks: http://www.codeplex.com/MSFTDBProdSamples/WorkItem/AdvancedList.aspx
  • Link
    Welcome aboard! Community & Samples Forum Intro
    David Reed (Glacier Peak) Thursday, January 29, 2009 9:58 PM

    This forum is the place to discuss all things "samplish" in the SQL Server community and samples space, whether it's an "official Microsoft sample" or a community project in CodePlex or Code Gallery. This is *not* the place to discussion specific nuances of T-SQL syntax or wage data modeling methodology wars: there are lots of other forums for those purposes. This one is for questions about samples, community projects and conversations between the collaborators that build them.

     

    Some examples of projects that are open for discussion can be found here: http://www.codeplex.com/SqlServerSamples/ It doesn't have to be listed there to be fair game, but it's a good bet that it is fair game if it's already listed there.

     

    Also, please post your project announcements here when you create a new release or a whole new project. If you're looking for people to work on your project or looking for a project to work on, this would be a good place to do both.

     

    Let us know what's missing, let know what could be better and let us know what we're doing right!

  • Remove From My Forums

Forums [ view all ]

Selected forums

Clear
SQL Server Samples and Community Projects
x
Filter : All threads
All threads
Answered
Unanswered
Proposed answers
General discussion

No replies
Helpful
Has code

All languages
Sort : Most recent post
  • Most recent post
  • Most recent thread
  • Total votes
  • Total replies
  • large check mark
    1 Votes

    AdventureWorks is being replaced by World Wide Importers starting in SQL Server 2016

    SQL Server
     > 
    SQL Server Samples and Community Projects
    The AdventureWorks sample databases have been released for SQL Server 2016, but will not be updated or maintained going forward. The product team has released a new sample database called World Wide ...
    Sticky | 1 Replies | 3488 Views | Created by Samuel Lester - MSFT - Monday, June 13, 2016 6:56 PM | Last reply by Olaf Helper - Monday, June 13, 2016 7:06 PM
  • large check mark
    7 Votes

    Finding the Correct Version of the AdventureWorks Sample Database

    SQL Server
     > 
    SQL Server Samples and Community Projects
    As the AdventureWorks sample database has evolved over the years, there are many different editions to decide from.  The following blog post will help you pick the correct version to get started, ...
    Sticky | 17 Replies | 19059 Views | Created by Samuel Lester - MSFT - Thursday, August 23, 2012 8:44 PM | Last reply by CigarDoug - Wednesday, September 09, 2015 1:24 PM
  • large check mark
    3 Votes

    SQL Server 2012 Developers Training Kit

    SQL Server
     > 
    SQL Server Samples and Community Projects
    The SQL Server 2012 Developer Training Kit includes technical content including labs, demos and presentations designed to help you learn how to develop SQL Server 2012 database and BI solutions. New ...
    Sticky | 0 Replies | 16210 Views | Created by Mr. Wharty - Wednesday, May 23, 2012 1:00 AM
  • large check mark
    1 Votes

    Microsoft SQL Server 2008 R2 SR1 Product Code Samples

    SQL Server
     > 
    SQL Server Samples and Community Projects
    The following link contains product code samples (without database files) for Microsoft SQL Server 2008 R2 ...
    Sticky | 0 Replies | 16313 Views | Created by Mr. Wharty - Wednesday, May 23, 2012 12:53 AM
  • large check mark
    6 Votes

    Where do I get the AdventureWorks log file? Getting error when attaching AW .mdf file. Says "error .ldf log file not found"

    SQL Server
     > 
    SQL Server Samples and Community Projects
    Where do I get the AdventureWorks log file? Getting error when attaching AW .mdf file. Says "error .ldf log file not found" I figured I would just copy one of the other ...
    Answered | 9 Replies | 16799 Views | Created by Nantz1 - Sunday, October 21, 2012 11:50 PM | Last reply by shreeharshas - Monday, November 20, 2017 8:17 AM
  • large check mark
    0 Votes

    How was the AdventureWorksDW2012.dbo.FactInternetSales loaded?

    SQL Server
     > 
    SQL Server Samples and Community Projects
    I have been trying to figure out how the "AdventureWorksDW2012.dbo.FactInternetSales" table was loaded. The following are its columns:  [ProductKey] [int] NOT ...
    Unanswered | 0 Replies | 114 Views | Created by bhlee90 - Sunday, November 19, 2017 4:43 AM
  • large check mark
    2 Votes

    What are the different betweent DataBases installing and deploying?

    SQL Server
     > 
    SQL Server Samples and Community Projects
    We offen say deploy database, or say install database, what is their different? Can I think they are the same things? like this, or refer to ...
    Answered | 2 Replies | 98 Views | Created by zhgart - Thursday, November 16, 2017 3:02 AM | Last reply by Gnana Balaji Kanagaraj - Thursday, November 16, 2017 6:13 AM
  • large check mark
    0 Votes

    Once quote no is generated insert into another table using a SQL Trigger

    SQL Server
     > 
    SQL Server Samples and Community Projects
    I am very new at triggers infact this is my first one and i am rather flustered and confused! I need all the help i can get. My main aim is the ...
    Unanswered | 8 Replies | 214 Views | Created by JR83 - Monday, October 16, 2017 11:42 AM | Last reply by Tom Phillips - Tuesday, October 17, 2017 11:12 AM
  • large check mark
    1 Votes

    Grouping or Aggregating like Items

    SQL Server
     > 
    SQL Server Samples and Community Projects
    Just diving into SQL and had seen a report format that I like and was hope this is the right forum to ask. i am familiar with basic select statements and grouping but I am stumped on how to ...
    Answered | 7 Replies | 252 Views | Created by tim_thebackpack - Tuesday, October 03, 2017 8:19 PM | Last reply by tim_thebackpack - Wednesday, October 04, 2017 3:42 AM
  • large check mark
    0 Votes

    Wildcard in LINQ

    SQL Server
     > 
    SQL Server Samples and Community Projects
    Hi. In the Linq below, what should be inside "Contain", so that it is equivalent to '%2[0-9][0-9]-%' in SQL? these are the matching ...
    Unanswered | 1 Replies | 1072 Views | Created by wkpli - Friday, January 27, 2017 8:25 PM | Last reply by THines01 - Friday, September 22, 2017 3:35 AM
  • large check mark
    0 Votes

    no database

    SQL Server
     > 
    SQL Server Samples and Community Projects
    I've lost the ability to create a database. I have windows7
    Unanswered | 1 Replies | 382 Views | Created by connieklap - Wednesday, August 23, 2017 5:10 AM | Last reply by Olaf Helper - Wednesday, August 23, 2017 5:42 AM
  • large check mark
    0 Votes

    Problems with code: AERP_80_2017.dbo.PRC_RAP_LiBlerje_Deklarata_TVSH '08/01/2017', '08/31/2017', '01/01/2017', '12/31/2017', 'AERP_80_2016'

    SQL Server
     > 
    SQL Server Samples and Community Projects
    I am using a program that is based on sql 2008r2. I have a problem because a document is not openning showing me the error: "General SQL Server error: Check ...
    Unanswered | 2 Replies | 428 Views | Created by adas1234 - Wednesday, August 09, 2017 2:33 PM | Last reply by scott_morris-ga - Thursday, August 10, 2017 1:37 AM
  • large check mark
    0 Votes

    restore AdventureWorks2016CTP3 fails on SQL 2016 Developer

    SQL Server
     > 
    SQL Server Samples and Community Projects
    Hi, all. I have tried to restore sample database AdventureWorks2016CTP3 downloaded from https://www.microsoft.com/en-us/download/details.aspx?id=49502 and failed. Looking for ...
    Answered | 7 Replies | 609 Views | Created by aalub - Thursday, August 03, 2017 4:48 PM | Last reply by aalub - Saturday, August 05, 2017 10:24 AM
  • large check mark
    0 Votes

    SQL Studio Manager 2017 can't restore any database!

    SQL Server
     > 
    SQL Server Samples and Community Projects
    Hello folks! I am facing unusual issue with restore any database through SQL Studio Manager. I have downloaded AdventureWorks 2012, 2014 and ...
    Proposed | 17 Replies | 608 Views | Created by tocy - Sunday, July 23, 2017 7:23 PM | Last reply by Satish Kumar Gajula - Tuesday, July 25, 2017 3:48 PM
  • large check mark
    0 Votes

    How to run select query to display column values in correct asc order, if values have letters as lead

    SQL Server
     > 
    SQL Server Samples and Community Projects
    <g class="gr_ gr_54 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation only-ins replaceWithoutSep" data-gr-id="54" id="54">Hi</g> I am very new to SQL ...
    Proposed | 1 Replies | 513 Views | Created by ojoc - Wednesday, July 12, 2017 12:14 AM | Last reply by Lin Leng - Wednesday, July 12, 2017 8:21 AM
  • large check mark
    0 Votes

    SQL Server R Services Tutorials - errors

    SQL Server
     > 
    SQL Server Samples and Community Projects
    Hello guys, I am super keep to start using R with SQL Server (so far worked with the latter, the former is not very new to me, but still need to learn how to ...
    Unanswered | 3 Replies | 1368 Views | Created by Hikari_PL - Sunday, February 05, 2017 12:00 PM | Last reply by 高木ジニー - Thursday, June 29, 2017 6:51 PM
  • large check mark
    0 Votes

    StoreFront for SQL Server 2014

    SQL Server
     > 
    SQL Server Samples and Community Projects
    Hello, I really need your help ASAP, I downloaded SQL server 2014 and the AdventureWorks sample database 2014 and every thing is great so far. Now I need an ...
    Unanswered | 2 Replies | 839 Views | Created by mbarrak - Sunday, April 02, 2017 7:52 AM | Last reply by mbarrak - Monday, April 03, 2017 6:45 AM
  • large check mark
    0 Votes

    AdventureWorksDW2012 Download

    SQL Server
     > 
    SQL Server Samples and Community Projects
    Hello, I'm trying to download the AdventureWorksDW2012 database to my SQL 2012 but keep getting this error, "This file does not have a program associated ...
    Unanswered | 1 Replies | 1636 Views | Created by utoktome - Wednesday, March 15, 2017 7:22 PM | Last reply by scott_morris-ga - Wednesday, March 15, 2017 8:01 PM
  • large check mark
    0 Votes

    STUFF Function

    SQL Server
     > 
    SQL Server Samples and Community Projects
    Greetings, I am using SQL Server 2008 R@ and i am stumped on trying to put all values from a field in my talble into one ROW.  example.  I have a Table called Items.  It only has ONE ...
    Answered | 2 Replies | 1017 Views | Created by Paul 2 U - Thursday, February 16, 2017 1:09 PM | Last reply by Paul 2 U - Thursday, February 16, 2017 3:42 PM
  • large check mark
    1 Votes

    MSBI Project

    SQL Server
     > 
    SQL Server Samples and Community Projects
    Good Morning, This is Ramesh. I have learnt MSBI . But i don't have experience in Real time. Can you send me real time project of SSRS,SSIS & SSAS projects with solution?Then I ...
    Unanswered | 2 Replies | 1256 Views | Created by Rameshpinni - Friday, February 10, 2017 4:39 AM | Last reply by philfactor - Friday, February 10, 2017 5:31 PM
  • large check mark
    0 Votes

    Trying to create a table..

    SQL Server
     > 
    SQL Server Samples and Community Projects
    ...
    Answered | 3 Replies | 1034 Views | Created by JdeBear - Tuesday, February 07, 2017 12:05 AM | Last reply by JdeBear - Tuesday, February 07, 2017 3:08 AM
  • large check mark
    0 Votes

    R Services tutorial problem

    SQL Server
     > 
    SQL Server Samples and Community Projects
    I have a problem with the Microsoft tutorial at https://www.microsoft.com/en-us/sql-server/developer-get-started/r The tutorial is about creating a predictive model in SQL ...
    Unanswered | 0 Replies | 1054 Views | Created by Jollyer - Tuesday, January 31, 2017 12:41 AM
  • large check mark
    1 Votes

    Adventureworks 2014 DB

    SQL Server
     > 
    SQL Server Samples and Community Projects
    I have a question regarding Adventureworks 2014 db I am missing a table (person.contact) and there is no ContactID in all of the db. I have been struggling to find why this is the ...
    Answered | 10 Replies | 1767 Views | Created by MajShah - Monday, December 05, 2016 11:57 PM | Last reply by MajShah - Tuesday, December 06, 2016 9:30 PM
  • large check mark
    0 Votes

    BusinessEntityID - Need help understanding.

    SQL Server
     > 
    SQL Server Samples and Community Projects
    So the new AdventureWorks  is an ultra normalized database and the concept is completely new to me and I have a question about how it would work. My understanding is the BusinessEntityID is the ...
    Answered | 4 Replies | 14415 Views | Created by adamus1986 - Sunday, February 08, 2009 9:56 AM | Last reply by Ulysses B Brown Jr - Thursday, November 24, 2016 12:43 AM
  • Items 1 to 20 of 474 Next ›
Announcement: 3

SQL Server Samples and Community Projects announcement

  • Link
    How to Use this Forum - Please Read Before Posting
    Mr. Wharty Tuesday, October 02, 2012 4:49 AM

    Welcome to the SQL Server Samples and Community Projects Forum.

    This forum is the place to discuss all things "samplish" in the SQL Server community and samples space, whether it's an "official Microsoft sample" or a community project in CodePlex or Code Gallery. This is*not* the place to discussion specific nuances of T-SQL syntax or wage data modeling methodology wars: there are lots of other forums for those purposes. This one is for questions about samples, community projects and conversations between the collaborators that build them.

    Some examples of projects that are open for discussion can be found here: http://www.codeplex.com/SqlServerSamples. It doesn't have to be listed there to be fair game, but it's a good bet that it is fair game if it's already listed there.

    Below are a few guidelines to help you find your answer quickly and also to help the people who answer the questions, answer yours correctly.

    • Is your question about SQL Server Samples and Community Projects . If it's not please locate the correct forum otherwise your question may be moved, closed/locked or deleted.
    • Try searching the forum . Search the forum to see if your question has been asked before and answered.  If you cannot find what you are looking for, please start a new thread rather than adding to an old one as some people do not see answered questions in their forum views so you may not get the assistance you're looking for.
    • Don't be brief . The more information you can give in your question, the better the response will be.
    • Check your alerts . You can subscribe to a question so that you can see any update on it (ReferSetting up your alerts below).
    • No Spam. Spamming will have your thread deleted and may also result in your account being banned.
    • Be polite.  You will get better assistance if you're polite to other members so no flaming or trolling.  If you persist with flaming or trolling, your accountmay get banned.
    • Mark your question answered. If someone answers your question please mark their reply as the answer to your question. You can also mark multiple replies as answers if you think they answered your question.  Marking replies not only assists others with similar questions, it also let's people know that you're grateful for their assistance.

    Dead thread/Answer policy.

    Where possible the moderators will allow sufficient time for the original poster to come back and mark the replies to their questions as answers. The amount of time is at the discretion of the individual moderator but is suggested that it will be declared dead after a week if the original poster does not respond . We will always try to be fair and mark suitable replies as answers.

    Setting up your alerts

    If you are having trouble receiving alerts on the threads you have created or replied to please see thisthread for troubleshooting advice.

  • Link
    Samples bugs and suggestions.
    David Reed (Glacier Peak) Monday, February 02, 2009 4:26 PM
    All of the work items for our community projects and product samples are in TFS on CodePlex. If you want to report a bug, suggest a change for an existing sample or suggest a new sample, create a work item in the appropriate project so that our community team (not just Microsoft employees) can vote on them, help us triage and prioritize them.

    For example, here's the URL for the work items for AdventureWorks: http://www.codeplex.com/MSFTDBProdSamples/WorkItem/AdvancedList.aspx
  • Link
    Welcome aboard! Community & Samples Forum Intro
    David Reed (Glacier Peak) Thursday, January 29, 2009 9:58 PM

    This forum is the place to discuss all things "samplish" in the SQL Server community and samples space, whether it's an "official Microsoft sample" or a community project in CodePlex or Code Gallery. This is *not* the place to discussion specific nuances of T-SQL syntax or wage data modeling methodology wars: there are lots of other forums for those purposes. This one is for questions about samples, community projects and conversations between the collaborators that build them.

     

    Some examples of projects that are open for discussion can be found here: http://www.codeplex.com/SqlServerSamples/ It doesn't have to be listed there to be fair game, but it's a good bet that it is fair game if it's already listed there.

     

    Also, please post your project announcements here when you create a new release or a whole new project. If you're looking for people to work on your project or looking for a project to work on, this would be a good place to do both.

     

    Let us know what's missing, let know what could be better and let us know what we're doing right!


Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.

Would you like to participate?

  
Privacy statement
 
© 2017 Microsoft. All rights reserved.
Terms of Use|Trademarks|Privacy Statement|Site Feedback