Microsoft SQL Server Management Studio Express is the freely downloadable version of Microsoft SQL Server Management Studio, a graphical tool for configuring, managing, and administering all components within Microsoft SQL Server.
Questions tagged [management-studio-express]
81 questions
0
votes
1 answer
Syntax error when trying to change schema in SQL Server database
I am trying to rename the schema for a dozen tables in an old database on SQL Server 2005. I'm using SQL Server Management Studio Express version 9.0. Based on detailed advice found here, as well as several forums on other sites, I've been trying…
John Meyer
- 1
- 2
-1
votes
1 answer
how to transfer from MySql to Management Studio
I have database which works on MySql. And i need to copy it to another computer where there is only management studio. i create .sql file from MySql and tried to run it in studio but always have syntax errors.
How to do it correctly?
CREATE TABLE…
flex_grigorowicz
- 63
- 1
- 8
-1
votes
1 answer
SQL Management Studio messes up query syntax
I am trying to remove a space and a no-break space from a varchar field i'm going to cast as an int, however, when using the replace method SQL Management Studio messes up the syntax after accepting it so I can't save it. This my query:
SELECT…
Tinne
- 1
- 1
-1
votes
1 answer
Identity increment not consistent ms sql sever
As an overview.
I created a table and set under Identity Specification on the primary key column, the Identity Increment to 1 and the Identity Seed to 1 as well(in the Design of the table).
I noticed however the the increment(when inserting…
Arianule
- 8,811
- 45
- 116
- 174
-2
votes
4 answers
There is already an object named 'vedere1' in the database
this is my code:
--Vedere care conține clienții ce au inchiriat camere:
USE Sunset
GO
CREATE VIEW vedere1 AS
SELECT DISTINCT c.Nume AS num_client, r.Nr_camera AS camera, f.Data_emiterii, f.Suma
FROM factura f, clienti c, camera r
WHERE…
Madalina Tamasan
- 3
- 2
-3
votes
1 answer
How do I write this JOIN query? There is no common table data
I need to display the first and last names of people who have sold items at a price of over $20, I need to join the title and author table but they do not have any common keys? How do I go about doing this? I only need to display their names as…
dboor129
- 1
- 1