Viewing 15 posts - 2,551 through 2,565 (of 6,036 total)
MR (4/8/2009)
Can somebody explain the difference between checksum and binary_checksum and which one I should use?
Use for what?
April 8, 2009 at 10:28 pm
fazal.shaikh (4/8/2009)
But I don't want to use Identity Columns.
Why?
Are you sure you can control transactions and isolation levels better than SQL Server itself?
To avoid concurrent ID generation this UDF was...
April 8, 2009 at 10:26 pm
...
from [OperationsManager].dbo.PerformanceCounter C
where EXISTS (
select 1 from from dbo.[DATA_FEED\SCOM\Tables\required counters] R
where C.[ObjectName] = R.[ObjectName] COLLATE SQL_Latin1_General_CP1_CI_AS
...
April 7, 2009 at 12:08 am
Run your query from Excel.
Use Data -> Import External Data -> New Database Query
April 6, 2009 at 7:05 pm
Stored procedures don't have fixed schema for their resultset.
Same procedure may return different resultsets depending on its parameters, more than one recordset or no recordset at all. Some procedures may...
April 6, 2009 at 7:03 pm
steve dassin (4/6/2009)
An sql table is certainly not a variable.
Who says?
Any ground for this statement?
I thought I was being kind and considerate calling it a constant (it has...
April 6, 2009 at 4:46 am
steve dassin (4/5/2009)
getting sql folks to get their head out of what is essentially a 'constant' (an sql table) and into something that is variable.
Such a pile of c..p!
What...
April 6, 2009 at 1:40 am
It's kind of stupid to stay after hours only to make a single click.
One day they will decide to automate that click...
April 5, 2009 at 6:34 am
steve dassin (4/3/2009)
April 4, 2009 at 9:14 am
Pedro, are you gonna run that process every night personally?
If not, then who or rather what will run it?
It must be some kind of scheduled application.
Like BizTalk.
BizTalk starts second instance...
April 4, 2009 at 8:28 am
And again, I strongly suggest you not to change DB schema on fly.
You may create #table and BULK INSERT into it as well as into static table.
It's not any...
April 3, 2009 at 5:59 pm
Pedro, if you use format file for BULK INSERT you may create staging table with IDENTITY column.
Format File allows you to insert into specific columns.
Check BOL for details.
April 3, 2009 at 5:28 pm
m.wardell (4/2/2009)
April 2, 2009 at 11:17 pm
I guess what OP really needs is a comma (or other delimiter) separated list of values for some report.
If that's the case then OP needs to follow Barry's advice, normalize...
April 2, 2009 at 9:03 pm
Viewing 15 posts - 2,551 through 2,565 (of 6,036 total)