截断，DROP，DELETE和SELECT不起作用？ [英] Truncate, DROP, DELETE and SELECT not working ?

问题描述

嗨.. TRUNCATE，DROP，DELETE和SELECT无法在db_compiler数据库的sql server management studio 2012中工作，请帮帮我。



我是什么尝试过：



这里是图片截图

无效的对象名称错误来了。名称是100％正确..

Hi.. TRUNCATE,DROP,DELETE and SELECT not working in sql server management studio 2012 in db_compiler database,please help me.

What I have tried:

Here is screen shotimage
"Invalid Object Name " error come.Name is 100% correct..

推荐答案

首先你必须选择数据库

First you have to select the database

use databaseName;  -- selects the db which u want to run the statement.
select * from tableName;

在你的情况下：

under your case:

use db_complier;   
  select * from Create_db;

这篇关于截断，DROP，DELETE和SELECT不起作用？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！