Viewing 15 posts - 3,181 through 3,195 (of 3,221 total)
As usual a day late and a dollar short but heck at 74 (75 in April of 2007) think I can be some what slow. To quote a preious reply "Now I...
January 14, 2007 at 12:08 pm
Suggest you look at
|
November 22, 2006 at 5:02 pm
Carlos,
Had a somewhat similiar problem as yours. In my table I defined a column as 'User_Name' with a default value of (rtrim(suser_sname())) this way I did not have to...
November 22, 2006 at 4:48 pm
This suggestion was posted previously ... but thought it might help you
Select ... FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;DATABASE=\\server3\tables\Survey_Results_(10-13-06).xls', 'Select * from SurveyResults$')
The $ after...
November 9, 2006 at 9:36 am
Use either VB 6 or VB dot net along with respective ADO components ... extremely powerful and flexible .. and as some one else has already mentioned VB express is...
November 8, 2006 at 8:56 am
From BOL
When SET ANSI_NULLS is OFF, the Equals (=) and Not Equal To [<>] comparison operators do not follow the SQL-92 standard. A SELECT statement using WHERE column_name = NULL...
November 7, 2006 at 10:24 am
Page peel - unobtrusive, not at all annoying .. if the income from the ads keeps this site up and running --continue with the ads.
I hope the advertisers are...
September 8, 2006 at 10:16 am
I currently work for a firm that describes the position as "salaried". If you do not work 40 hours during a week your paycheck will show the missing hours as...
July 12, 2006 at 4:17 pm
Your not alone in this regard. My parents always said I was "A dollar short and a day late". And on my own have learned the truth of an old German statement "Too...
July 12, 2006 at 3:44 pm
As usual I am a day late and a dollar short, but heck was a good, clear, concise tutorial on foreign keys.
Thanks for the effort you put into this ......
June 14, 2006 at 7:16 am
Finally found another procedure which might be easier to use
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
/****** Object: Stored Procedure dbo.SPWhichAccessATable Script Date: 6/10/2006 9:32:09 AM ******/
CREATE PROCEDURE Dbo.SPWhichAccessATable
@TableName VARCHAR(128)
AS
SELECT...
June 10, 2006 at 7:35 am
This is one I found a long time ago here in this forum ... but can not remember the true authors name
CREATE PROCEDURE UDP_FindWordsInaSP
@Watchword varchar(50)
AS
SELECT distinct
'type' = case...
June 10, 2006 at 6:12 am
NOT MY work, and unfortunately have forgotten who the author is. But thought I would pass it along since no one else seems to remember the SQL ... and...
September 6, 2005 at 1:28 pm
Suggest that you use BOL and look at
sp_helpconstraint 'tablename', 'nomsg'
to give you an idea of what is readily available.
July 8, 2005 at 10:36 am
Viewing 15 posts - 3,181 through 3,195 (of 3,221 total)