No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
Hi there here is a stupid question. I have created an update statement that updates a table that has null user id using a name as the identifier: [CODE] UPDATE dembel SET userid = 8908 WHERE [Name] = 'o'reily' [/CODE] However the the name already contains an apostrophe which causes …
|
|
|
[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, … 
|
|
|
Hy, I seek your help in solving the following problem: I have a select which returns columns like ( without count_same which I need to create by counting the same name): ID | NAME | no_items | count_same ----------------------------------------------------------- 1 | A | 1 | 2 2 | A | …
|
|
|
Hi I would like to show the data in a hierarchical manner as: bluehills > hills > south where hills comes under bluehills and south under hills in a hierarchical manner. How this is possible how can i retrieve in this manner using procedure Please help Thanks in advance MS
|
|
|
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 …
|