Hi i'm just starting with sql database.... im having troubles showing my tables.

i've tried show table; and its shows Error occurred. Recheck your SQL statement

please advice...

The command is:
show tables;

Not show table.

Connect to the database engine if u already installed it

thanks... proxy20 dhtml118
ive tried that also

or is it because im trying it from this site
http://www.sqlcourse.com

i recently formatted my system, the server on my vm is 32bit and the sql i have is 64bit, so i'm trying to learn all i can first before downloading a new sql server...

I thought it was an actual sql server express 2016 + db engine.



The site is just a learning platform . Just learn
Drop table
Select
Delete
Insert query




Use drop table in the interpreter

proxy20:
I thought it was an actual sql server express 2016 + db engine.



The site is just a learning platform . Just learn
Drop table
Select
Delete
Insert query


Use drop table in the interpreter

yeah... i'm just starting

drop table didn't work also, sadly...

downloading a new windows server is strenuous walai

sigh.

thanks, i appreciate your help

Use ur existing sql server .The process of new installation is very long.


https://www.w3schools.com/sql/default.asp


The site above have more explanations

Please, I will love to learn more on this topic. Am new on this and I will to see more explanations and co

proxy20:
Use ur existing sql server .The process of new installation is very long.


https://www.w3schools.com/sql/default.asp


The site above have more explanations

my windows server is not compatible with the sql server

i cannot run it on the vm

i even googled if it was possible to upgrade from a 32bit to 64bit out of frustration...

thanks for the link

alter table
nst_1
add title varchar(25);


proxy20
trying to use the rule i got from the link.. its giving me an error message
please help me look at the query,
correct me if i'm wrong
i'm considering maybe there's a limit to what the interpreter can perform but i might just be projecting my frustrations on the innocent interpreter..lol

thanks

The interpreter can't handle complex query

tried on my sql 2014...

same error

Kindly assist
USE [master]
GO

/****** Object: Database [KNMIS] Script Date: 09/03/2016 06:00:23 ******/
CREATE DATABASE [KNMIS] ON PRIMARY
( NAME = N'KNMIS', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\KNMIS.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'KNMIS_log', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\KNMIS_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO

ALTER DATABASE [KNMIS] SET COMPATIBILITY_LEVEL = 100
GO

IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [KNMIS].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO

ALTER DATABASE [KNMIS] SET ANSI_NULL_DEFAULT OFF
GO

ALTER DATABASE [KNMIS] SET ANSI_NULLS OFF
GO

ALTER DATABASE [KNMIS] SET ANSI_PADDING OFF
GO

ALTER DATABASE [KNMIS] SET ANSI_WARNINGS OFF
GO

ALTER DATABASE [KNMIS] SET ARITHABORT OFF
GO

ALTER DATABASE [KNMIS] SET AUTO_CLOSE OFF
GO

ALTER DATABASE [KNMIS] SET AUTO_CREATE_STATISTICS ON
GO

ALTER DATABASE [KNMIS] SET AUTO_SHRINK OFF
GO

ALTER DATABASE [KNMIS] SET AUTO_UPDATE_STATISTICS ON
GO

ALTER DATABASE [KNMIS] SET CURSOR_CLOSE_ON_COMMIT OFF
GO

ALTER DATABASE [KNMIS] SET CURSOR_DEFAULT GLOBAL
GO

ALTER DATABASE [KNMIS] SET CONCAT_NULL_YIELDS_NULL OFF
GO

ALTER DATABASE [KNMIS] SET NUMERIC_ROUNDABORT OFF
GO

ALTER DATABASE [KNMIS] SET QUOTED_IDENTIFIER OFF
GO

ALTER DATABASE [KNMIS] SET RECURSIVE_TRIGGERS OFF
GO

ALTER DATABASE [KNMIS] SET DISABLE_BROKER
GO

ALTER DATABASE [KNMIS] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO

ALTER DATABASE [KNMIS] SET DATE_CORRELATION_OPTIMIZATION OFF
GO

ALTER DATABASE [KNMIS] SET TRUSTWORTHY OFF
GO

ALTER DATABASE [KNMIS] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO

ALTER DATABASE [KNMIS] SET PARAMETERIZATION SIMPLE
GO

ALTER DATABASE [KNMIS] SET READ_COMMITTED_SNAPSHOT OFF
GO

ALTER DATABASE [KNMIS] SET HONOR_BROKER_PRIORITY OFF
GO

ALTER DATABASE [KNMIS] SET READ_WRITE
GO

ALTER DATABASE [KNMIS] SET RECOVERY SIMPLE
GO

ALTER DATABASE [KNMIS] SET MULTI_USER
GO

ALTER DATABASE [KNMIS] SET PAGE_VERIFY CHECKSUM
GO

ALTER DATABASE [KNMIS] SET DB_CHAINING OFF
GO
(Modify) (Quote) (Report) (Share)
The sweetest of all sounds is that of the voice of the woman we love

(0) (Reply) (Un-Follow)

Did you

The red squiggly line shows incorrect objects

1.create the database

2. Create your table
3. Connect the db
4. Run the query



Remove show table
The title is not grownup

proxy20:
Did you

The red squiggly line shows incorrect objects

1.create the database

2. Create your table
3. Connect the db
4. Run the query



Remove show table
The title is not grownup

thanks.

the command used to show the tables is select *from table_name and not show tables

Laurence1:


thanks.

the command used to show the tables is select *from table_name and not show tables

Yes, software developers often use select, delete and insert query . Complex query will be suitable for ERP

cc: proxy20

bruv..

oya new challenge today for me is creating a new database from an existing one

use master create database new_db from database old_db

error comes from the *from

thanks

Laurence1:
cc: proxy20

bruv..

oya new challenge today for me is creating a new database from an existing one

use master create database new_db from database old_db

error comes from the *from

thanks

A database has tables.U can use insert or update to put some data values into the table .


Invalid query ...

Just create the database manually