Viewing 15 posts - 2,461 through 2,475 (of 3,221 total)
Setting up your data and testing I do not find a problem... Can you
explain in more detail? I am assuming (and that may be my mistake),
that SAP...
August 23, 2009 at 11:14 am
Jamie Longstreet (8/21/2009)
--------------------------------------------------------------------------------
Excellent question.
First because it demonstrates the MERGE,
Second because it illustrates the $action,
Nice one!
dave.farmer
Actually, I was going to say much the same but got a bit...
August 22, 2009 at 7:28 am
Composed before I read Steve Jones post ....
Sorry about that Steve I should have hit the refresh before hitting post.
Scott Coleman
How on earth can you...
August 21, 2009 at 9:17 am
MothInTheMachine
Just in case you run into some unexpected glitches these links might assist you in over coming those glitches:
http://technet.microsoft.com/en-us/library/cc178973.aspx
From above:
With Microsoft Office Access 2007, you can open and use...
August 19, 2009 at 11:36 am
Sankar Reddy
Note that DBCC CHECKDB is re-written by Paul Randal in SQL Server 2005 but you are referring to a BOL link for SQL Server 2000.
Sankar - take my...
August 17, 2009 at 1:46 pm
Sankar Reddy
5) It has a flag not to run against nonclustered indexes.
FROM BOL: http://msdn.microsoft.com/en-us/library/ms176064.aspx
-- Check the AdventureWorks database without nonclustered indexes.
DBCC CHECKDB (AdventureWorks, NOINDEX);
GO
So, it is true.
Repeating myself:
From Books On...
August 17, 2009 at 11:45 am
I firmly believe the author of this question did NOT perform due diligence when selecting possible answers.
The original statement
Check all that apply that are true about
In...
August 17, 2009 at 9:21 am
Prehaps this information From Books On Line, will help you:
SET ARITHABORT OFF (also effect of ANSI_WARNINGS setting)
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/828b357b-2f36-49fe-9f31-8794512c02a3.htm
When a SET statement is executed in a stored procedure, the new...
August 13, 2009 at 10:37 am
If you are NOT using Excel 2007 read the following ariticle which also has sample code.
http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/
10:09 - spelling correction
August 13, 2009 at 8:09 am
Steve as a discaimer (bold test added by poster)
"Please note that articles are the opinion of the author and are not endorsed by SQL Server Central. Readers should do...
August 12, 2009 at 3:03 pm
Eric Weinstein
dbo.GET_INI
Take it that this is a procedure developed by persons at your location, if not violating any company rule would you care the share that code?
August 11, 2009 at 5:03 pm
Read this article
http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/
Scroll down the page unitl you reach *OLE Automation it will show you what I think you need to do.
By the way the article will allow you to...
August 11, 2009 at 12:44 pm
Tried this using SSMS - SQL Server 2008
When clicking execute - a message is displayed sating that
The query cannot be represented in the Diagram and Criteria Pane.
.
However you can...
August 11, 2009 at 10:40 am
Amir
I need to write a procedure that trimming tables that are created in the database
If you mean to reduce the size of the table in the database changing from CHAR...
August 10, 2009 at 9:51 am
Use USER_NAME() or CURRENT_USER function
See BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/29248949-325b-4063-9f55-5a445fb35c6e.htm
You can capitialize the first character of any word using something like:
SELECT UPPER(SUBSTRING(LastName,1,1)) + SUBSTRING(LastName,2,LEN(LastName))
August 7, 2009 at 7:02 am
Viewing 15 posts - 2,461 through 2,475 (of 3,221 total)