Click here to Skip to main content
14,667,362 members
Home » Discussions » Database
   

Database

 
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 
Is there a way to split data into two separate tables with a single SQL statement? I know that sounds like an odd question, but I have a large table in terms of rows, and I would like to "split" the data into two separate tables for separate processing in parallel fashion. Call me crazy but I thought there was a way to do that in SQL Server, i.e. a SQL statement to divide the table into two separate tables.

Is there a way to do that or am I misremembering?
AnswerRe: Splitting large amounts of data in a table Pin
Mycroft Holmes2-Apr-20 11:10
professionalMycroft Holmes2-Apr-20 11:10 
AnswerRe: Splitting large amounts of data in a table Pin
Gerry Schmitz2-Apr-20 18:29
mveGerry Schmitz2-Apr-20 18:29 
AnswerRe: Splitting large amounts of data in a table Pin
Victor Nijegorodov2-Apr-20 23:43
MemberVictor Nijegorodov2-Apr-20 23:43 
QuestionQuestion Regarding SQL Parameter Query Pin
Michele Smith31-Mar-20 9:14
MemberMichele Smith31-Mar-20 9:14 
AnswerRe: Question Regarding SQL Parameter Query Pin
ZurdoDev31-Mar-20 9:49
mveZurdoDev31-Mar-20 9:49 
AnswerRe: Question Regarding SQL Parameter Query Pin
Victor Nijegorodov1-Apr-20 1:35
MemberVictor Nijegorodov1-Apr-20 1:35 
AnswerRe: Question Regarding SQL Parameter Query Pin
Richard Deeming1-Apr-20 2:32
mveRichard Deeming1-Apr-20 2:32 
QuestionTrigger keeps inserting duplicates Pin
greatwhite131-Mar-20 7:48
Membergreatwhite131-Mar-20 7:48 
AnswerRe: Trigger keeps inserting duplicates Pin
ZurdoDev31-Mar-20 9:51
mveZurdoDev31-Mar-20 9:51 
GeneralRe: Trigger keeps inserting duplicates Pin
greatwhite131-Mar-20 13:51
Membergreatwhite131-Mar-20 13:51 
GeneralRe: Trigger keeps inserting duplicates Pin
ZurdoDev31-Mar-20 15:44
mveZurdoDev31-Mar-20 15:44 
AnswerRe: Trigger keeps inserting duplicates Pin
Richard Deeming1-Apr-20 0:44
mveRichard Deeming1-Apr-20 0:44 
RantRe: Trigger keeps inserting duplicates Pin
Mycroft Holmes1-Apr-20 12:45
professionalMycroft Holmes1-Apr-20 12:45 
QuestionHow to calculate the daily and weekly averages using sql server or alternate sql softwares Pin
Barath835730-Mar-20 1:57
MemberBarath835730-Mar-20 1:57 
RantRe: How to calculate the daily and weekly averages using sql server or alternate sql softwares Pin
ZurdoDev30-Mar-20 2:12
mveZurdoDev30-Mar-20 2:12 
AnswerRe: How to calculate the daily and weekly averages using sql server or alternate sql softwares Pin
ZurdoDev31-Mar-20 9:52
mveZurdoDev31-Mar-20 9:52 
AnswerRe: How to calculate the daily and weekly averages using sql server or alternate sql softwares Pin
Mycroft Holmes31-Mar-20 12:50
professionalMycroft Holmes31-Mar-20 12:50 

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.