Hello,
im using the jobs with 3 steps. Now i have to check if the database not empty at the begin of the job. If the db empty, the job must be stop, if not empty, the next step must be execute.
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10666281.html
I have a TSQL which I am connecting to an Access database using an ODBC connection. But every time I run the program it comes up with a username and password prompt for the database. How can I stop...
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_20093113.html
We have dozens of servers here with many jobs running nightly. We are running into problems though of jobs getting too long and running into each other slowing down the next job, etc...
Is it p...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20172462.html
AccessID Desc
1 AccessType1
2 AccessType2
3 AccessType3
.
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20321875.html
I have a table (A) that contains a primary key (autonumber) plus lots of other
fields. I have other tables (B and C) that have foreign keys linking to tableA.
What I need to do is duplicate a r...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20388101.html
I'm trying determine a database's recovery model with TSQL, for scripting purposes. All I can find is a DMO property. Any ideas?
Thanks,
Garrett
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20774999.html
i need to do this:
select
substring(project_name,1,255) as "Project Name",
substring(description,1,255) as "Description"
from projtable
this doesnt work, what's the correct syntax? basi...
http://www.experts-exchange.com/Database/Sybase/Q_20868370.html
Zones:
SybaseDate Answered: 01/30/2004 Grade: B Views: 0
Hi,
I need to write some TSQL that will return to me the total number of Mondays, tuesdays, wednesdays, thursdays, fridays, saturdays and sundays in a given date period. It needs to be as effic...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20947840.html
How can I convert this MS Access query to TSQL in SQL Server 2000
SELECT [ProgramID], SUM(IIf([XCutName]='Secretary Reimb',[XCutBudget],0)) AS ['Secretary Reimb Oblig'], SUM(IIf([XCutName]='Secr...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20947907.html
TableOne
LineName ProductType ENDING_Inv_Date Qty
Crosby Line 1 AAA type 01/01/2004 50
Crosby Line 1 AAA type 02/01/2004 70
Cro...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21045364.html
