Click here to Skip to main content
14,879,958 members
Home / Discussions / Database
   

Database

 
AnswerRe: Get specific records from DB Pin
Mycroft Holmes28-Oct-17 23:54
professionalMycroft Holmes28-Oct-17 23:54 
QuestionA question about the behavior of Jet and Ace drivers Pin
indian14324-Oct-17 7:58
Memberindian14324-Oct-17 7:58 
GeneralRe: A question about the behavior of Jet and Ace drivers Pin
PIEBALDconsult24-Oct-17 8:32
professionalPIEBALDconsult24-Oct-17 8:32 
GeneralRe: A question about the behavior of Jet and Ace drivers Pin
indian14325-Oct-17 7:15
Memberindian14325-Oct-17 7:15 
GeneralRe: A question about the behavior of Jet and Ace drivers Pin
jschell27-Oct-17 7:43
Memberjschell27-Oct-17 7:43 
QuestionMath expression as Column value as string in the Dynamic Sql Pin
indian14319-Oct-17 7:19
Memberindian14319-Oct-17 7:19 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
Richard MacCutchan19-Oct-17 7:33
mveRichard MacCutchan19-Oct-17 7:33 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
indian14319-Oct-17 8:10
Memberindian14319-Oct-17 8:10 
No I am passing it as a string only from an ssis package variable which is of type string, I am appending both these strings as 'col1, col2, col3' + ', ''' + @reportId + '''' and passing it as nvarchar parameter into a stored procedure

Exec [ETL].[PopulateStageTable] ?, ?, ?, ?, ?, ?, ?

There are other Parameters but they are not giving any problem excel this, I checked even the execute sql too has this parameter defined as nvarchar and same thing in the Stored procedure too, nothing is converted to number or anything like that

Thanks,

Abdul Aleem

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

GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
jschell20-Oct-17 9:27
Memberjschell20-Oct-17 9:27 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
Eddy Vluggen20-Oct-17 10:47
professionalEddy Vluggen20-Oct-17 10:47 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
indian14324-Oct-17 6:41
Memberindian14324-Oct-17 6:41 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
jschell25-Oct-17 9:19
Memberjschell25-Oct-17 9:19 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
indian14330-Oct-17 7:37
Memberindian14330-Oct-17 7:37 
QuestionGUID or long for MVC site Pin
#realJSOP17-Oct-17 6:37
mva#realJSOP17-Oct-17 6:37 
AnswerRe: GUID or long for MVC site Pin
Wendelius17-Oct-17 7:01
mveWendelius17-Oct-17 7:01 
AnswerRe: GUID or long for MVC site Pin
jschell17-Oct-17 7:43
Memberjschell17-Oct-17 7:43 
GeneralRe: GUID or long for MVC site Pin
k505418-Oct-17 5:30
mvek505418-Oct-17 5:30 
GeneralRe: GUID or long for MVC site Pin
jschell20-Oct-17 8:34
Memberjschell20-Oct-17 8:34 
AnswerRe: GUID or long for MVC site Pin
Eddy Vluggen17-Oct-17 23:38
professionalEddy Vluggen17-Oct-17 23:38 
AnswerRe: GUID or long for MVC site Pin
Gerry Schmitz18-Oct-17 18:32
mveGerry Schmitz18-Oct-17 18:32 
QuestionInserting the values of a Stored Procedure directly into a Table by using the Column names Pin
indian14313-Oct-17 12:59
Memberindian14313-Oct-17 12:59 
AnswerRe: Inserting the values of a Stored Procedure directly into a Table by using the Column names Pin
jschell15-Oct-17 8:15
Memberjschell15-Oct-17 8:15 
GeneralRe: Inserting the values of a Stored Procedure directly into a Table by using the Column names Pin
indian14315-Oct-17 15:03
Memberindian14315-Oct-17 15:03 
GeneralRe: Inserting the values of a Stored Procedure directly into a Table by using the Column names Pin
indian14316-Oct-17 7:25
Memberindian14316-Oct-17 7:25 
GeneralRe: Inserting the values of a Stored Procedure directly into a Table by using the Column names Pin
Eddy Vluggen17-Oct-17 2:14
professionalEddy Vluggen17-Oct-17 2:14 

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.