Click here to Skip to main content
14,637,446 members
Home » Discussions » Database
   

Database

 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Uranium-23519-Apr-20 16:37
MemberUranium-23519-Apr-20 16:37 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Richard MacCutchan19-Apr-20 21:46
mveRichard MacCutchan19-Apr-20 21:46 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Uranium-23519-Apr-20 23:05
MemberUranium-23519-Apr-20 23:05 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Richard MacCutchan19-Apr-20 23:35
mveRichard MacCutchan19-Apr-20 23:35 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Uranium-23520-Apr-20 9:44
MemberUranium-23520-Apr-20 9:44 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Richard MacCutchan20-Apr-20 21:36
mveRichard MacCutchan20-Apr-20 21:36 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Richard Deeming21-Apr-20 0:35
mveRichard Deeming21-Apr-20 0:35 
Questioncomplicated SQL Join request from two server Pin
Member 1473386615-Apr-20 21:11
MemberMember 1473386615-Apr-20 21:11 
i have Two Database in two different servers i want to join two tables from this two Databases

 i have no relation between them but just a column wich contain information about the other database 

Ex : Database1.dbo.informationCity contain a column named Specification and have this information: 
14042020111925_GMS3439_09_04_2020-04_48.xml_6456.zip 

i want to extract from this column just this number 3439 because with this number i can rely the other database 

Ex : Database2.dbo.city contain a column named cityID : 3439 

any body have an idea how to do that ? 
i tried this Sql request but it did not work

    <pre lang="SQL">SELECT 
    *
      FROM [mo].[dbo].[Database1]
      INNER JOIN [Database2].[dbo].[city ] ON substring([Specification], CHARINDEX('GMS', [Specification ]) + 3,4) = 
      [Database2].[dbo].[city ].[cityID]

AnswerRe: complicated SQL Join request from two server Pin
Richard Deeming16-Apr-20 0:08
mveRichard Deeming16-Apr-20 0:08 
GeneralRe: complicated SQL Join request from two server Pin
Member 1473386616-Apr-20 2:36
MemberMember 1473386616-Apr-20 2:36 
GeneralRe: complicated SQL Join request from two server Pin
Richard Deeming16-Apr-20 2:48
mveRichard Deeming16-Apr-20 2:48 
GeneralRe: complicated SQL Join request from two server Pin
Member 1473386616-Apr-20 3:04
MemberMember 1473386616-Apr-20 3:04 
QuestionGetting data from simple SQLite table returns NULL Pin
Uranium-23511-Apr-20 23:02
MemberUranium-23511-Apr-20 23:02 
AnswerRe: Getting data from simple SQLite table returns NULL Pin
Richard MacCutchan11-Apr-20 23:19
mveRichard MacCutchan11-Apr-20 23:19 
GeneralRe: Getting data from simple SQLite table returns NULL Pin
Uranium-23512-Apr-20 8:26
MemberUranium-23512-Apr-20 8:26 
GeneralRe: Getting data from simple SQLite table returns NULL Pin
Mycroft Holmes12-Apr-20 12:29
professionalMycroft Holmes12-Apr-20 12:29 
GeneralRe: Getting data from simple SQLite table returns NULL Pin
Uranium-23512-Apr-20 14:28
MemberUranium-23512-Apr-20 14:28 
GeneralRe: Getting data from simple SQLite table returns NULL Pin
Uranium-23512-Apr-20 17:25
MemberUranium-23512-Apr-20 17:25 
GeneralRe: Getting data from simple SQLite table returns NULL Pin
Richard MacCutchan12-Apr-20 21:45
mveRichard MacCutchan12-Apr-20 21:45 
QuestionSQL Login Failed Message Pin
Kevin Marois8-Apr-20 19:12
professionalKevin Marois8-Apr-20 19:12 
AnswerRe: SQL Login Failed Message Pin
Richard Deeming9-Apr-20 0:27
mveRichard Deeming9-Apr-20 0:27 
GeneralRe: SQL Login Failed Message Pin
Kevin Marois9-Apr-20 5:42
professionalKevin Marois9-Apr-20 5:42 
GeneralRe: SQL Login Failed Message Pin
Kevin Marois9-Apr-20 6:05
professionalKevin Marois9-Apr-20 6:05 
QuestionSplitting large amounts of data in a table Pin
Pita322-Apr-20 9:25
MemberPita322-Apr-20 9:25 
AnswerRe: Splitting large amounts of data in a table Pin
Mycroft Holmes2-Apr-20 11:10
professionalMycroft Holmes2-Apr-20 11:10 

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.