Just check if this may help you:

You can start from sysobjects and syscolumns

Get the datatype and the search value as parameters

:For each object in sysobjects where type ='U'

:for...

suresh.s (9/29/2008)

---

Hi:

I have writtern a Stored procedure in which have taken a Bigint value and insert it into another table.

while running the query i met...

1.Try with recompile option for your stored procedure.

2.Reassign all your parameters to local variables in your sp and use the local variables.

Seems this script is working fine.Can you just send across your drop table script.

select ' drop table ' + name

from dbo.SysObjects

WHERE LEFT(Name,5) = 'CustA'

AND SUBSTRING(NAME,LEN(Name)-4,3) IN ('Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

AND...

David Webb (9/29/2008)

---

Based on the errors, it looks like @sql isn't big enough to hold all the text. It looks like it should be, but what do...

use sqlcmd to run a batch file from the command prompt.

Copy all the procedures to a folder.

create a bat file for the below sqlcmd

sqlcmd -S

In your input...

This will meet your requirement

select table1.*,table2.call_ref,table3.call_time

from table1

left join

table2 on

table1.order_no = table2.order_no

left join table3

on table2.call_ref = table3.call_ref

1) I want to have data in this table(index_time) latest as 7 days (i,e,) data older than 7 days should be removed. How can i achieve this functionality....

Hope this will solve:

declare @startdate datetime

declare @enddate datetime

select @startdate = '10/17/2008'

select @enddate ='10/27/2008'

select

case

when datediff(dd,@startdate,@enddate ) < 7 then

case when DATEPART ( dw ,...

select datediff(ww,'08/01/2008','08/02/2008') +1 will not work as per your condition.For a single day it will give diff of 1 week....

Check whether this will solve it for you:

select datediff(ww,'09/01/2008','09/30/2008')

select convert(datetime,convert(varchar(12),getdate(),101),101)

select convert(datetime,convert(varchar(12),getdate(),101),101)

select convert(datetime,convert(varchar(12),getdate(),101),101)

The table contains millions of records and there are more than 30 child tables which goes to 7-8 levels.The on update cascade will be too costly and also risky to...