i dont get can you alter my query and show me

thanks in advance

Highwayman (4/15/2008)

---

isn't that the sad truth....

damn them once for creating the whole mess...

damn me for not jumping ship as soon as I realize what a steaming pile I jumped head...

SQL King (4/17/2008)

---

With Gail and Grant of course. It also depends on how you and where you are putting the [where] condition in your join. Like what Gail said, there...

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...

Vijai (4/16/2008)

---

Yes, I understand.

I just testing it. I will modify this and use it to change the default value of column by deleting the previous constraint and recreating it...

Vijai (4/16/2008)

---

I got it the below code dynamically assigns DEFAULT to any column:

Create table tbl(title nvarchar(40))

Create procedure df_bppr @de nvarchar(30)

As

Begin

Declare @sstr nvarchar(500)

If Not exists(select * from sys.objects where...

vijai

try this

Create table tbl(title nvarchar(40))

declare @sstr nvarchar(500)

set @sstr = 'alter table tbl add constraint df_little default ''' + 'yes' + ''' for title'

exec sp_executesql @sstr

hope it will...

Vijai (4/15/2008)

---

Create table tbl(title nvarchar(40))

Create procedure df_bppr @de nvarchar(30)

As

Begin

Declare @sstr nvarchar(500)

Set @sstr = N'Alter Table tbl Add Constraint df_title Default '+ @de + N' For title'

Exec...

Yes You people has good stuff, you are right. I was checking myself that is there a way which i might not known

Thanks guys

i want to create a view inside my stored procedure.if i give create view inside my stored procedure.it does not accepting

you mean all procedures in the database

if single then try this

sp_helptext 'procedure name'

Vijai (4/15/2008)

---

Create table tbl(title nvarchar(40))

Create procedure df_bppr @de nvarchar(30)

As

Begin

Declare @sstr nvarchar(500)

Set @sstr = N'Alter Table tbl Add Constraint df_title Default '+ @de + ' For title'

Exec...

seankerr (4/14/2008)

---

Hi There,

I trying to use the TSQL case statement to return a varchar value relating to a column. I'm passing in the value of int and it's telling me...

ya Grant you are providing right solution

i am using sql svr 2000 , i dont find INFORMATION_SCHEMA views

Thanks Gail Shaw

i have another question related to this topic. i am having a view of joining two table with one key and each table have multiple indexes.my question is...