Viewing 15 posts - 49,036 through 49,050 (of 49,566 total)
Firstly, don't use select *. It's lazy coding. Get into the habit of explicitly naming the columns in your query, and only returning the columns that you need.
Second, don't use...
August 31, 2006 at 2:12 am
EXECUTE Northwind.dbo.sp_who should have worked and printed Surprise.
Actually not, it has something to do with the name resolution, but any procedure that starts sp_ is first looked for in master,...
August 30, 2006 at 1:40 am
NULLIF takes 2 parameters, returns null if the two equal each other, otherwise it returns the first.
Hence NULLIF(fld, 0) returns NULL if fld is zero, otherwise it returns fld.
August 24, 2006 at 5:05 am
The dblog virtual function produces nicer output than DBCC Log. Specifically, since it's part of a query, it's easy to filter, group, etc
SELECT
*...
August 24, 2006 at 1:34 am
Datetimes are not stored in any format in a table. They're stored in a numeric format.
If you want to display a date in a specific format, then you'll need...
August 23, 2006 at 1:42 am
I don't know about those who are presenting, but I submitted an offer to speak at the conference, which was declined. I got a mail from PASS recently, thanking me...
August 22, 2006 at 1:59 am
Why don't you try it out? You can use the RAISERROR statement to force an error, or intentionally do an update that violates a constraint on the table.
Be very...
August 22, 2006 at 1:40 am
I'd also recomend 'The Guru's guide to SQL Server Architecture and Internals' by Ken Henderson
August 21, 2006 at 12:13 am
It's messy, inefficient and I'm sure several others will have better solutions, but this does what you want. The big problem is the comma-delimited values in the commission table
August 17, 2006 at 12:17 am
or you can use the datalength function, which can be used on text fields
August 16, 2006 at 1:16 am
The SQL 2005 books online conain a lot of information for beginners. The sections on create procedure, insert statements, update statements and if - else statements will probably be of most...
August 11, 2006 at 5:35 am
Are you maybe trying to do this?
Select sum(cast(ISNULL(Hedonic_Value,0) as bigint)) as SumHedonic, sum(cast(sa_sqft as bigint)) as sa_sqft,
sa_census_tract, sa_census_block_group, count(*) as totalHomes, 'B' as HouseType
From ReplyAVM
Where isnull(sa_sqft, 0)...
August 11, 2006 at 5:31 am
I would agree on the job, but not on the cursor. From the sounds of things, the updates can be done set-based.
August 11, 2006 at 1:24 am
> 3 or 4 times faster (according to your own tests) is not significant difference for you?
As you said, is 3 ms worth the effort. If it was 3 min vs 1...
August 10, 2006 at 11:49 pm
Viewing 15 posts - 49,036 through 49,050 (of 49,566 total)