Click here to Skip to main content
15,923,120 members
Home / Discussions / Database
   

Database

 
GeneralRe: max rows in a table of SQL 2000 Pin
Colin Angus Mackay22-Jul-06 8:59
Colin Angus Mackay22-Jul-06 8:59 
GeneralRe: max rows in a table of SQL 2000 Pin
Frank Kerrigan22-Jul-06 11:43
Frank Kerrigan22-Jul-06 11:43 
QuestionSQL INNER JOIN Query Pin
Brendan Vogt21-Jul-06 1:33
Brendan Vogt21-Jul-06 1:33 
AnswerRe: SQL INNER JOIN Query Pin
Mairaaj Khan21-Jul-06 3:22
professionalMairaaj Khan21-Jul-06 3:22 
QuestionTrasfer file via DTS Package from FTP server to SFTP server Pin
nmandaliya21-Jul-06 0:09
nmandaliya21-Jul-06 0:09 
AnswerRe: Trasfer file via DTS Package from FTP server to SFTP server [modified] Pin
mr_lasseter21-Jul-06 11:21
mr_lasseter21-Jul-06 11:21 
GeneralRe: Trasfer file via DTS Package from FTP server to SFTP server Pin
Frank Kerrigan21-Jul-06 13:04
Frank Kerrigan21-Jul-06 13:04 
QuestionUsing LIKE with variable [modified] Pin
cyber-will20-Jul-06 22:09
cyber-will20-Jul-06 22:09 
Hi,

I am trying to perform a search with a search term sent to a stored procedure. However when I use this
<br />
WHERE <br />
    Column LIKE '%@SearchQueryVariable%' <br />

it doesn't work. This doesn't work either
<br />
WHERE <br />
    Column LIKE @SearchQueryVariable <br />


Any ideas on how this is done?

-- modified at 4:23 Friday 21st July, 2006

Solved :

<br />
WHERE <br />
    Column LIKE '%' + @Search + '%'<br />

AnswerRe: Using LIKE with variable Pin
Frank Kerrigan21-Jul-06 2:22
Frank Kerrigan21-Jul-06 2:22 
QuestionConnectivity Error(Sqlserver 2005 in Operating System Windows Server 2003) Pin
Balavardhan20-Jul-06 21:57
Balavardhan20-Jul-06 21:57 
AnswerRe: Connectivity Error(Sqlserver 2005 in Operating System Windows Server 2003) Pin
Mike Dimmick21-Jul-06 0:46
Mike Dimmick21-Jul-06 0:46 
GeneralRe: Connectivity Error(Sqlserver 2005 in Operating System Windows Server 2003) Pin
Balavardhan22-Jul-06 2:52
Balavardhan22-Jul-06 2:52 
AnswerRe: Connectivity Error(Sqlserver 2005 in Operating System Windows Server 2003) [modified] Pin
Frank Kerrigan21-Jul-06 12:57
Frank Kerrigan21-Jul-06 12:57 
Questiongraph in reporting services Pin
cellardoor071620-Jul-06 21:07
cellardoor071620-Jul-06 21:07 
AnswerRe: graph in reporting services Pin
Frank Kerrigan21-Jul-06 2:26
Frank Kerrigan21-Jul-06 2:26 
QuestionScheduling a Storedprocedure to invoke automatically. [modified] Pin
Tiger45620-Jul-06 14:39
Tiger45620-Jul-06 14:39 
AnswerRe: Scheduling a Storedprocedure to invoke automatically. Pin
Frank Kerrigan21-Jul-06 2:28
Frank Kerrigan21-Jul-06 2:28 
QuestionAdding LOTS of data to a database table Pin
kscadi20-Jul-06 11:37
kscadi20-Jul-06 11:37 
AnswerRe: Adding LOTS of data to a database table Pin
Paul Conrad20-Jul-06 13:30
professionalPaul Conrad20-Jul-06 13:30 
GeneralRe: Adding LOTS of data to a database table [modified] Pin
kscadi20-Jul-06 14:23
kscadi20-Jul-06 14:23 
GeneralRe: Adding LOTS of data to a database table Pin
Paul Conrad20-Jul-06 14:35
professionalPaul Conrad20-Jul-06 14:35 
AnswerRe: Adding LOTS of data to a database table Pin
Mike Dimmick21-Jul-06 0:47
Mike Dimmick21-Jul-06 0:47 
AnswerRe: Adding LOTS of data to a database table Pin
VK-Cadec21-Jul-06 9:24
VK-Cadec21-Jul-06 9:24 
GeneralRe: Adding LOTS of data to a database table Pin
Paul Conrad21-Jul-06 11:20
professionalPaul Conrad21-Jul-06 11:20 
QuestionTable Information Pin
hamidreza_buddy20-Jul-06 6:10
hamidreza_buddy20-Jul-06 6:10 

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.