Aussie_Here

Something like that might work: [CODE]UPDATE dembel SET userid = 8908 WHERE [Name] = 'o''reily'[/CODE] But before doing that you need to replace the name in ur db with double apostrophe using Replace: [CODE]Replace ("o'reily", " ' ", " '' ") [/CODE]

[B][COLOR="Green"]Hello, I am writing a PhD thesis and require some help numbering my figures and tables. I use Word 2003 and would like Word to restart numbering of my figures and tables after each chapter (NOTafter each section). For example, captions of figures/tables in Chapter 1 should read Figure/Table 1.1, …

[code]select id,name,no_items,count(*)[/code]

use the recursive function

Hi I've been trying to solve the following problem for a few days but everytime I get the error msg even when the entered value doesn't conflict with the statement. Plz I need an urgent help I have the following tables: [B]booking[/B] bookingId (PK) subjectId (FK) [B]Subject[/B] subjectId (PK) termId …

How to make a constraint to check if the entered time is in valid form?

I want to create a procedure which takes one input parameter(@name) and list all the fully or partially matching results. I used [code=sql]Select * from Table1 Where Name LIKE @Name[/code] but it didnt work. Can you help plz?

How can I add a check constraint to make sure that a date is equal to Today or within the last year and another check constraint to ensure that dateA is equal to dateB or earlier by a maximum of 3 days ?

I've got the following tables : Em_table Em_No nchar(3) Primary key Em_type nchar(20) , (values it can be inserted into that column are 'P', 'T' and defaults to Work_table(w_type)) . . Work_table w_No ...... w_type nchar(20) values it can be inserted into that column are 'P', 'T' ) . . …

I want to create a procedure to update a table. It takes number of input parameters(one of them is the @pID) and updates four columns which have the pID=@pID and only one of these four columns can be updated if the value of another column='F' in addition to pID=@pID. How …