SQL Server Express and Management Tool (Full Version)

All Forums >> [Web Development] >> General Web Development



Message

mar0364 -> SQL Server Express and Management Tool (6/1/2006 21:42:24)

http://msdn.microsoft.com/vstudio/express/sql/
Has anyone downloaded this and is using it succesfully with FP or DW etc.

I'm tempted to try it but not sure.



mar0364 -> RE: SQL Server Express and Management Tool (6/7/2006 7:55:50)

This works very nicely with FP, DW and of course Expression. Getting Enterprise Manager for free makes life allot easier. This is a much more intuitive version of Enterprise Manager then 2000.




rdouglass -> RE: SQL Server Express and Management Tool (6/7/2006 13:35:25)

I've been checking it out but some things it's not very intuitive to do: try importing a spreadsheet. It's pretty painful (for me anyways) to do that 1 task. Got any hints?

It looks like I need to create a table and then copy and paste to it but that just seems wrong to me - there must be a 'better' way.



mar0364 -> RE: SQL Server Express and Management Tool (6/7/2006 13:54:09)

What I did was use the Upsize wizard in Access and that worked fine. I'm dealing with some rights issues now.

I know it seems like going around your A**hole to get to your thumb but you could save it as an mdb and upsize it.

Thanks!
Rich



rdouglass -> RE: SQL Server Express and Management Tool (6/7/2006 14:15:11)

quote:

could save it as an mdb and upsize it


I guess that's the way then. It just *bugs* me when they take a function away and call it progress. Especially functions that I use all the time. [:@]

With Enterprise Manager, I could import directly from a CSV/XLS file. I guess that's progress for you. [:'(]



mar0364 -> RE: SQL Server Express and Management Tool (6/7/2006 14:25:28)

I'm convenced there is a department at MS setup just to do agrivating little things like this. I hate them/no I love them. Well that's how it goes. LOL



rdouglass -> RE: SQL Server Express and Management Tool (6/9/2006 14:22:45)

It is too bad. It looked so promising.

I had to drop back to ENterprise Mangler last night to do some stuff that I just could not figure out in Express; simple UPDATE queries no less just had me baffled. [:'(] Everything I tried just did not work - I even had full SA privs and couldn't do squat.

15 minutes later in EM and my work was done. [>:]



mar0364 -> RE: SQL Server Express and Management Tool (6/9/2006 14:49:23)

If you right click a table one of the options is a generic update, delete or insert statement for that particular table.

What does not kill you will make you better.



rdouglass -> RE: SQL Server Express and Management Tool (6/9/2006 17:02:11)

quote:

What does not kill you will make you better.


However those UPDATE etc. statement areas just would *not* work for me no matter what I tried. I di dsee them and intuitively I know what they do.

I spent 2 hours trying to get the stupid thing to update 1 field based on a value in a related table. Never could get it to do it.[X(]

Like I said, 15 minutes in EM.[:-] I know I'm just *under-trained* on this thing.



mar0364 -> RE: SQL Server Express and Management Tool (6/9/2006 17:09:30)

Yea its tough learning these things. The kicker is once we learn they will change it. [:@]



yb2 -> RE: SQL Server Express and Management Tool (6/10/2006 3:41:45)

I've spent a year learning .Net v1.1 and now everything is 2.0 and by the time I've worked out the changes to that I'm sure they'll be on version 3![&o] (you can actually start using 3, there are pages somewhere that show all the work going into it)

I like the new Management Studio though, I think it's a really nice mix of Query Analyser and Enterprise Manager. I especially like the Solutions and Projects for keeping queries organised. That is a real god send (for me).

So you don't end up looking like your avatar RD (unless that's really is a photo of you) [:D]

UPDATE myTable
set FirstField = m.FirstField + r.SecondField
FROM myTable m
INNER JOIN RelatedTable r
ON m.Whatever = r.Whatever
WHERE m.Id = 50



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
7.800293E-02