Click here to Skip to main content
15,936,294 members
Home / Discussions / Database
   

Database

 
GeneralRe: Rows as column using Pivot but with multiple rows and Column Pin
Richard Deeming9-Nov-15 2:01
mveRichard Deeming9-Nov-15 2:01 
GeneralRe: Rows as column using Pivot but with multiple rows and Column Pin
sandeepmittal119-Nov-15 19:25
sandeepmittal119-Nov-15 19:25 
QuestionError in IF statement in MySQL Pin
Jassim Rahma29-Oct-15 4:31
Jassim Rahma29-Oct-15 4:31 
AnswerRe: Error in IF statement in MySQL Pin
Eddy Vluggen29-Oct-15 5:08
professionalEddy Vluggen29-Oct-15 5:08 
AnswerRe: Error in IF statement in MySQL Pin
Wombaticus29-Oct-15 5:45
Wombaticus29-Oct-15 5:45 
QuestionGet all Tables which have Duplicate values on Columns Name and Description Pin
indian14328-Oct-15 14:09
indian14328-Oct-15 14:09 
AnswerRe: Get all Tables which have Duplicate values on Columns Name and Description Pin
Jörgen Andersson28-Oct-15 22:31
professionalJörgen Andersson28-Oct-15 22:31 
GeneralRe: Get all Tables which have Duplicate values on Columns Name and Description Pin
indian14329-Oct-15 8:29
indian14329-Oct-15 8:29 
anyways is fine it is just an internal running script but I want to run it on all tables in the selected database on selected server. I though of little bit with dynamic sql but yes that's question too, is there any better approach for it than dynamic sql?
Thanks,

Abdul Aleem

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

AnswerRe: Get all Tables which have Duplicate values on Columns Name and Description Pin
RNA Team30-Oct-15 20:13
RNA Team30-Oct-15 20:13 
QuestionLoad data from Excel which has columns in multiple rows Pin
indian14328-Oct-15 4:08
indian14328-Oct-15 4:08 
AnswerRe: Load data from Excel which has columns in multiple rows Pin
Richard MacCutchan28-Oct-15 7:18
mveRichard MacCutchan28-Oct-15 7:18 
GeneralRe: Load data from Excel which has columns in multiple rows Pin
indian14328-Oct-15 8:37
indian14328-Oct-15 8:37 
GeneralRe: Load data from Excel which has columns in multiple rows Pin
Richard Deeming28-Oct-15 10:05
mveRichard Deeming28-Oct-15 10:05 
GeneralRe: Load data from Excel which has columns in multiple rows Pin
indian14328-Oct-15 11:02
indian14328-Oct-15 11:02 
QuestionUse column output, to get new column Pin
Karan_TN27-Oct-15 19:54
Karan_TN27-Oct-15 19:54 
AnswerRe: Use column output, to get new column Pin
Mycroft Holmes27-Oct-15 20:42
professionalMycroft Holmes27-Oct-15 20:42 
Questionselect to Cancatenate sub group values under a group Pin
indian14327-Oct-15 3:07
indian14327-Oct-15 3:07 
QuestionStoring Result Of A Select Statement In A Variable Pin
MadDashCoder23-Oct-15 13:13
MadDashCoder23-Oct-15 13:13 
AnswerRe: Storing Result Of A Select Statement In A Variable Pin
CHill6025-Oct-15 4:52
mveCHill6025-Oct-15 4:52 
AnswerRe: Storing Result Of A Select Statement In A Variable Pin
Anudeep Jaiswal - MCA17-Nov-15 18:22
Anudeep Jaiswal - MCA17-Nov-15 18:22 
Questionhow to create a database if data is given? Pin
Member 1127090223-Oct-15 6:00
Member 1127090223-Oct-15 6:00 
AnswerRe: how to create a database if data is given? Pin
Eddy Vluggen23-Oct-15 6:29
professionalEddy Vluggen23-Oct-15 6:29 
GeneralRe: how to create a database if data is given? Pin
Member 1127090223-Oct-15 7:02
Member 1127090223-Oct-15 7:02 
GeneralRe: how to create a database if data is given? Pin
Eddy Vluggen23-Oct-15 7:17
professionalEddy Vluggen23-Oct-15 7:17 
GeneralRe: how to create a database if data is given? Pin
Member 1127090223-Oct-15 7:28
Member 1127090223-Oct-15 7:28 

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.