Vijai (4/15/2008)

---

Thanks for reply. I tried the following but got error. Please rectify.

Create procedure df_bppr @de nvarchar(30)

As

Begin

Declare @sstr nvarchar(500)

Set @sstr = N'Alter Table tblbppr Add Constraint df_title Default...

Grant Fritchey (4/11/2008)

---

Do you mean you want a script to generate the table? I ask because sp_help does show you the information about the table that defines it.

You could...

SQLZ (4/11/2008)

---

EXEC and EXECUTE are identical - one is just shorter than the other. sp_executesql supports parameter substitution and it generates execution plans that SQL Server can more readily...

Use ALTER INDEX to perform the following maintenance tasks for a Text index:

Rename the index.

Rebuild the index using different preferences. .

Resume a failed index operation (creation/optimization). ....

Is there anyway to build a SQL Update that can test the fields during the update and not update them if they are the same, but still update fields that...

siddiq,

Let me clearly explain, when connect the database through query analyser .you are giving user name ,password and servername only, i am right? here you are not mentioning the machine...

Hi siddiq

Did you try my previous post. i hope it will help you

It is simple query , i dont think it will not work in 2005

lersner (4/4/2008)

---

I am trying to write an update query with this as the basic concept:

UPDATE Table1

SET ...

hi noh

you are right , in your second example instead of...

ramadesai108 (4/3/2008)

---

Shamsudheen,

Thank you so much for your prompt reply, I have to fix this issue urgently. Here is my stored proc

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE Procedure...

Ram,

Can you show me the stored procedure which you connecting to the db grid.

I think your stored procedure is using multiple tables.if so how and which table the db grid...

nice example

shamsudheen

hi jeff

your point is very usefull

as per my experience IN clause is usefull whene check Listed values

and EXISTS clause is...

Patrick Ige (4/1/2008)

---

i have 3 tables like so below:

table -A

pid mid

--- ----

1 7

2 29

table -B

sid pid mid

---...