256 Kilobytes

All Content > SQL

Type All Category All Tag SQL

Profile Photo - GulfWar

What are some good SQL interview questions?

Answers in Local and Offline Businesses | By GulfWar

Published

Profile Photo - bracknelson

Last ReplyHello, There are some basic SQL interview question : 1. What are all the different normalizations? 2. What is the difference between SQL and MySQL?... bracknelson,

Hello,

Mon, 24 Aug 2020 22:10:09 -070010 months ago1
🗨 6
🐏 0
👁 918
Profile Photo - Some Guy

Does GROUP BY remove duplicates?

Answers in Database Development | By Some Guy

Published

Profile Photo - Default

Last ReplyGROUP BY allows the only aggregation. If you want to remove all duplicated rows, use SELECT DISTINCT. But DISTINCT command also so slow for lar... Ali,

GROUP BY allows the only...

Tue, 28 May 2019 23:39:57 -07002 years ago1
🗨 2
🐏 0
👁 580
Profile Photo - T. Martin

How can I check SQL Server version?

Answers in Computer Software | By T. Martin

Published

Profile Photo - Zhaybib

Last ReplyIn order to check SQL Server version, I recommend that you take a look at Microsoft's support page which offers a guide on finding the version here, h... Zhaybib,

In order to check SQL Ser...

Sat, 30 Mar 2019 16:02:40 -07002 years ago1
🗨 1
🐏 0
👁 369
Profile Photo - Boats, LLC

How to uninstall SQL Server?

Answers in Computer Software | By Boats, LLC

Published

Profile Photo - Zhaybib

Last ReplySince you state that you would like to uninstall SQL server, you should check out Microsoft's guide that is right here, https://docs.microsoft.com/en-... Zhaybib,

Since you state that you...

Sat, 30 Mar 2019 15:47:50 -07002 years ago1
🗨 1
🐏 0
👁 308
Profile Photo - Your Dad

How can you create stored procedure in swl server?

Answers in Servers and Networks | By Your Dad

Published

Profile Photo - Graln_of_Truth

Last ReplyThere's plenty of articles online on how to obtain this, however I feel as if a video demonstration would work better. Watch the video I provided. Als... Graln_of_Truth,

There's plenty of article...

Sat, 30 Mar 2019 15:08:53 -07002 years ago1
🗨 1
🐏 0
👁 431
Profile Photo - IncstedibleMrE1

How can I uninstall SQL Server 2012?

Answers in Computer Software | By IncstedibleMrE1

Published

Profile Photo - Zhaybib

Last ReplySince you say you want to uninstall SQL server 2012, I suggest you take a look at Stack Overflow's site right here, http://stackoverflow.com/questions... Zhaybib,

Since you say you want to...

Sat, 30 Mar 2019 14:55:28 -07002 years ago1
🗨 1
🐏 0
👁 252
Profile Photo - IncstedibleMrE1

How to setup SQL Server?

Answers in Computer Software | By IncstedibleMrE1

Published

Profile Photo - Zhaybib

Last ReplySince you say that you are having some difficulty setting up a SQL server, I suggest that you take a look right here at this tutorial, http://www.wiki... Zhaybib,

Since you say that you ar...

Sat, 30 Mar 2019 14:52:45 -07002 years ago1
🗨 1
🐏 0
👁 334
Profile Photo - pls_stop_this

What is SQL Server management studio?

Answers in Servers and Networks | By pls_stop_this

Published

Profile Photo - DavefaceFWS

Last ReplyMicrosoct SQL Server is a SQL hosting server that lets a client configure, manage, and administer privileges throughout their respective server with e... DavefaceFWS,

Microsoct SQL Server is a...

Sat, 30 Mar 2019 14:42:21 -07002 years ago1
🗨 1
🐏 0
👁 410
Profile Photo - Japanese

How do I install SQL Server?

Answers in Servers and Networks | By Japanese

Published

Profile Photo - Zhaybib

Last ReplySince you say that you want to install SQL server, you should check out this guide from Microsoft Docs here, https://docs.microsoft.com/en-us/sql/data... Zhaybib,

Since you say that you wa...

