Click here to Skip to main content
12,403,978 members (76,256 online)
   

Database

 
GeneralRe: sql script Pin
sindhuan26-Sep-12 21:21
membersindhuan26-Sep-12 21:21 
AnswerRe: sql script Pin
ihoecken26-Sep-12 21:44
memberihoecken26-Sep-12 21:44 
AnswerRe: sql script Pin
J4amieC26-Sep-12 21:46
memberJ4amieC26-Sep-12 21:46 
GeneralRe: sql script Pin
sindhuan26-Sep-12 23:30
membersindhuan26-Sep-12 23:30 
AnswerRe: sql script Pin
ihoecken27-Sep-12 0:07
memberihoecken27-Sep-12 0:07 
GeneralRe: sql script Pin
Eddy Vluggen27-Sep-12 0:22
memberEddy Vluggen27-Sep-12 0:22 
GeneralRe: sql script Pin
J4amieC27-Sep-12 1:06
memberJ4amieC27-Sep-12 1:06 
QuestionLine line is a select statement. Pin
vanikanc26-Sep-12 8:22
membervanikanc26-Sep-12 8:22 
hi,

I have the following sql.
select
'00' + 'TESTIN' + '634' + SPACE(56) + '000001' + CHAR(13) + char(10) +
'1'

I need the 1 on the next line, as I have specified CHAR(13) + char(10). But it does show that way, it still appears on the same line.

Any help is appreciated.
AnswerRe: Line line is a select statement. Pin
jschell26-Sep-12 8:37
memberjschell26-Sep-12 8:37 
GeneralRe: Line line is a select statement. Pin
vanikanc26-Sep-12 8:39
membervanikanc26-Sep-12 8:39 
GeneralRe: Line line is a select statement. Pin
jschell27-Sep-12 9:57
memberjschell27-Sep-12 9:57 
AnswerRe: Line line is a select statement. Pin
Niju126-Sep-12 22:28
memberNiju126-Sep-12 22:28 
AnswerRe: Line line is a select statement. Pin
ihoecken26-Sep-12 23:04
memberihoecken26-Sep-12 23:04 
QuestionAttendance and leave of employees Pin
Amr Muhammed25-Sep-12 13:06
memberAmr Muhammed25-Sep-12 13:06 
AnswerRe: Attendance and leave of employees Pin
ihoecken25-Sep-12 20:50
memberihoecken25-Sep-12 20:50 
GeneralRe: Attendance and leave of employees Pin
Andrei Straut25-Sep-12 21:03
memberAndrei Straut25-Sep-12 21:03 
GeneralRe: Attendance and leave of employees Pin
ihoecken25-Sep-12 21:19
memberihoecken25-Sep-12 21:19 
GeneralRe: Attendance and leave of employees Pin
Andrei Straut25-Sep-12 21:20
memberAndrei Straut25-Sep-12 21:20 
QuestionConvert datetime to certain format Pin
vanikanc25-Sep-12 9:09
membervanikanc25-Sep-12 9:09 
AnswerRe: Convert datetime to certain format Pin
ihoecken25-Sep-12 20:58
memberihoecken25-Sep-12 20:58 
QuestionSql server topics and materials Pin
Azizullahazizi24-Sep-12 18:32
memberAzizullahazizi24-Sep-12 18:32 
AnswerRe: Sql server topics and materials Pin
Andrei Straut24-Sep-12 20:12
memberAndrei Straut24-Sep-12 20:12 
AnswerRe: Sql server topics and materials Pin
Sandeep Mewara24-Sep-12 20:23
mvpSandeep Mewara24-Sep-12 20:23 
QuestionSQL Search within a table Pin
veon cheng24-Sep-12 9:31
memberveon cheng24-Sep-12 9:31 
AnswerRe: SQL Search within a table Pin
djj5525-Sep-12 1:08
memberdjj5525-Sep-12 1:08 

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.


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 28 Jul 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid