Click here to Skip to main content
15,560,045 members
Home / Discussions / Database
   

Database

 
AnswerRe: help me to write procedure Pin
amistry_petlad13-Jul-08 14:41
amistry_petlad13-Jul-08 14:41 
AnswerRe: help me to write procedure Pin
nelsonpaixao13-Jul-08 15:37
nelsonpaixao13-Jul-08 15:37 
GeneralRe: help me to write procedure Pin
amistry_petlad13-Jul-08 15:47
amistry_petlad13-Jul-08 15:47 
AnswerRe: help me to write procedure Pin
leoinfo13-Jul-08 18:21
leoinfo13-Jul-08 18:21 
GeneralRe: help me to write procedure Pin
amistry_petlad13-Jul-08 18:57
amistry_petlad13-Jul-08 18:57 
GeneralRe: help me to write procedure Pin
Paul Conrad13-Jul-08 19:06
professionalPaul Conrad13-Jul-08 19:06 
GeneralRe: help me to write procedure Pin
amistry_petlad13-Jul-08 19:12
amistry_petlad13-Jul-08 19:12 
GeneralRe: help me to write procedure Pin
Paul Conrad13-Jul-08 19:16
professionalPaul Conrad13-Jul-08 19:16 
Blush | :O I just realized there was the second one. The second one sets a variable that is the sql string, and the exec(...) executes the sql string.

You could get really fancy with this stored proc, such as adding where clause, and order by as parameters into the stored proc, and add them to the @cmd variable.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon


GeneralRe: help me to write procedure Pin
nelsonpaixao13-Jul-08 16:12
nelsonpaixao13-Jul-08 16:12 
GeneralRe: help me to write procedure Pin
amistry_petlad13-Jul-08 18:58
amistry_petlad13-Jul-08 18:58 
Questiondecimal not show zero [modified] Pin
tai-fun12-Jul-08 4:38
tai-fun12-Jul-08 4:38 
AnswerRe: decimal not show zero Pin
leoinfo12-Jul-08 8:07
leoinfo12-Jul-08 8:07 
Questionrow to column in sql Pin
ravindra_ee24811-Jul-08 20:58
ravindra_ee24811-Jul-08 20:58 
AnswerRe: row to column in sql Pin
Vimalsoft(Pty) Ltd13-Jul-08 16:55
professionalVimalsoft(Pty) Ltd13-Jul-08 16:55 
QuestionMail Triggering in SQL_Server Problem Pin
sabaMCA11-Jul-08 14:43
sabaMCA11-Jul-08 14:43 
AnswerRe: Mail Triggering in SQL_Server Problem Pin
Vimalsoft(Pty) Ltd12-Jul-08 12:11
professionalVimalsoft(Pty) Ltd12-Jul-08 12:11 
QuestionMail Triggering in SQL_Server Problem Pin
sabaMCA11-Jul-08 14:42
sabaMCA11-Jul-08 14:42 
QuestionHow to store stored proc results to a temp table Pin
DotNetXenon11-Jul-08 11:52
DotNetXenon11-Jul-08 11:52 
AnswerRe: How to store stored proc results to a temp table Pin
Vimalsoft(Pty) Ltd12-Jul-08 12:17
professionalVimalsoft(Pty) Ltd12-Jul-08 12:17 
GeneralSQL Server connection timeout [modified] Pin
dlarkin7711-Jul-08 4:44
dlarkin7711-Jul-08 4:44 
GeneralRe: SQL Server connection timeout Pin
Simon P Stevens11-Jul-08 4:48
Simon P Stevens11-Jul-08 4:48 
GeneralRe: SQL Server connection timeout Pin
SimulationofSai11-Jul-08 5:07
SimulationofSai11-Jul-08 5:07 
GeneralRe: SQL Server connection timeout Pin
dlarkin7711-Jul-08 5:26
dlarkin7711-Jul-08 5:26 
GeneralRe: SQL Server connection timeout Pin
Member 9611-Jul-08 6:46
Member 9611-Jul-08 6:46 
GeneralRe: SQL Server connection timeout Pin
Tomz_KV11-Jul-08 6:48
Tomz_KV11-Jul-08 6:48 

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.