Sat, 30 Mar 2019 14:41:16 -07002 years ago1
🗨 1
🐏 0
👁 389
Profile Photo - T. Martin

What are some SQL Server interview questions?

Answers in Local and Offline Businesses | By T. Martin

Published

Profile Photo - w3nsi012

Last ReplyI found this website below that lists 50 verified interview questions. Just click the link and they are all listed out for you. Also See: https://www.... w3nsi012,

I found this website belo...

Sat, 30 Mar 2019 14:39:26 -07002 years ago1
🗨 1
🐏 0
👁 337
Profile Photo - tich363

How do I uninstall SQL Server 2014?

Answers in Servers and Networks | By tich363

Published

Profile Photo - Graln_of_Truth

Last ReplySQL as well as many other programs can be uninstalled by going to Control Panel > Uninstall programs and scrolling to the program. Also See: https://h... Graln_of_Truth,

SQL as well as many other...

Sat, 30 Mar 2019 14:23:33 -07002 years ago1
🗨 1
🐏 0
👁 417
Profile Photo - timeIord1776

How to install SQL Server 2017?

Answers in Computer Software | By timeIord1776

Published

Profile Photo - 888_eight_888

Last ReplyFor Windows 10, go to the start section and type in SSMS. That will take you to a website where you can download SQL Server 2017. After downloading, y... 888_eight_888,

For Windows 10, go to the...

Sat, 30 Mar 2019 14:16:24 -07002 years ago1
🗨 1
🐏 0
👁 306
Profile Photo - licoroso8i

What is Firebird SQL Server?

Answers in Servers and Networks | By licoroso8i

Published

Profile Photo - reuval

Last ReplyIt depends on what you're using it for. According to the manual there are some bugs and quirks that have been removed. If your system is already worki... reuval,

It depends on what you're...

Sat, 30 Mar 2019 14:06:01 -07002 years ago1
🗨 1
🐏 0
👁 354
Profile Photo - The Big Bad Wolf

How can I execute stored procedure in SQL Server?

Answers in Computer Software | By The Big Bad Wolf

Published

Profile Photo - Zhaybib

Last ReplySince you are using SQL server and would like to execute stored procedure, you check this out right here http://stackoverflow.com/questions/4136817/dd... Zhaybib,

Since you are using SQL s...

Sat, 30 Mar 2019 14:05:13 -07002 years ago1
🗨 1
🐏 0
👁 262
Profile Photo - pls_stop_this

How can you connect to SQL Server database?

Answers in Servers and Networks | By pls_stop_this

Published

Profile Photo - Zhaybib

Last ReplySince you say that you want to connect to SQL server database, you should check out Microsoft support page right here, https://docs.microsoft.com/en-u... Zhaybib,

Since you say that you wa...

Sat, 30 Mar 2019 14:04:41 -07002 years ago1
🗨 1
🐏 0
👁 305
Profile Photo - pls_stop_this

How to create schema in SQL Server?

Answers in Servers and Networks | By pls_stop_this

Published

Profile Photo - Zhaybib

Last ReplySince you are into server hosting and would like to create scheme in SQL, check out this link right here http://stackoverflow.com/questions/5303134/dd... Zhaybib,

Since you are into server...

Sat, 30 Mar 2019 13:53:19 -07002 years ago1
🗨 1
🐏 0
👁 323
Profile Photo - PPSH1111

How do you install SQL Server 2016?

Answers in Computer Software | By PPSH1111

Published

Profile Photo - Jemgrip

Last ReplyI found a YouTube video that should be able to assist you... https://www.youtube.com/watch?v=Gfmk1ZbunUI Hope this helps. Jemgrip,

I found a YouTube video t...

Wed, 20 Mar 2019 22:39:43 -07002 years ago1
🗨 1
🐏 0
👁 315
Profile Photo - NelsAmmo

How can I download SQL Server?

Answers in Computer Software | By NelsAmmo

Published

Profile Photo - rfc1385

Last Replyhttps://www.microsoft.com/en-us/sql-server/sql-server-downloads here is a link with some good information about how to download SQL servers from micro... rfc1385,

https://www.microsoft.com...

