Viewing 10 posts - 7,621 through 7,631 (of 7,631 total)
neat.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 7, 2008 at 5:17 pm
It is indeed a sad day.
I started playing D&D in 1978, was a charter member of the RPGA and actually met Gary a couple of times.
He will be missed.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 7, 2008 at 5:11 pm
Got me. "sys.default_constraints" is a standard Catalog View in SQL Server 2005.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 7, 2008 at 4:52 pm
You should be able to fix this with CAST() or CONVERT().
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 7, 2008 at 4:49 pm
Adam Haines (3/7/2008)
You can name the constraints. You dont have to let them auto generate.
Good point. I had forgotten that.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 7, 2008 at 4:39 pm
tim del bosco (3/7/2008)
AA.CastValueAsType=...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 7, 2008 at 4:33 pm
whiz.laksh (3/7/2008)
i specify that the default date value in the column is getdate()but the system assigns it a name like "DF__SecurityM__DsegL__08C105B8"
that's why i cant find the name of it.
Try...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 7, 2008 at 3:51 pm
UPDATE tax_group_hdr
Set tax_group_id = tax_group_description
Where tax_group_id LIKE 'VA%'
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 7, 2008 at 2:32 pm
kunal (2/25/2008)
CREATE FUNCTION [dbo].[GetListOptionDetails]
(
@fListOptionID int
)
RETURNS nvarchar(255)
AS
BEGIN
RETURN (SELECT Name from ListOption where Id = @fListOptionID)
END...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 7, 2008 at 2:24 pm
View definitions support Case functions just fine.
The query designer may not, but then just don't use the query designer. (I would never use it anyway).
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 7, 2008 at 12:00 pm
Viewing 10 posts - 7,621 through 7,631 (of 7,631 total)