Thread: charindex

Quote (mireles10): Once the row is deleted, DO I need to run DBCC? No, that is unnecessary.

here is what happens on startup "D:\Program Files\Easy\Shared Files\dbsrv7.exe" -ti0 -xTCPIP -tl0 -nEASY "D:\Program Files\Easy\Data\MDM.db" -nDSERV "D:\Program Files\Easy\Data\Data2\MDM.db" -ndentserv2 "D:\Program Files\EASY\Data\ast_easy.db" -nast_serv  

Hi every one, I need some help, I am using ASA 5, and i am using this script to make dynamic cursor declare cursor_a dynamic scroll cursor using @sql; in ASA 9 it work. but when i run it on ASA 5 it failed the message is "Error open cursor". Is there any difference syntax between ASA 9 and ASA5? Thank you for your help  

I have SELECT CHARINDEX('vital', @document, 5) in SQL and I want to equivalent command in Sybase can anyone help on this. If I do same thing it throws an error. Function CHARINDEX invoked with wrong number or type of argument(s). Is there equivalent start_location parameter in Sybase? thanks for any help.  

Hi All,   I created a new database and 2 tables inside but one of the tables has foreign key which can not be created as I'm getting error on the foreign key...   Can we set foreign key constarint to a table in another database?  This is what I've done:   use new_database go create table Sample(...

I am a beginner and trying to learn database specially Sybase. I am trying to copy only selective data from table into text file using BCP but I couldn't, I know simple bcp in and out but what if i want to copy records from 10000-20000 from a table which has millions of records? Any body can help me out plz. thanks in advance Micky

First of all, I want to apologize if this is a duplicate post. I believe I post the question but I could not find it. Using Sybase 12.5 on Windows Server 2003 I have 2 tables X, and Y 1. use a select statement to find out some values  from the X table.  Several values are return A B C ..n Now I write DELETE statement to delete every row DELETE from Y where columnName = A DELETE from Y where columnName = A...

I have a table with a column called members and in it the rows are like ID Members ---------- ----------- 1 1\2\3 2 2\3\4 3 2\3 4 1\5 I have a reference table where 1 = father, 2= mother, 3=sister, 4=brother, 5=grapnparents. Is there any way I can query the memebers table like this ID Members ---------- ------------------ 1 father,mother,sister 2 mother,sister, brother 3 mother,sister 4 father,grandparents. What I want to do is just replace...

Plz suggest good book ...

An example of one table in the script: drop table HTMLEXTRACT go create table HTMLEXTRACT (     "doc_id" numeric(32) identity not null,     "parent_id" numeric(32) not null,     "doc_type" varchar(10) not null,     "pid" numeric(16) not null,...