Click here to Skip to main content
15,851,453 members
Home / Discussions / Database
   

Database

 
GeneralRe: Row Terminator not working: Pin
Ashfield21-May-08 22:19
Ashfield21-May-08 22:19 
GeneralRe: Row Terminator not working: Pin
Shahzad.Aslam21-May-08 22:41
Shahzad.Aslam21-May-08 22:41 
GeneralRe: Row Terminator not working: Pin
Ashfield21-May-08 23:28
Ashfield21-May-08 23:28 
QuestionSql Stored Procedure Pin
senthilsstil21-May-08 0:58
senthilsstil21-May-08 0:58 
Questionhow to retrive the value of the sp output through execute immediate Pin
lakshmichawala21-May-08 0:08
lakshmichawala21-May-08 0:08 
Questionsql query Pin
Unknown Ajanabi21-May-08 0:02
Unknown Ajanabi21-May-08 0:02 
AnswerRe: sql query Pin
Colin Angus Mackay21-May-08 2:01
Colin Angus Mackay21-May-08 2:01 
AnswerRe: sql query Pin
Michael Potter21-May-08 11:23
Michael Potter21-May-08 11:23 
@key must be in quotes.

ALTER procedure getkeyname(@city sysname,@key varchar(50))
as
exec
('select distinct a.keywordname,a.keywordid from keyword As a INNER

JOIN ' + @city + ' As b on a.keywordid=b.keywordid and

a.keywordname like ''' + @key + '''')
Questionproblem with SQLparameter? Pin
Mr.Kode20-May-08 23:20
Mr.Kode20-May-08 23:20 
AnswerRe: problem with SQLparameter? Pin
Unknown Ajanabi21-May-08 0:17
Unknown Ajanabi21-May-08 0:17 
GeneralRe: problem with SQLparameter? Pin
Mr.Kode21-May-08 0:20
Mr.Kode21-May-08 0:20 
GeneralRe: problem with SQLparameter? Pin
Unknown Ajanabi21-May-08 0:50
Unknown Ajanabi21-May-08 0:50 
AnswerCP Ignore Pin
leckey21-May-08 4:20
leckey21-May-08 4:20 
Questiondistinct? Pin
laserbaronen20-May-08 22:40
laserbaronen20-May-08 22:40 
AnswerRe: distinct? Pin
Blue_Boy20-May-08 23:47
Blue_Boy20-May-08 23:47 
QuestionRe: distinct? Pin
laserbaronen20-May-08 23:51
laserbaronen20-May-08 23:51 
AnswerRe: distinct? Pin
Blue_Boy20-May-08 23:53
Blue_Boy20-May-08 23:53 
GeneralRe: distinct? Pin
laserbaronen21-May-08 0:02
laserbaronen21-May-08 0:02 
GeneralRe: distinct? Pin
Blue_Boy21-May-08 0:19
Blue_Boy21-May-08 0:19 
GeneralRe: distinct? Pin
laserbaronen21-May-08 0:31
laserbaronen21-May-08 0:31 
GeneralRe: distinct? Pin
Blue_Boy21-May-08 0:32
Blue_Boy21-May-08 0:32 
QuestionPrimary Keys Pin
MAW3020-May-08 17:50
MAW3020-May-08 17:50 
AnswerRe: Primary Keys Pin
ChandraRam20-May-08 22:00
ChandraRam20-May-08 22:00 
QuestionInner Join to match multiple rows in lookup table Pin
redivider20-May-08 11:59
redivider20-May-08 11:59 
AnswerRe: Inner Join to match multiple rows in lookup table Pin
WoutL20-May-08 21:12
WoutL20-May-08 21:12 

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.