Click here to Skip to main content
11,435,451 members (65,712 online)
   

Database

 
AnswerRe: Is there a try/finally construct in sqlcmd with -b option, guaranteed to execute the finally block? Pin
Eddy Vluggen27-Sep-12 2:42
memberEddy Vluggen27-Sep-12 2:42 
GeneralRe: Is there a try/finally construct in sqlcmd with -b option, guaranteed to execute the finally block? Pin
J4amieC27-Sep-12 3:51
memberJ4amieC27-Sep-12 3:51 
QuestionRe: Is there a try/finally construct in sqlcmd with -b option, guaranteed to execute the finally block? Pin
Eddy Vluggen27-Sep-12 5:27
memberEddy Vluggen27-Sep-12 5:27 
AnswerRe: Is there a try/finally construct in sqlcmd with -b option, guaranteed to execute the finally block? Pin
J4amieC27-Sep-12 22:29
memberJ4amieC27-Sep-12 22:29 
Questionsql script [modified] Pin
sindhuan26-Sep-12 21:08
membersindhuan26-Sep-12 21:08 
AnswerRe: sql script Pin
ihoecken26-Sep-12 22:10
memberihoecken26-Sep-12 22:10 
GeneralRe: sql script Pin
sindhuan26-Sep-12 22:21
membersindhuan26-Sep-12 22:21 
AnswerRe: sql script Pin
ihoecken26-Sep-12 22:44
memberihoecken26-Sep-12 22:44 
AnswerRe: sql script Pin
J4amieC26-Sep-12 22:46
memberJ4amieC26-Sep-12 22:46 
GeneralRe: sql script Pin
sindhuan27-Sep-12 0:30
membersindhuan27-Sep-12 0:30 
AnswerRe: sql script Pin
ihoecken27-Sep-12 1:07
memberihoecken27-Sep-12 1:07 
GeneralRe: sql script Pin
Eddy Vluggen27-Sep-12 1:22
memberEddy Vluggen27-Sep-12 1:22 
GeneralRe: sql script Pin
J4amieC27-Sep-12 2:06
memberJ4amieC27-Sep-12 2:06 
QuestionLine line is a select statement. Pin
vanikanc26-Sep-12 9:22
membervanikanc26-Sep-12 9: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 9:37
memberjschell26-Sep-12 9:37 
GeneralRe: Line line is a select statement. Pin
vanikanc26-Sep-12 9:39
membervanikanc26-Sep-12 9:39 
GeneralRe: Line line is a select statement. Pin
jschell27-Sep-12 10:57
memberjschell27-Sep-12 10:57 
AnswerRe: Line line is a select statement. Pin
Niju126-Sep-12 23:28
memberNiju126-Sep-12 23:28 
AnswerRe: Line line is a select statement. Pin
ihoecken27-Sep-12 0:04
memberihoecken27-Sep-12 0:04 
QuestionAttendance and leave of employees Pin
Amr Muhammed25-Sep-12 14:06
memberAmr Muhammed25-Sep-12 14:06 
AnswerRe: Attendance and leave of employees [modified] Pin
ihoecken25-Sep-12 21:50
memberihoecken25-Sep-12 21:50 
GeneralRe: Attendance and leave of employees [modified] Pin
Andrei Straut25-Sep-12 22:03
memberAndrei Straut25-Sep-12 22:03 
GeneralRe: Attendance and leave of employees Pin
ihoecken25-Sep-12 22:19
memberihoecken25-Sep-12 22:19 
GeneralRe: Attendance and leave of employees Pin
Andrei Straut25-Sep-12 22:20
memberAndrei Straut25-Sep-12 22:20 
QuestionConvert datetime to certain format Pin
vanikanc25-Sep-12 10:09
membervanikanc25-Sep-12 10:09 
AnswerRe: Convert datetime to certain format Pin
ihoecken25-Sep-12 21:58
memberihoecken25-Sep-12 21:58 
QuestionSql server topics and materials Pin
Azizullahazizi24-Sep-12 19:32
memberAzizullahazizi24-Sep-12 19:32 
AnswerRe: Sql server topics and materials Pin
Andrei Straut24-Sep-12 21:12
memberAndrei Straut24-Sep-12 21:12 
AnswerRe: Sql server topics and materials Pin
Sandeep Mewara24-Sep-12 21:23
mvpSandeep Mewara24-Sep-12 21:23 
QuestionSQL Search within a table Pin
veon cheng24-Sep-12 10:31
memberveon cheng24-Sep-12 10:31 
AnswerRe: SQL Search within a table Pin
djj5525-Sep-12 2:08
memberdjj5525-Sep-12 2:08 
GeneralRe: SQL Search within a table Pin
veon cheng25-Sep-12 4:37
memberveon cheng25-Sep-12 4:37 
AnswerRe: SQL Search within a table Pin
ihoecken25-Sep-12 5:13
memberihoecken25-Sep-12 5:13 
QuestionCONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
r_mohd22-Sep-12 23:38
memberr_mohd22-Sep-12 23:38 
AnswerRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
Eddy Vluggen23-Sep-12 3:38
memberEddy Vluggen23-Sep-12 3:38 
AnswerRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
jschell23-Sep-12 9:10
memberjschell23-Sep-12 9:10 
GeneralRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
r_mohd24-Sep-12 3:28
memberr_mohd24-Sep-12 3:28 
GeneralRe: CONNECTING MSSQL DB FILE FROM PEN DRIVE Pin
jschell24-Sep-12 13:37
memberjschell24-Sep-12 13:37 
QuestionDb over internet Pin
leone22-Sep-12 9:56
memberleone22-Sep-12 9:56 
AnswerRe: Db over internet Pin
Eddy Vluggen23-Sep-12 1:42
memberEddy Vluggen23-Sep-12 1:42 
AnswerRe: Db over internet Pin
jschell23-Sep-12 9:16
memberjschell23-Sep-12 9:16 
GeneralRe: Db over internet Pin
leone24-Sep-12 1:45
memberleone24-Sep-12 1:45 
GeneralRe: Db over internet Pin
Jörgen Andersson24-Sep-12 3:05
memberJörgen Andersson24-Sep-12 3:05 
AnswerRe: Db over internet Pin
Chris Quinn27-Sep-12 3:36
memberChris Quinn27-Sep-12 3:36 
Questionconnection of mssql 2008 to cloud in windows form application Pin
KUNWAR99921-Sep-12 4:28
memberKUNWAR99921-Sep-12 4:28 
AnswerRe: connection of mssql 2008 to cloud in windows form application Pin
David Mujica21-Sep-12 4:50
memberDavid Mujica21-Sep-12 4:50 
AnswerRe: connection of mssql 2008 to cloud in windows form application Pin
Eddy Vluggen21-Sep-12 5:44
memberEddy Vluggen21-Sep-12 5:44 
QuestionSQL XP_StartSMTP to send email Pin
MWRivera20-Sep-12 6:45
memberMWRivera20-Sep-12 6:45 
AnswerRe: SQL XP_StartSMTP to send email Pin
Chris Meech21-Sep-12 3:45
memberChris Meech21-Sep-12 3:45 
AnswerRe: SQL XP_StartSMTP to send email Pin
Eddy Vluggen21-Sep-12 5:47
memberEddy Vluggen21-Sep-12 5:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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
Web04 | 2.8.150428.2 | Last Updated 5 May 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid