Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

sql server can anyone help me?

 
william chaple
Ranch Hand
Posts: 135
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi I already have the code, but problem is displaying it. Wondering if someone can help me with sql server
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 65340
97
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That's all pretty vague. WHat specifically do you ned help with?
 
william chaple
Ranch Hand
Posts: 135
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Bear Bibeault wrote:That's all pretty vague. WHat specifically do you ned help with?


Wow, you answer everything from me lol. Sorry, didnt mean to be so vague

Ok well, Ive been messing around with MS SQL SERVER 2012 EXPRESS and I created Tables these are the codes below





ok so I execute the code and it executes fine. I have a dbo.Store table.

Now I make my second query in the database and I use this code






but now it it keeps saying invalid object name. I am not sure what. However, when I put the entire scripts together like this









when I put all the codes together, it adds the values. Am I doing something wrong? Like I cant just query one at a time. Like create the table, save the script, then do a new query and add the values rather then adding it all together at the same time? Because lets say I wanted to add a new value down the road?


I added some images to make it understable

sqlTABLE.JPG
[Thumbnail for sqlTABLE.JPG]
SQLvalue.JPG
[Thumbnail for SQLvalue.JPG]
 
william chaple
Ranch Hand
Posts: 135
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
bump anyone? Im still having this trouble
 
Rob Spoor
Sheriff
Pie
Posts: 20753
68
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try selecting the database first: USE Practice1. SQL Server Management Studio doesn't always execute the query on the database you think it should work on. The USE query will force a change to the given database.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic