Viewing 15 posts - 17,596 through 17,610 (of 26,489 total)
Jeff Moden (1/6/2010)
Lynn Pettis (1/6/2010)
To continue, I did write a blog about it Comparing Hardcoded functions, In-Line TVF's, and Scalar Functions
Nice... I'm curious... why blog these instead of submitting them...
January 7, 2010 at 12:24 am
That is a new date/time data type introduced in SQL Server 2008.
January 6, 2010 at 4:36 pm
Based on the sample data:
insert into users values ('john','doe','test@test.com','N') -- ID 1
insert into users values ('john','doe','test@test.com','N') -- ID 2
insert into users values ('jack','doe','test@jack.com','N') -- ID 3
insert into users values ('jack','doe','test@doe.com','N')...
January 6, 2010 at 3:07 pm
Previous employer, Retail System was COBOL. When we started using SQL Server for reporting and other activities, we found it easier to complete updates on the SQL side then...
January 6, 2010 at 2:50 pm
itsmeman (1/6/2010)
Someone does a accounting review for a customer and a report is generated, there is a window when you search for...
January 6, 2010 at 2:44 pm
Jeffrey Williams-493691 (1/6/2010)
Lynn Pettis (1/6/2010)
January 6, 2010 at 2:32 pm
Now, based on the above, what should the final result look like?
A picture is worth a thousand words. Or, as I tell people at work, pretend I'm from Missouri...
January 6, 2010 at 2:04 pm
To continue, I did write a blog about it Comparing Hardcoded functions, In-Line TVF's, and Scalar Functions
January 6, 2010 at 1:56 pm
Not really sure. I just sort of stumbled on to this method of converting data. We used an scaler UDF to convert dates to a specified format for...
January 6, 2010 at 1:53 pm
I don't apply those unless I have a problem that would be corrected by a CU. Those don't go through as stringent testing as the service packs (supposedly).
January 6, 2010 at 1:45 pm
Fatal Exception Error (1/6/2010)
To the men who say women can't think as logically as men. LOL. Try to lie to a women and see who comes out on top.
Doesn't...
January 6, 2010 at 1:29 pm
I don't think it is by design. I have seen The Thread not show up in the Active Threads (recent posts) at times.
January 6, 2010 at 1:20 pm
From BOL:
Adding a constraint to an existing column:
ALTER TABLE dbo.doc_exz
ADD CONSTRAINT col_b_def
DEFAULT 50 FOR column_b ;
January 6, 2010 at 12:58 pm
katedgrt (1/6/2010)
January 6, 2010 at 12:51 pm
Viewing 15 posts - 17,596 through 17,610 (of 26,489 total)