Click here to Skip to main content
15,845,115 members
Home / Discussions / Database
   

Database

 
AnswerRe: Critical probs to display records..., Pin
Devkranth Kishore Vanja28-Jun-07 21:24
Devkranth Kishore Vanja28-Jun-07 21:24 
GeneralRe: Critical probs to display records..., Pin
Member 387988128-Jun-07 21:57
Member 387988128-Jun-07 21:57 
AnswerRe: Critical probs to display records..., Pin
Navneet Hegde29-Jun-07 4:34
Navneet Hegde29-Jun-07 4:34 
QuestionParamaterized Queries vs. Stored Procedures Pin
martin_hughes28-Jun-07 9:17
martin_hughes28-Jun-07 9:17 
AnswerRe: Paramaterized Queries vs. Stored Procedures Pin
kubben28-Jun-07 10:09
kubben28-Jun-07 10:09 
AnswerRe: Paramaterized Queries vs. Stored Procedures [modified] Pin
Mike Dimmick28-Jun-07 10:22
Mike Dimmick28-Jun-07 10:22 
GeneralRe: Paramaterized Queries vs. Stored Procedures Pin
martin_hughes29-Jun-07 2:34
martin_hughes29-Jun-07 2:34 
AnswerRe: Paramaterized Queries vs. Stored Procedures Pin
originSH29-Jun-07 1:11
originSH29-Jun-07 1:11 
This subject is hotly debated and is often the cause of religious wars! Well on the web anyway Wink | ;)

http://www.google.co.uk/search?hl=en&q=stored+procs+vs+dynamic+queries&meta=[^]

Personally I like Stored Procs, they appeal to my OO side with their encapsulation of data access sql code in the database. Another advantage is not having to update your application to change a query. But as others have said dynamic sql definatly has its place and shouldn't be completely dismissed.
GeneralRe: Paramaterized Queries vs. Stored Procedures Pin
martin_hughes29-Jun-07 2:32
martin_hughes29-Jun-07 2:32 
QuestionView more than one page with CrystalReportViewer vb.net Pin
kindman_nb28-Jun-07 6:09
kindman_nb28-Jun-07 6:09 
QuestionAlternative of CONVERT function in MS Access Pin
FishiFishi28-Jun-07 4:12
FishiFishi28-Jun-07 4:12 
AnswerRe: Alternative of CONVERT function in MS Access Pin
leckey28-Jun-07 5:20
leckey28-Jun-07 5:20 
Questiondatetime code Pin
niki_nilu28-Jun-07 2:56
niki_nilu28-Jun-07 2:56 
AnswerRe: datetime code Pin
Sathesh Sakthivel28-Jun-07 3:22
Sathesh Sakthivel28-Jun-07 3:22 
Questiondatetime problem Pin
niki_nilu28-Jun-07 1:54
niki_nilu28-Jun-07 1:54 
AnswerRe: datetime problem Pin
Krish - KP28-Jun-07 2:30
Krish - KP28-Jun-07 2:30 
GeneralRe: datetime problem Pin
FishiFishi28-Jun-07 4:16
FishiFishi28-Jun-07 4:16 
AnswerRe: datetime problem Pin
Pratik Vasant Shah28-Jun-07 21:19
Pratik Vasant Shah28-Jun-07 21:19 
Questionhow to pass null values to a query in the design time Pin
pashitech28-Jun-07 1:12
pashitech28-Jun-07 1:12 
AnswerRe: how to pass null values to a query in the design time Pin
Xandip28-Jun-07 21:13
Xandip28-Jun-07 21:13 
QuestionDate Time String Transformation sample mssql Pin
cutequencher28-Jun-07 0:18
cutequencher28-Jun-07 0:18 
AnswerRe: Date Time String Transformation sample mssql Pin
andyharman28-Jun-07 1:18
professionalandyharman28-Jun-07 1:18 
GeneralRe: Date Time String Transformation sample mssql Pin
cutequencher28-Jun-07 1:39
cutequencher28-Jun-07 1:39 
Questionsql data adapter.update Pin
Sebastian T Xavier27-Jun-07 23:42
Sebastian T Xavier27-Jun-07 23:42 
AnswerRe: sql data adapter.update Pin
Vimalsoft(Pty) Ltd28-Jun-07 23:35
professionalVimalsoft(Pty) Ltd28-Jun-07 23:35 

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.