Viewing 15 posts - 1,861 through 1,875 (of 3,221 total)
Read and implement the sample code listed in the following links.
BEGIN TRANSACTION ...http://technet.microsoft.com/en-us/library/ms188929.aspx
Within the TRY block
T-SQL block...http://technet.microsoft.com/en-us/library/ms175976(SQL.90).aspx
Within the CATCH block
ROLLBACK TRANSACTION ....http://technet.microsoft.com/en-us/library/ms181299.aspx
No error
COMMIT...
July 15, 2010 at 5:14 pm
I would suggest that you read in the area of Sociology (foreign to most, if not all techies) in particular "small group theory". It will illustrate how and why...
July 15, 2010 at 8:01 am
As stated by others:
Good post. Always good to learn something new in the QOD
Thanks for a thought provoking / learning experience keep up the good work.
Sankar...
July 14, 2010 at 2:54 pm
khurramsaifi
Your code works well with a file path such as:
set @filepath = 'dir C:\dj5551\*.exe /-C '
but with a file path that contains blanks no data is returned
for example":
set @filepath...
July 13, 2010 at 6:26 pm
Use http://technet.microsoft.com/en-us/default.aspx
In the input box type: "upsizing access to sql server" it will return some 650 links to articles, scripts, blog postings that discuss this question. If you can...
July 13, 2010 at 6:09 pm
hrvoje.piasevoli
Maybe the following code example brings some light on the above statement. Note the second insert in the try block.
Try guessing the outcome
Excellent bit of code ..... Hope...
July 7, 2010 at 8:23 am
Have you looked at the sp_help_fulltext_catalogs procedure .. you could couple that with the undocumented sp_msforeachtable and that may give you some assistance
July 5, 2010 at 9:34 pm
WayneS
I've been contemplating making a presentation to the UG based on the Comparing Table Variables with Temporary Tables article that I wrote last year - do you'll think that...
July 5, 2010 at 5:44 pm
Assuming I read and properly understood your explanation.
CREATE TABLE #T(ClientOrderNumber VARCHAR(10), ItemCode VARCHAR(10),QTY INT, DWeek DATETIME,SWeek DATETIME)
INSERT INTO #T
SELECT '7808','7765',100,NULL, GETDATE() + 10 UNION ALL
SELECT NULL,'123',1000,NULL, NULL UNION ALL
SELECT NULL,'7765',100,NULL,...
July 5, 2010 at 12:49 pm
Dfalir
The order contains a variety of data to be completed, but i beleive that the most important data that is to be used for the "checking algorithmin", are the...
July 5, 2010 at 8:22 am
You may want to start by reading these articles
http://www.sqlservercentral.com/articles/Career/61243/
http://www.sqlservercentral.com/articles/DBA/67706/
http://www.sqlservercentral.com/articles/Database+Weekly/69108/
June 30, 2010 at 7:37 am
scott.pletcher
CREATE TABLE #T(Id INT,Date1 DATETIME,Date2 DATETIME)
INSERT INTO #T
SELECT 1,'2/1/2007','1/31/2010' UNION ALL
SELECT 2,'2/1/2007','2/1/2010' UNION ALL
SELECT 3, '2/1/2007','1/15/2010'
SELECT Id, Date1 AS 'Start', Date2 AS 'End', DATEDIFF(YEAR, date1, date2)
+ CASE WHEN CONVERT(CHAR(5), date1,...
June 29, 2010 at 5:12 pm
Phil Factor
This is why I like to use ASK SQL Server Central as well. Here is a medium that allows more freedom to float ideas, to comment on replies, to...
June 26, 2010 at 4:26 pm
This article explains how to use a T-SQL script in conjunction with Windows Task Scheduler to automate backups of you SQL Server Express databases on a scheduled basis.
June 23, 2010 at 11:38 am
Viewing 15 posts - 1,861 through 1,875 (of 3,221 total)