Viewing 15 posts - 1,966 through 1,980 (of 5,356 total)
See, if this helps:
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx
October 27, 2004 at 1:49 pm
Steve,
I will bloody it.
That's a good attitude, I think. I'm very combative myself when I know I'm right and when I think it yields some good results. However, if...
October 27, 2004 at 1:14 pm
A little bit vague this question, methinks.
You might want to read to read both topics in BOL and come back more concrete questions. ![]()
October 27, 2004 at 12:37 pm
Aargh, I should get used to scan my own link library more often. Here are some other.
http://www.inf.unibz.it/~franconi/teaching/2000/ct481/er-modelling/
http://www.databaseanswers.org/data_models/index.htm
FWIW
October 27, 2004 at 12:35 pm
USE Pubs
GO
DECLARE @stmt nvarchar(4000)
DECLARE @rowcount int
DECLARE @table nvarchar(255)
SET @table = 'authors'
SELECT @stmt = 'SELECT @count = COUNT(*) FROM ' + @table
EXEC sp_executesql @stmt, N' @count bigint output', @rowcount OUTPUT
IF @rowcount...
October 27, 2004 at 8:36 am
While the EXEC statement can't return a value, sp_ExecuteSQL surely can.
October 27, 2004 at 7:28 am
Well, let's say EM handles several things different than common sense would think. That's the way it is and it's by design ![]()
October 27, 2004 at 7:03 am
October 27, 2004 at 6:26 am
Hey, my post doesn't even come close in length to the ones from you I remember. ![]()
Apart from this, couldn't have said it better
October 27, 2004 at 4:35 am
To add to Antares, here's an example what can happen, when you choose to workaround this GETDATE() - UDF issue with a view, which is sometimes suggested.
http://www.insidesql.de/content/view/100/
It's in...
October 27, 2004 at 4:10 am
Steve,
if you ask a question here in the fora, you mostly likely receive quick and probably good advise from people who already have been there where you want to go....
October 27, 2004 at 3:59 am
If you are subscribed to SQL Server Mag you should have access to this interesting article by Itzik Ben-Gan:
http://www.winnetmag.com/Article/ArticleID/40621/40621.html
October 27, 2004 at 2:36 am
See if this Topic in BOL helps: "Transact-SQL Debugger window"
October 27, 2004 at 1:59 am
To answer your first question (This is taken from the only book worth reading by MS Press "Inside SQL Server 2000"):
If your clustered index was not created with the UNIQUE...
October 27, 2004 at 1:56 am
Viewing 15 posts - 1,966 through 1,980 (of 5,356 total)