Click here to Skip to main content
15,921,941 members
Home / Discussions / Database
   

Database

 
AnswerRe: how to get metadata of table from database in php? Pin
Afzaal Ahmad Zeeshan21-Apr-17 2:22
professionalAfzaal Ahmad Zeeshan21-Apr-17 2:22 
AnswerRe: how to get metadata of table from database in php? Pin
Eddy Vluggen21-Apr-17 3:52
professionalEddy Vluggen21-Apr-17 3:52 
QuestionWant to avoid Dynamic Sql even if the Table name is random Pin
indian14317-Apr-17 8:40
indian14317-Apr-17 8:40 
AnswerRe: Want to avoid Dynamic Sql even if the Table name is random Pin
Wendelius17-Apr-17 8:53
mentorWendelius17-Apr-17 8:53 
GeneralRe: Want to avoid Dynamic Sql even if the Table name is random Pin
indian14317-Apr-17 9:46
indian14317-Apr-17 9:46 
GeneralRe: Want to avoid Dynamic Sql even if the Table name is random Pin
indian14317-Apr-17 10:04
indian14317-Apr-17 10:04 
QuestionRe: Want to avoid Dynamic Sql even if the Table name is random Pin
CHill6018-Apr-17 4:19
mveCHill6018-Apr-17 4:19 
GeneralRe: Want to avoid Dynamic Sql even if the Table name is random Pin
Mycroft Holmes18-Apr-17 14:33
professionalMycroft Holmes18-Apr-17 14:33 
Chilli is right, dynamic sql is unlikely to be your problem, query design is almost certainly the cause of slow processing.

You need to create a temp table that hold all the field from the various sources and feed the records into that table to make the structure the same.
Never underestimate the power of human stupidity
RAH

GeneralRe: Want to avoid Dynamic Sql even if the Table name is random Pin
indian14320-Apr-17 12:58
indian14320-Apr-17 12:58 
GeneralRe: Want to avoid Dynamic Sql even if the Table name is random Pin
Mycroft Holmes20-Apr-17 14:10
professionalMycroft Holmes20-Apr-17 14:10 
GeneralRe: Want to avoid Dynamic Sql even if the Table name is random Pin
CHill6023-Apr-17 22:26
mveCHill6023-Apr-17 22:26 
Questioncontext::Context(void) - cs_ctx_alloc() failed Pin
papi2414-Apr-17 1:29
papi2414-Apr-17 1:29 
QuestionRelational Database Design for N dimensional function, I have some problems Pin
User 110609796-Apr-17 3:26
User 110609796-Apr-17 3:26 
AnswerRe: Relational Database Design for N dimensional function, I have some problems Pin
Mycroft Holmes6-Apr-17 11:40
professionalMycroft Holmes6-Apr-17 11:40 
GeneralRe: Relational Database Design for N dimensional function, I have some problems Pin
User 110609796-Apr-17 19:18
User 110609796-Apr-17 19:18 
QuestionCannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" Pin
indian1435-Apr-17 9:53
indian1435-Apr-17 9:53 
AnswerRe: Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" Pin
Mycroft Holmes5-Apr-17 12:46
professionalMycroft Holmes5-Apr-17 12:46 
QuestionWhat is merge join in sql server Pin
Tridip Bhattacharjee23-Mar-17 22:56
professionalTridip Bhattacharjee23-Mar-17 22:56 
AnswerRe: What is merge join in sql server Pin
CHill6023-Mar-17 23:36
mveCHill6023-Mar-17 23:36 
GeneralRe: What is merge join in sql server Pin
Richard MacCutchan24-Mar-17 1:40
mveRichard MacCutchan24-Mar-17 1:40 
GeneralRe: What is merge join in sql server Pin
CHill6028-Mar-17 1:31
mveCHill6028-Mar-17 1:31 
GeneralRe: What is merge join in sql server Pin
Tridip Bhattacharjee27-Mar-17 22:33
professionalTridip Bhattacharjee27-Mar-17 22:33 
GeneralRe: What is merge join in sql server Pin
CHill6028-Mar-17 0:42
mveCHill6028-Mar-17 0:42 
GeneralRe: What is merge join in sql server Pin
Eddy Vluggen28-Mar-17 1:35
professionalEddy Vluggen28-Mar-17 1:35 
QuestionGet all Packages that are failed to execute Pin
indian14321-Mar-17 14:15
indian14321-Mar-17 14:15 

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.