Viewing 15 posts - 57,481 through 57,495 (of 59,059 total)
S'ok... I've been with SQL Server since it was 6.5 and I keep wondering when the next fault will occur ![]()
October 3, 2006 at 9:38 pm
I have got null values in the ' Practitioner_Enddate' column in my table and it is a datetime... |
October 3, 2006 at 8:52 pm
Outstanding... Thanks for the feedback, Michael. ![]()
October 3, 2006 at 8:15 pm
Then I think you need to take Serqiy's advice... he wasn't talking "Trojan Horse" as in "Virus"... he was talking about taking the easy way out with NVARCHAR(MAX) which is...
October 3, 2006 at 8:10 pm
Sounds like you did your homework... glad it worked out.
October 3, 2006 at 7:59 pm
Here's a simple one... the only problem with it is if a table name straddles an 8 k boundry... then it will miss the table name...
--Find name of...
October 3, 2006 at 7:33 am
What do you mean when you say it "timed out"? What app are you in?
October 3, 2006 at 6:12 am
Thanks Serqiy. Nope, I haven't actually lost my mind (yet). I think just about everyone except the guy who wrote that knows that creating indexes on bit columns is a...
October 3, 2006 at 6:06 am
I dunno wth he found but I kinda like the looks of the calculated column... could be sargeble that way... ![]()
October 2, 2006 at 8:49 pm
I'm a bit confused... are you trying to import the file (your comment about Bulk Insert) or are you trying to export to a text file and have the date...
October 2, 2006 at 8:43 pm
This should pass your Use Cases...
--=============================================================================
-- Setup for testing
--=============================================================================
--===== System presets
SET NOCOUNT ON
--===== If the temporary test table exists, drop it
IF OBJECT_ID('TempDB..#Customer') IS NOT...
October 2, 2006 at 8:28 pm
WTH? Why can't you use stored procedures or a UDF? Yeah, I know... "Business Requirement". WHAT is that business requirement?
October 2, 2006 at 7:55 pm
Oh yeah... one other question... are you trying the latest code with the UPDATE/INSERT where there are no SELECTs?
October 2, 2006 at 7:52 pm
I ran into something similar... if you drop and recreate a table, the views associated with that table must be recreated, as well. Are you sure you didn't recreate the...
October 2, 2006 at 7:51 pm
Cluster the IDENTITY column if you wish... the natural key you are inserting to should not be clustered for the very reason you mention.
On the ROWLOCK on the SELECT... go...
October 2, 2006 at 5:48 pm
Viewing 15 posts - 57,481 through 57,495 (of 59,059 total)