Click here to Skip to main content
15,794,124 members
Home / Discussions / Database
   

Database

 
GeneralRe: MS-SQL Query result to HTML (how?) Pin
spsharma19-Jun-06 0:38
spsharma19-Jun-06 0:38 
Questionsetcount on Pin
vivek-g11-Jun-06 23:31
vivek-g11-Jun-06 23:31 
AnswerRe: setcount on Pin
Frank Kerrigan12-Jun-06 0:21
Frank Kerrigan12-Jun-06 0:21 
AnswerRe: setcount on Pin
sasidar_d12-Jun-06 5:19
sasidar_d12-Jun-06 5:19 
QuestionRetrieve all column if parameter is null Pin
angelagke11-Jun-06 16:58
angelagke11-Jun-06 16:58 
AnswerRe: Retrieve all column if parameter is null Pin
nguyenvhn11-Jun-06 22:29
nguyenvhn11-Jun-06 22:29 
GeneralRe: Retrieve all column if parameter is null Pin
angelagke12-Jun-06 18:52
angelagke12-Jun-06 18:52 
GeneralRe: Retrieve all column if parameter is null Pin
r.stropek12-Jun-06 22:41
r.stropek12-Jun-06 22:41 
Hi!

You can simplify this statement:

Declare @au_lname char(30)
Select @au_lname = ''

select title, price, Name = substring (au_lname, 1,40), type
from   titleauthor ta 
       JOIN authors a on ta.au_id = a.au_id
       JOIN titles t on ta.title_id = t.title_id
where  RTRIM(@au_lname) = '' 
       or RTRIM(UPPER(@au_lname)) = RTRIM(UPPER(au_lname))


Regards,
Rainer.


Rainer Stropek
Visit my blog at http://www.cubido.at/rainers
GeneralRe: Retrieve all column if parameter is null Pin
angelagke14-Jun-06 17:40
angelagke14-Jun-06 17:40 
Question"operation must use an updatable query" error message Pin
isiran11-Jun-06 3:21
isiran11-Jun-06 3:21 
AnswerRe: "operation must use an updatable query" error message [modified] Pin
S Douglas12-Jun-06 21:33
professionalS Douglas12-Jun-06 21:33 
GeneralRe: "operation must use an updatable query" error message Pin
isiran13-Jun-06 1:18
isiran13-Jun-06 1:18 
GeneralRe: "operation must use an updatable query" error message Pin
S Douglas13-Jun-06 4:31
professionalS Douglas13-Jun-06 4:31 
GeneralRe: "operation must use an updatable query" error message Pin
isiran14-Jun-06 3:11
isiran14-Jun-06 3:11 
GeneralRe: "operation must use an updatable query" error message Pin
S Douglas14-Jun-06 4:59
professionalS Douglas14-Jun-06 4:59 
GeneralRe: "operation must use an updatable query" error message Pin
isiran17-Jun-06 1:08
isiran17-Jun-06 1:08 
QuestionHow i can retrieve AutoNumber Field After Insert a new record in access Pin
morteza5711-Jun-06 1:18
morteza5711-Jun-06 1:18 
AnswerRe: How i can retrieve AutoNumber Field After Insert a new record in access Pin
morteza5723-Sep-06 23:22
morteza5723-Sep-06 23:22 
QuestionCompare two Datasets Pin
oknxsw200510-Jun-06 6:41
oknxsw200510-Jun-06 6:41 
AnswerRe: Compare two Datasets Pin
Paul Brower12-Jun-06 4:29
Paul Brower12-Jun-06 4:29 
Questionhelp me pleeeease to update the avaliable quantity column [modified] Pin
nellyvb.net10-Jun-06 4:32
nellyvb.net10-Jun-06 4:32 
AnswerRe: help me pleeeease to update the avaliable quantity column Pin
mr_1234510-Jun-06 6:18
mr_1234510-Jun-06 6:18 
QuestionStop Error Message Pin
Rakesh.Jha.011010-Jun-06 1:08
Rakesh.Jha.011010-Jun-06 1:08 
AnswerRe: Stop Error Message [modified] Pin
albCode10-Jun-06 1:27
albCode10-Jun-06 1:27 
GeneralRe: Stop Error Message Pin
Colin Angus Mackay10-Jun-06 3:52
Colin Angus Mackay10-Jun-06 3:52 

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.