Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,199,841 members, 7,972,971 topics. Date: Saturday, 12 October 2024 at 01:20 AM |
Nairaland Forum / Science/Technology / Programming / Sql Server (1590 Views)
Building An Hierarchical Comment System In Asp.net Mvc, Ms Sql Server, Css / Fell Ms Sql Server Database. / Can't Open Database In MS SQL SERVER (2) (3) (4)
Sql Server by Laurence1: 1:21pm On Oct 23, 2017 |
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... |
Re: Sql Server by Nobody: 1:23pm On Oct 23, 2017 |
The command is: show tables; Not show table. |
Re: Sql Server by Nobody: 1:47pm On Oct 23, 2017 |
Connect to the database engine if u already installed it |
Re: Sql Server by Laurence1: 2:09pm On Oct 23, 2017 |
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...
|
Re: Sql Server by Nobody: 2:35pm On Oct 23, 2017 |
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 |
Re: Sql Server by Laurence1: 3:03pm On Oct 23, 2017 |
proxy20: 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 |
Re: Sql Server by Nobody: 3:11pm On Oct 23, 2017 |
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 |
Re: Sql Server by Silvawazza(m): 3:32pm On Oct 23, 2017 |
Please, I will love to learn more on this topic. Am new on this and I will to see more explanations and co |
Re: Sql Server by Laurence1: 3:37pm On Oct 23, 2017 |
proxy20: 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 |
Re: Sql Server by Laurence1: 4:02pm On Oct 23, 2017 |
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 |
Re: Sql Server by Nobody: 6:55pm On Oct 23, 2017 |
The interpreter can't handle complex query |
Re: Sql Server by Laurence1: 7:44am On Oct 24, 2017 |
tried on my sql 2014... same error
|
Re: Sql Server by olulove(m): 8:38am On Oct 24, 2017 |
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)
|
Re: Sql Server by Nobody: 9:35am On Oct 24, 2017 |
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 |
Re: Sql Server by Laurence1: 12:56pm On Oct 24, 2017 |
proxy20: thanks. the command used to show the tables is select *from table_name and not show tables |
Re: Sql Server by Nobody: 3:04pm On Oct 24, 2017 |
Laurence1: Yes, software developers often use select, delete and insert query . Complex query will be suitable for ERP |
Re: Sql Server by Laurence1: 11:08am On Nov 06, 2017 |
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 |
Re: Sql Server by Nobody: 3:40pm On Nov 06, 2017 |
Laurence1: 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 |
(1) (Reply)
How Many Lines Of Code Run Nairaland? / Data Processing & Data Analysis Courses / Java Code Pls Modify This Code Help
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 22 |