Click here to Skip to main content
15,119,786 members
Home / Discussions / Database
   

Database

 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Uranium-23519-Apr-20 17:37
MemberUranium-23519-Apr-20 17:37 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Richard MacCutchan19-Apr-20 22:46
mveRichard MacCutchan19-Apr-20 22:46 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Uranium-23520-Apr-20 0:05
MemberUranium-23520-Apr-20 0:05 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Richard MacCutchan20-Apr-20 0:35
mveRichard MacCutchan20-Apr-20 0:35 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Uranium-23520-Apr-20 10:44
MemberUranium-23520-Apr-20 10:44 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Richard MacCutchan20-Apr-20 22:36
mveRichard MacCutchan20-Apr-20 22:36 
GeneralRe: No rows returned using SQLiteParameters, but rows returned with direct query Pin
Richard Deeming21-Apr-20 1:35
mveRichard Deeming21-Apr-20 1:35 
Questioncomplicated SQL Join request from two server Pin
Member 1473386615-Apr-20 22:11
MemberMember 1473386615-Apr-20 22: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 1:08
mveRichard Deeming16-Apr-20 1:08 
GeneralRe: complicated SQL Join request from two server Pin
Member 1473386616-Apr-20 3:36
MemberMember 1473386616-Apr-20 3:36 
GeneralRe: complicated SQL Join request from two server Pin
Richard Deeming16-Apr-20 3:48
mveRichard Deeming16-Apr-20 3:48 
GeneralRe: complicated SQL Join request from two server Pin
Member 1473386616-Apr-20 4:04
MemberMember 1473386616-Apr-20 4:04 
QuestionGetting data from simple SQLite table returns NULL Pin
Uranium-23512-Apr-20 0:02
MemberUranium-23512-Apr-20 0:02 
AnswerRe: Getting data from simple SQLite table returns NULL Pin
Richard MacCutchan12-Apr-20 0:19
mveRichard MacCutchan12-Apr-20 0:19 
GeneralRe: Getting data from simple SQLite table returns NULL Pin
Uranium-23512-Apr-20 9:26
MemberUranium-23512-Apr-20 9:26 
GeneralRe: Getting data from simple SQLite table returns NULL Pin
Mycroft Holmes12-Apr-20 13:29
professionalMycroft Holmes12-Apr-20 13:29 
GeneralRe: Getting data from simple SQLite table returns NULL Pin
Uranium-23512-Apr-20 15:28
MemberUranium-23512-Apr-20 15:28 
GeneralRe: Getting data from simple SQLite table returns NULL Pin
Uranium-23512-Apr-20 18:25
MemberUranium-23512-Apr-20 18:25 
GeneralRe: Getting data from simple SQLite table returns NULL Pin
Richard MacCutchan12-Apr-20 22:45
mveRichard MacCutchan12-Apr-20 22:45 
QuestionSQL Login Failed Message Pin
Kevin Marois8-Apr-20 20:12
professionalKevin Marois8-Apr-20 20:12 
AnswerRe: SQL Login Failed Message Pin
Richard Deeming9-Apr-20 1:27
mveRichard Deeming9-Apr-20 1:27 
GeneralRe: SQL Login Failed Message Pin
Kevin Marois9-Apr-20 6:42
professionalKevin Marois9-Apr-20 6:42 
GeneralRe: SQL Login Failed Message Pin
Kevin Marois9-Apr-20 7:05
professionalKevin Marois9-Apr-20 7:05 
QuestionSplitting large amounts of data in a table Pin
Pita322-Apr-20 10:25
MemberPita322-Apr-20 10:25 
AnswerRe: Splitting large amounts of data in a table Pin
Mycroft Holmes2-Apr-20 12:10
professionalMycroft Holmes2-Apr-20 12: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.