Click here to Skip to main content
15,867,946 members
Home / Discussions / Database
   

Database

 
QuestionProblem creating new username in sql language Pin
Member 1316151629-Apr-17 11:08
Member 1316151629-Apr-17 11:08 
AnswerRe: Problem creating new username in sql language Pin
Mycroft Holmes29-Apr-17 14:50
professionalMycroft Holmes29-Apr-17 14:50 
QuestionRe: Problem creating new username in sql language Pin
ZurdoDev2-May-17 10:14
professionalZurdoDev2-May-17 10:14 
AnswerRe: Problem creating new username in sql language Pin
Victor Nijegorodov2-May-17 11:23
Victor Nijegorodov2-May-17 11:23 
Questionhow to get metadata of table from database in php? Pin
Member 1314302421-Apr-17 1:37
Member 1314302421-Apr-17 1:37 
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 
Hi,

I want to avoid dynamic sql but my Table name varies for different run, is there any better way to avoid the dynamic sql in this situation?
I am trying my best, searching, asking and implementing different approaches etc, if anybody can give me some suggestion, link or even code snippet that would very helpful.

Hi,

I have a table (Table123) that has Columns ColA, ColB, ColC, ColD, ColE, ColF, ColG, I have many rows entered in the same table but want to check for two rows RowA, RowB, if for example I have three columns that are different in these two rows, I want to select those Column Names, like if ColA, ColC and ColE are changed then my query should return me as below

TableName, ChangedColumnName, OldValue, NewValue
Table123 , ColA, 123 Greetings 123 New Greetings
Table123 , ColC, 123 World 123 Hello World
Table123 , ColE, 123 Test World 123 New World

etc.

Is there anyway I can do it, but without using dynamic sql any help would be greatly helpful, thanks in advance.

Thanks in advance

Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."


-- modified 17-Apr-17 16:04pm.
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 
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 

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.