Click here to Skip to main content
14,832,945 members
Home / Discussions / Database
   

Database

 
QuestionSQL Server store procedure and prevent sql injection Pin
Mou_kol6-Oct-17 8:45
MemberMou_kol6-Oct-17 8:45 
AnswerRe: SQL Server store procedure and prevent sql injection Pin
Richard Deeming6-Oct-17 9:27
mveRichard Deeming6-Oct-17 9:27 
GeneralRe: SQL Server store procedure and prevent sql injection Pin
Mou_kol6-Oct-17 11:30
MemberMou_kol6-Oct-17 11:30 
GeneralRe: SQL Server store procedure and prevent sql injection Pin
Eddy Vluggen7-Oct-17 2:22
professionalEddy Vluggen7-Oct-17 2:22 
GeneralRe: SQL Server store procedure and prevent sql injection Pin
Richard Deeming9-Oct-17 8:59
mveRichard Deeming9-Oct-17 8:59 
GeneralRe: SQL Server store procedure and prevent sql injection Pin
MadMyche22-Nov-17 4:13
mveMadMyche22-Nov-17 4:13 
QuestionImporting the integer values that are coming within " Pin
indian1435-Oct-17 14:14
Memberindian1435-Oct-17 14:14 
AnswerRe: Importing the integer values that are coming within " Pin
jschell6-Oct-17 7:18
Memberjschell6-Oct-17 7:18 
indian143 wrote:
is there anything that I can do to eliminate those " and implement Data conversion without any problems


Based on the following - no.

Connect to a Flat File Data Source (SQL Server Import and Export Wizard) | Microsoft Docs[^]

You might want to review the actual input spec yourself in the hope the docs are wrong.

Presuming there is no option, and you cannot get the source adjusted, then you must
1. Take all of the values as strings
2. Add a post process step to convert to correct values (remove quotes and convert to numeric as needed.)
QuestionYou cannot install the 64-bit version of Microsoft Access Database Engine 2016 because you currently have 32-bit Office Products installed Pin
indian1432-Oct-17 11:49
Memberindian1432-Oct-17 11:49 
QuestionRe: You cannot install the 64-bit version of Microsoft Access Database Engine 2016 because you currently have 32-bit Office Products installed Pin
Richard MacCutchan2-Oct-17 21:53
mveRichard MacCutchan2-Oct-17 21:53 
AnswerRe: You cannot install the 64-bit version of Microsoft Access Database Engine 2016 because you currently have 32-bit Office Products installed Pin
jschell4-Oct-17 7:53
Memberjschell4-Oct-17 7:53 
QuestionHow Commonly used are the dotNet Datatables and Datasets? Pin
MarcusCole683328-Sep-17 6:06
professionalMarcusCole683328-Sep-17 6:06 
AnswerRe: How Commonly used are the dotNet Datatables and Datasets? Pin
Eddy Vluggen28-Sep-17 6:58
professionalEddy Vluggen28-Sep-17 6:58 
AnswerRe: How Commonly used are the dotNet Datatables and Datasets? Pin
Richard MacCutchan28-Sep-17 9:45
mveRichard MacCutchan28-Sep-17 9:45 
AnswerRe: How Commonly used are the dotNet Datatables and Datasets? Pin
Mycroft Holmes28-Sep-17 14:08
professionalMycroft Holmes28-Sep-17 14:08 
Questionhow to get the music database for my website? Pin
Member 1322076227-Sep-17 7:57
MemberMember 1322076227-Sep-17 7:57 
AnswerRe: how to get the music database for my website? Pin
OriginalGriff27-Sep-17 8:00
mveOriginalGriff27-Sep-17 8:00 
GeneralRe: how to get the music database for my website? Pin
Member 1322076224-Nov-17 19:08
MemberMember 1322076224-Nov-17 19:08 
AnswerRe: how to get the music database for my website? Pin
jschell27-Sep-17 9:28
Memberjschell27-Sep-17 9:28 
QuestionSSIS Packages are running on Staging but not on the Production Server - little bit Urgent my friends Pin
indian14326-Sep-17 6:34
Memberindian14326-Sep-17 6:34 
AnswerRe: SSIS Packages are running on Staging but not on the Production Server Pin
Eddy Vluggen27-Sep-17 3:35
professionalEddy Vluggen27-Sep-17 3:35 
AnswerRe: SSIS Packages are running on Staging but not on the Production Server Pin
jschell27-Sep-17 9:31
Memberjschell27-Sep-17 9:31 
QuestionNeed to find out what drivers are missing on the Production Server Pin
indian14321-Sep-17 7:32
Memberindian14321-Sep-17 7:32 
AnswerRe: Need to find out what drivers are missing on the Production Server Pin
Eddy Vluggen21-Sep-17 23:23
professionalEddy Vluggen21-Sep-17 23:23 
Questionreference in DB design Pin
a_yosef19-Sep-17 0:01
Membera_yosef19-Sep-17 0:01 

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.