You can't find the answers to these Questinons just like that, you need to dig into it in the MSDN or some other sites

for example you can use the below...

Nice Question : )

Yes we can not use truncate on a table which is referenced by a FOREIGN KEY constraint

The below statement is true if it is not referenced...

Nice Question : )

Yes we can not use truncate on a table which is referenced by a FOREIGN KEY constraint

The below statement is true if it is not referenced...

That means that all your data is in the wrong format

like :

2010-09-30 17:07:09.000

you need to try something like

select Convert (datetime,substring(uploadtime,9,2) + '/' + substring(uploadtime,6,2) + '/' +substring(uploadtime,1,4),103)

kirubamca09 (10/20/2010)

---

Kingston...

exact error message will help us to resoleve or help u in this

Can you post some sample data from the table, so that we can check why it is not working.

Which version of SQL does the client using

i was looking for similar solution and it is realy simple and helpfull

Thanks to greg

I guess incremental Back up was there only in oracle 🙂

The Question and the discussion is awesome.

Thanks for your explanation

Hugo Kornelis (10/11/2010)

---

Great question. Thanks, cengland.

In addition to the explanation: "Thorough testing shows this also applies to the IN statement", there is also a logical explanation.

The ANSI...

Thanks! it really helped me to understand clearly

Which Version of SQL you are uisng?

In the 2005 you can debug the Proc only with the help of Visual studio 2005 IDE

If you are using Sql server 2008 then...

Thanks to Andy, I learned something new today in SSIS.

in my package activxscript task already code contains these things and these thing are not working

DTSGlobalVariables

DtsPackageLog.WriteToString

do i need to change the entire script are any replcement for these above

Hey the answer to the Question is Wrong.