Viewing 15 posts - 6,376 through 6,390 (of 7,636 total)
Jeff Moden (3/4/2008)
I don't know what I'd do for testing if NEWID() wasn't available...
Oh, I'm sure that Matt or Gus or I could whip up something in CLR. 😀
And that...
July 6, 2008 at 9:32 pm
And if you need two random values on the same row, either select the View or function twice, or change the view to have two columns, each calling NewID().
July 6, 2008 at 9:29 pm
sqluser (1/24/2008)
In CLR, if i create a Procedure with the use of an Assesbly that Procedure is being locked. After...
July 6, 2008 at 1:49 pm
Vijaya Kadiyala (7/6/2008)
HiCheck out the below link
http://support.microsoft.com/kb/q139444/
http://www.sql-server-performance.com/articles/dev/dv_delete_duplicates_p1.aspx
Thanks -- VJ
Why?
July 6, 2008 at 11:20 am
Without being to specific then, I think that you need to review this design and rethink some parts of it.
In a typical design, you should have one or more tables...
July 6, 2008 at 11:13 am
Jeff Moden (7/5/2008)
dakshinamurthy (7/5/2008)
I would also helpfull if i get to know what to do if we exceed the seed value for a bigint field in a table
If you exceed...
July 5, 2008 at 10:39 pm
So far as I know, the only reliable way is:
Select * From sys.databases Where [name] NOT IN ('master', 'tempdb', 'model', 'msdb')
July 5, 2008 at 10:04 pm
Jeff Moden (7/5/2008)
rbarryyoung (7/5/2008)
Well, off the top of my head: I always put the Operators in front (and comma is the column-list concatenation operator) because:
I agree that operators should...
July 5, 2008 at 9:30 pm
The first sentence of the 3rd page of your assignment sheet says:
The following should be an individual piece of work.
Before we go any further, I strongly recommend that you...
July 5, 2008 at 7:54 pm
Well, off the top of my head: I always put the Operators in front (and comma is the column-list concatenation operator) because:
1) in some cases, like FROM clauses it...
July 5, 2008 at 5:53 pm
While that is a personal preference of mine, I do have practical reasons for it also. 😀
July 5, 2008 at 4:47 pm
Any reason you cannot just post it here as an attachment?
That way we can see what this is before we make a commitment to you.
July 5, 2008 at 4:43 pm
OK, I've cleaned up the syntax of this so that it is much easier to read, including removing all of the "dbo."'s that were just eye clutter and changing all...
July 5, 2008 at 1:22 pm
Well my first suggestion is to stop using Query Wizard, because it makes it really easy to make really bad and ugly queries like this.
Secondly, to do anything with this,...
July 5, 2008 at 12:04 pm
Viewing 15 posts - 6,376 through 6,390 (of 7,636 total)