Viewing 15 posts - 571 through 585 (of 1,064 total)
so you might as well ship something that's 80% right and then plan on fixing it right away
I have to disagree with that notion.
If I buy some software, I want...
July 15, 2009 at 2:51 am
Peso (7/14/2009)
Also a GUID is not "globally" unique. It is guaranteed to be unique within same sql server only.
Are you sure?
This is from BOL
The uniqueidentifier data type stores 16-byte binary...
July 15, 2009 at 1:42 am
Russell.Taylor (7/7/2009)
Thanks for the reply but I am using SQL Server 2000 so does not work.
Doh!!
Sorry, ROW_NUMBER isn't supported in SQL 2000.
There is a solution using a self join (join...
July 7, 2009 at 10:05 am
Try this:-
-- 1 - Declare variables
DECLARE @CMD1 varchar(8000)
DECLARE @RestoreRootDirectory varchar(255)
DECLARE @CurrentDate datetime
DECLARE @CurrentName varchar(8)
-- 2 - Initialize variables
SET @CMD1 = ''
SET @RestoreRootDirectory = 'c:\backups\test\'
SET @CurrentDate = GETDATE()
SELECT @CurrentName =...
July 7, 2009 at 6:18 am
This will get you the top 2 for each id:-
WITH cte AS (SELECT id, quantity, ROW_NUMBER() OVER(partition by Id ORDER BY Id, quantity desc) AS 'RowNumber' from mytable)
select id,quantity from...
July 7, 2009 at 4:49 am
Rather than add a SortOrder column to the table, just include one in your query e.g.
select id, forename, case when forename = 'Kim' then 1 else 2 end as SortOrder
from...
July 7, 2009 at 1:04 am
ali.m.habib (7/6/2009)
so what if I want to run it on my D drive on my pc
You will need to refer to it using UNC notation (\\mypc\d\\alianz\output\CEMTXOUT_ALIANZ)... which means sharing your...
July 6, 2009 at 7:41 am
Is this file definately accessible by the server hosting your SQL instance.
Don't forget, "'D:\alianz\output\CEMTXOUT_ALIANZ'" is referring to the D: drive on the server, not the workstation you are connecting from.
Also,...
July 6, 2009 at 7:09 am
Having all these links in a central place is a good idea, but they are more likley to be seen by the veterans than the newbies.
The newbies seem to have...
July 6, 2009 at 6:47 am
That third party tool will not interfere with the SQL Server native backup chain. And the backup chain will not interfere with the third party tool's chain.
I beg to differ....
July 6, 2009 at 5:55 am
Do I need to include the GO statement after declaring the variable
GO isn't actually a TSQL statement... it is used by the likes of SSMS etc to signify the end...
July 3, 2009 at 8:12 am
It's 32767.
If you need anything like this, look up Maximum Capacity Specifications in BOL.
July 3, 2009 at 7:23 am
What exactly do you mean?
If you want to remove a merge replication publication, you can right-click the publication in Enterprise Manager and click "Delete"
July 3, 2009 at 7:12 am
I'm shocked and appalled some people have a total disregard for Referential Integrity.
Can't say I'm shocked... Appalled, yes.;-)
July 3, 2009 at 7:01 am
nidhisharma01 (7/3/2009)
Hope this query may help youDELETE TOP (SELECT COUNT(*)-1 FROM temp WHERE path='C:\my\' ) FROM temp
No... that will just delete the first n rows, regardless of the path.
DELETE TOP...
July 3, 2009 at 6:39 am
Viewing 15 posts - 571 through 585 (of 1,064 total)