Viewing 15 posts - 10,546 through 10,560 (of 26,489 total)
Looking at SQLCMD help I found this:
Editing Commands
[:] ED
Starts the text editor. This editor can be used to edit the current Transact-SQL batch, or the last executed batch. To edit...
July 23, 2012 at 10:59 am
Scott D. Jacobson (7/23/2012)
Not a direct answer but a similar discussion was had here: http://www.sqlservercentral.com/Forums/Topic1262979-146-1.aspx
Really helpful if you use the [ url ]/[ /url ] IFCode shortcuts (no spaces inside...
July 23, 2012 at 10:54 am
espanolanthony (7/23/2012)
That's what i am asking. I don't know the script. If you have any please share...
Use Google, you are looking for a delete command.
July 23, 2012 at 10:50 am
Djcarpen11 (7/23/2012)
CREATE NONCLUSTERED INDEX [Ixn_Mytable_F]
ON [dbo].[MyTable] ([ColA])
INCLUDE ([ColB],[ColC],[ColD])
where ColA = 122
If I run the below code against it, I'd have thought...
July 23, 2012 at 10:47 am
Each developer needs to have a licensed copy of the developer edition. Also, you do realize that if the developers have to RDp to the server, you most likely...
July 23, 2012 at 10:38 am
SSCNewbee (7/23/2012)
scheduleddatetime requesteddatetime inspecteddatetime
2012-07-23 07:30:00.0002012-07-23 09:27:00.0002012-07-23 09:27:26.533
2012-07-23...
July 23, 2012 at 10:31 am
littlelisa1111 (7/23/2012)
select o.Id, o.AccountId, o.Name, o.StageName,o.[type], o.Account__c,o.SalesPerson__c, c.InvoiceDate__c,c.Sales_Person__cfrom customers.dbo.opportunity as o inner join
customers.dbo.orderheader__c as c on c.AccountId__c = o.AccountId
Where o.SalesPerson__c = '' and o.[Type] = 'Integration Renewal' and o.StageName NOT...
July 23, 2012 at 10:24 am
Then I have already told you what you need to do, create a job step to delete the backup file.
July 23, 2012 at 10:20 am
Adelphi (7/23/2012)
I have a table that holds the following data:
ProjectsCustomersUpdatedByNewValueUpdatedOn
Project 1Customer AUser 1£1,142.0005/01/2012 10:27
Project 1Customer AUser 1£1,839.0005/01/2012 10:59
Porject 2Customer BUser 5£121,995.0024/05/2012 09:26
Project 3Customer CUser 3£20,332.0026/06/2012 09:57
Project 4Customer DUser 2£18,191.0014/05/2012...
July 23, 2012 at 10:12 am
SSCNewbee (7/23/2012)
Lynn,what should i look for in the data as all the dates are in a valid date format.
Thanks
I can't tell you that, I don't know your system nor what...
July 23, 2012 at 10:10 am
sivag,
I don't think you understand. We can't give you the code to move data from one table to five tables without knowing the how the data maps between the...
July 23, 2012 at 10:03 am
espanolanthony (7/23/2012)
Step 1 : Server A takes database to a network location. (Let's say Server C //test-dql_1\backups\Prod.bak)
Step 2 : The...
July 23, 2012 at 9:38 am
SSCNewbee (7/23/2012)
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- ===================================================================================
-- -- Description:Given a unique inspection number, this function returns an integer
-- ...
July 23, 2012 at 9:36 am
espanolanthony (7/23/2012)
July 23, 2012 at 9:16 am
SSCNewbee (7/23/2012)
July 23, 2012 at 9:08 am
Viewing 15 posts - 10,546 through 10,560 (of 26,489 total)