Click here to Skip to main content
14,243,792 members
   

Database

 
AnswerRe: MySql vs MariaDB Pin
jschell18-May-19 7:18
memberjschell18-May-19 7:18 
GeneralRe: MySql vs MariaDB Pin
DerekT-P19-May-19 7:23
professionalDerekT-P19-May-19 7:23 
GeneralRe: MySql vs MariaDB Pin
jschell23-May-19 5:29
memberjschell23-May-19 5:29 
GeneralRe: MySql vs MariaDB Pin
DerekT-P23-May-19 8:22
professionalDerekT-P23-May-19 8:22 
GeneralRe: MySql vs MariaDB Pin
jschell2-Jun-19 8:36
memberjschell2-Jun-19 8:36 
QuestionWhat is an alias? Pin
Shraddha_Patel7-May-19 18:20
memberShraddha_Patel7-May-19 18:20 
AnswerRe: What is an alias? Pin
Richard MacCutchan7-May-19 21:23
protectorRichard MacCutchan7-May-19 21:23 
AnswerRe: What is an alias? Pin
#realJSOP28-May-19 1:52
mve#realJSOP28-May-19 1:52 
It lets you replace [MyDB].[dbo].[MyTable] with a shorter name, such as a:
SELECT a.*
FROM [MyDB].[dbo].[MyTable] AS a
You can also use the aliasiing feature on column names, like so:
SELECT [MyReallyLongColumnName] AS ShorterName
FROM [MyDB].[dbo].[MyTable]
A simple google search will give you all the nuances regarding the use of aliasing in SQL Server (for columns, sometimes you should, sometimes you must, and sometimes you don't have to use aliasing.

BTW, you generally alias table names when using join or merge.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

QuestionHow can you get the alternate records from the table in the SQL? Pin
Shraddha_Patel30-Apr-19 22:53
memberShraddha_Patel30-Apr-19 22:53 
AnswerRe: How can you get the alternate records from the table in the SQL? Pin
Richard MacCutchan30-Apr-19 23:07
protectorRichard MacCutchan30-Apr-19 23:07 
AnswerRe: How can you get the alternate records from the table in the SQL? Pin
CHill601-May-19 5:05
protectorCHill601-May-19 5:05 
AnswerRe: How can you get the alternate records from the table in the SQL? Pin
Santosh kumar Pithani4-May-19 2:31
professionalSantosh kumar Pithani4-May-19 2:31 
GeneralRe: How can you get the alternate records from the table in the SQL? Pin
CHill6014-May-19 2:30
protectorCHill6014-May-19 2:30 
SuggestionRe: How can you get the alternate records from the table in the SQL? Pin
Richard Deeming14-May-19 2:38
mveRichard Deeming14-May-19 2:38 
GeneralRe: How can you get the alternate records from the table in the SQL? Pin
CHill6015-May-19 2:36
protectorCHill6015-May-19 2:36 
JokeRe: How can you get the alternate records from the table in the SQL? Pin
Richard Deeming15-May-19 6:51
mveRichard Deeming15-May-19 6:51 
GeneralRe: How can you get the alternate records from the table in the SQL? Pin
Santosh kumar Pithani15-May-19 20:43
professionalSantosh kumar Pithani15-May-19 20:43 
QuestionA strange issue!The count of queries does not match data. Pin
Member 1409322316-Apr-19 23:17
memberMember 1409322316-Apr-19 23:17 
AnswerRe: A strange issue!The count of queries does not match data. Pin
Maciej Los16-Apr-19 23:34
protectorMaciej Los16-Apr-19 23:34 
SuggestionRe: A strange issue!The count of queries does not match data. Pin
Richard Deeming17-Apr-19 1:16
mveRichard Deeming17-Apr-19 1:16 
GeneralRe: A strange issue!The count of queries does not match data. Pin
Member 1409322317-Apr-19 15:27
memberMember 1409322317-Apr-19 15:27 
GeneralFavour sought from a MySql expert Pin
Ger Hayden16-Apr-19 21:50
memberGer Hayden16-Apr-19 21:50 
GeneralRe: Favour sought from a MySql expert PinPopular
Richard MacCutchan16-Apr-19 22:21
protectorRichard MacCutchan16-Apr-19 22:21 
GeneralRe: Favour sought from a MySql expert Pin
Ger Hayden16-Apr-19 22:34
memberGer Hayden16-Apr-19 22:34 
GeneralRe: Favour sought from a MySql expert Pin
Richard MacCutchan16-Apr-19 22:48
protectorRichard MacCutchan16-Apr-19 22:48 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.