Viewing 15 posts - 2,431 through 2,445 (of 3,221 total)
Sorry I can not be any more specific, but if you enter 'sp_getschemalock' in the search window in the upper right hand corner of this forum page you will...
September 17, 2009 at 5:18 pm
rjv_rnjn
Thank you for sharing your code. Hopefully it will assist other members of this community who have the same or a similiar problem ...
September 17, 2009 at 6:17 am
BobMcC
Be sure you and your user read this BEFORE installing SSMSE server
September 16, 2009 at 6:27 pm
BobMcC
Since Express is a free download, why not try using and find out.
From the SQL Express download site at:
http://www.microsoft.com/express/sql/default.aspx
The same advanced database engine as the other editions...
September 16, 2009 at 5:57 pm
Look in Books On Line for the function @@Rowcount
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/97a47998-81d9-4331-a244-9eb8b6fe4a56.htm
Returns the number of rows affected by the last statement
September 16, 2009 at 3:05 pm
Matt Whitfield
there are people starving in africa, people who are persecuted day in day out in too many parts of the world to even list. I think it's quite easy...
September 16, 2009 at 2:18 pm
rjv_rnjn
As I understand from the suggestion it appears that I'll have to generate dynamic code that will do a DISTINCT for each of the columns
You are correct about doing a...
September 16, 2009 at 2:07 pm
Not the most efficient method, but you may want to try this:
SELECT DISTINCT colorCode1 FROM #T1
IF @@RowCount = 1
BEGIN
SELECT id,colorCode2 FROM...
September 16, 2009 at 11:32 am
This article and the contained T-SQL statement may help you identify what T-SQL may be creating your problem.
What SQL Statements Are Currently Executing? By Ian Stirk, 2008/10/28 ...
September 15, 2009 at 4:22 pm
Zumao1
You may want to read this excellent article by Gail Shaw and alter your database backup mode and/or timing of log backups. The aricle contains a very clear explanation...
September 15, 2009 at 3:59 pm
From a previous forum post on the same question (by another individual), but my answer to that question at:http://www.sqlservercentral.com/Forums/Topic786999-149-1.aspx
I strongly suggest that you use Books On Line starting with:
Backward Compatibility...
September 13, 2009 at 6:11 pm
I strongly suggest that you use Books On Line starting with:
Backward Compatibility
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/4760732b-aa3c-4f07-96ec-ba920476dd69.htm
Reading each subject listed on that page, paying particular attention to the fact that your can not...
September 13, 2009 at 12:17 pm
The problem lies within Excel as acknowledge by Microsoft. Read this
Article ID: 244435 - Last Review: February 19, 2008 - Revision: 6.1
How to reset the last cell in...
September 11, 2009 at 12:55 pm
Look up the LIKE operator in Books On Line and pay particular attention to the use of the ESCAPE modifier.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/581fb289-29f9-412b-869c-18d33a9e93d5.htm
CREATE TABLE #Td(
ClientInfo VARCHAR(50)
)
INSERT INTO #td(ClientInfo)
SELECT 'TEST1 1, 0001' UNION...
September 10, 2009 at 12:16 pm
If you elect to use a trigger or a single procedure to insert into the 2nd table, read the following.
SQL Server 2005 Books Online (September 2007)
SCOPE_IDENTITY (Transact-SQL) ...
September 7, 2009 at 7:05 pm
Viewing 15 posts - 2,431 through 2,445 (of 3,221 total)