Click here to Skip to main content
12,450,977 members (54,066 online)
   

Database

 
GeneralRe: MySQL sql statement question Pin
jrahma27-Sep-12 11:08
memberjrahma27-Sep-12 11:08 
GeneralRe: MySQL sql statement question Pin
Eddy Vluggen29-Sep-12 2:42
memberEddy Vluggen29-Sep-12 2:42 
QuestionIs there a try/finally construct in sqlcmd with -b option, guaranteed to execute the finally block? Pin
muhalet27-Sep-12 0:56
membermuhalet27-Sep-12 0:56 
AnswerRe: Is there a try/finally construct in sqlcmd with -b option, guaranteed to execute the finally block? Pin
Eddy Vluggen27-Sep-12 1:42
memberEddy Vluggen27-Sep-12 1:42 
GeneralRe: Is there a try/finally construct in sqlcmd with -b option, guaranteed to execute the finally block? Pin
J4amieC27-Sep-12 2:51
memberJ4amieC27-Sep-12 2:51 
QuestionRe: Is there a try/finally construct in sqlcmd with -b option, guaranteed to execute the finally block? Pin
Eddy Vluggen27-Sep-12 4:27
memberEddy Vluggen27-Sep-12 4:27 
AnswerRe: Is there a try/finally construct in sqlcmd with -b option, guaranteed to execute the finally block? Pin
J4amieC27-Sep-12 21:29
memberJ4amieC27-Sep-12 21:29 
Questionsql script Pin
sindhuan26-Sep-12 20:08
membersindhuan26-Sep-12 20:08 
Hi All,
I have created two databases Test1 and Test2. For one database(Test1) I got the latest version of the code, created the deployement script and deployed the changes to the db.For the other database(Test2) I need to run the deployment script which got created form the Test1 DB.I tried to run the script but my db is not supporting..I get the following errors..


Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ':'.
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ':'.
Msg 50000, Level 16, State 127, Line 4
You cannot deploy this update script to target INP-xx. The database for which this script was built, Test2, does not exist on this server.
Msg 911, Level 16, State 1, Line 1
Database '$(DatabaseName)' does not exist. Make sure that the name is entered correctly.


Can Some one please help me out

modified 27-Sep-12 3:06am.

AnswerRe: sql script Pin
ihoecken26-Sep-12 21:10
memberihoecken26-Sep-12 21:10 
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 
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 

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
Web01 | 2.8.160826.1 | Last Updated 27 Aug 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid