Forum: MS SQL Feb 4th, 2009 |
| Replies: 6 Views: 2,884 so you can change the table name in vs? i didnt think you could thats why i recommended sql management studio |
Forum: MS SQL Feb 4th, 2009 |
| Replies: 6 Views: 2,884 Not sure if that is possible. Can you not install management studio express to make any changes to your DB? |
Forum: MS SQL Feb 4th, 2009 |
| Replies: 2 Views: 876 in management studio right click the table you want to edit. you will see modify. click it. this will bring up the column properties. from here you can change anything you would like. |
Forum: MS SQL Oct 17th, 2008 |
| Replies: 2 Views: 1,702 just to get an idea can you show your connection strings to both instances? |
Forum: MS SQL Jul 4th, 2008 |
| Replies: 1 Views: 1,918 Primary key is the unique identifier of a row of data. like:
table Dogs:
dogid=1(pk)unique
dogname=spot
dogbreadid=5(fk)
age=3
dogid is the dog spots unique identifier in the db. dogbreadid... |
Forum: MS SQL Jun 6th, 2008 |
| Replies: 9 Views: 2,316 looking in your db i noticed that you do not have any orders in February. This will be one reason why you cant pull anything from the first query. change the date to 6/2/2008 and BAM its full of data... |