Viewing 15 posts - 7,876 through 7,890 (of 14,953 total)
Add in some nullifs, and it becomes blindingly obvious where the differences are. Try this:
create table #T1 (
ID int identity primary key,
Col1 varchar(10),
Col2 varchar(10),
Col3 varchar(10));
create table #T2 (
ID int...
November 5, 2009 at 1:14 pm
I don't know an automatic way to do it, but here's a solution I've used:
select 'tbl1.' + name + ',' as col, name
from sys.columns
where object_id = 50
union all
select 'tbl2.' +...
November 5, 2009 at 1:06 pm
Steve Jones - Editor (11/5/2009)
November 5, 2009 at 12:37 pm
If you look under Create Table in Books Online, you'll find the syntax for creating a column constraint.
What you're looking for is "References <table> (<column>) on delete cascade".
Looks like this:
create...
November 5, 2009 at 12:00 pm
Then you'll need to contact the application vendor about the error message.
November 5, 2009 at 11:56 am
You can also use Except for this. Look up the details in Books Online, but it's pretty easy to use.
November 5, 2009 at 11:55 am
Try something like this:
declare @DTInt int, @DTString varchar(20);
select @DTInt = 23052008;
select @DTString = cast(@DTInt as varchar(20));
select cast(stuff(stuff(right(stuff(@DTString, 5, 0, left(@DTString, 2)), 8), 3, 0, '/'), 6, 0, '/') as datetime);
November 5, 2009 at 9:17 am
Run a DML trace on the database. Check out sp_trace_create in BOL.
November 5, 2009 at 9:13 am
You're welcome. It's usually the simplest things that cause the most confusing problems.
November 5, 2009 at 8:48 am
Can you set up the procs to dump their data into a table with an XML column, then use an Execute task to run the procs, and then the data...
November 5, 2009 at 8:47 am
That's almost certainly a custom error. Is there a trigger on the table they're inserting into?
November 5, 2009 at 8:42 am
What operating system are you running this on? Is it 64-bit? If so, you might need to get a driver for the ODBC connection. Google/Bing that.
November 5, 2009 at 8:41 am
For the most part, IT these days has all the appeal and glamor of accounting, or being a file clerk. There's very little real innovation in it, it's more...
November 5, 2009 at 8:39 am
Yes, you can modify one of the databases without affecting the others. Easiest way to do it is to go to the Options pannel in the Properties of the...
November 5, 2009 at 8:25 am
Something like this maybe?
select *
from dbo.MyTable
where len(initials)>1;
November 5, 2009 at 8:14 am
Viewing 15 posts - 7,876 through 7,890 (of 14,953 total)