Wed, 20 Mar 2019 22:16:08 -07002 years ago1
🗨 1
🐏 0
👁 346
Profile Photo - K. Crezcheezy

SQL vs. NoSQL: Pros and Cons?

Forum in Computer Programming | By K. Crezcheezy

Published

Profile Photo - Jemgrip

Last ReplyIf you want a thorough explanation, I'd try this site... https://www.thegeekstuff.com/2014/01/sql-vs-nosql-db Hope this helps. Jemgrip,

If you want a thorough ex...

Wed, 20 Mar 2019 17:26:33 -07002 years ago1
🗨 1
🐏 0
👁 337
Profile Photo - thegstocersson

How can I uninstall SQL Server 2016?

Answers in Servers and Networks | By thegstocersson

Published

Profile Photo - Edgelady43069

Last ReplyJust follow the following steps to uninstall SQL Server 2016. 1. Go to Control Panel and then Programs and Features. 2. Select Microsoft SQL Server 20... Edgelady43069,

Just follow the following...

Wed, 20 Mar 2019 05:08:10 -07002 years ago1
🗨 2
🐏 0
👁 370
Profile Photo - Some Guy

Solve "sqlstate[hy000] [2002] connection refused"?

Answers in Databases | By Some Guy

Published

Profile Photo - Hash Brown

Last ReplyThese errors are kind of generic and don't point to anything specific. In general you want to start off: Make sure you're using the c... Hash Brown,

These errors are kind of...

Sun, 20 Jan 2019 18:05:00 -08002 years ago1
🗨 1
🐏 0
👁 539
Profile Photo - Some Guy

[SQL/MySQL/MariaDB] Can you query from a query result?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

MoreOK, so I've been trying to learn SQL for my new job, and I was wondering if it's possible to run a query from a previous query result? My co...
🗨 0
🐏 0
👁 398
Profile Photo - Some Guy
Profile Photo - Some Guy

MoreI'm new to Databases having been on the web development side. Have a question for you experts: On a SQL Server, what is the difference between a...
🗨 0
🐏 0
👁 416
Profile Photo - Some Guy
Profile Photo - Some Guy

MoreI'm getting an "ERROR 1170 (42000): BLOB/TEXT column 'some_column' used in key specification without a key length" error in M...
🗨 0
🐏 0
👁 533
Profile Photo - Some Guy
Profile Photo - Some Guy

MoreI’m working on a new query for pulling specific data and receive the error “Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: Ba...
🗨 0
🐏 0
👁 1,515
Profile Photo - Some Guy

How to have a LEFT JOIN only get row?

Answers in Database Development | By Some Guy

Published

Profile Photo - Some Guy

MoreI am process of developing database and I am on part where to address the issue of Left Join row. How to address this issue in the part of database de...
🗨 0
🐏 0
👁 456
Profile Photo - Some Guy

Solution to "string or binary data would be truncated"?

Answers in Databases | By Some Guy

Published

Profile Photo - Hash Brown

Last ReplyHello, Trunication is basically where you're going to lose some of your data by inserting it. This is cause by trying to pass in data which is... Hash Brown,

Hello,

Wed, 19 Dec 2018 08:40:51 -08002 years ago1
🗨 1
🐏 0
👁 363
Profile Photo - Some Guy

ORA-00979: not a group by expression - solutions?

Answers in Databases | By Some Guy

Published

Profile Photo - Hash Brown

Last ReplyHello, ORA-009779 is a fairly straight forward error. You have not included any code so I'll have to explain what it's likely to be... I... Hash Brown,

Hello,

Wed, 19 Dec 2018 08:36:33 -08002 years ago1
🗨 1
🐏 0
👁 392
Profile Photo - Some Guy

Differences between primary keys and unique keys?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

For my new job, I need to use SQL but I&...

MoreFor my new job, I need to use SQL but I'm not that familiar with it. Could someone please explain the differences between primary keys and unique...
🗨 0
🐏 0
👁 303
Profile Photo - Some Guy

What is "mysqli_real_escape_string" in PHP?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

I'm writing a program for a class p...

MoreI'm writing a program for a class project. I'm writing PHP for the program and I can figure out a code. I don't know what "mysqli_...
🗨 0
🐏 0
👁 363