Viewing 15 posts - 1,771 through 1,785 (of 3,221 total)
Download necessary components (Not Office itself) from:
This download will install a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access...
September 13, 2010 at 1:33 pm
First returns just the date
declare @date Char(10)
set @date = convert(char(10),getdate(),101)
SELECT @DAte
This will return the date with a time of midnight
DECLARE @midnight DATETIME
SELECT @midnight = DATEADD(dd,0,DATEDIFF(dd,0,getdate()))
SELECT @midnight
Look at this and add...
September 13, 2010 at 11:02 am
Will this suffice?
DECLARE @StafNr VARCHAR(15)
SET @StafNr = 'Unknown_201'
SELECT CAST(SUBSTRING(@StafNr,CHARINDEX('_', @StafNr,1)+1,3)AS INT) + 1
Result is 202
September 13, 2010 at 7:29 am
Paul White - tried this in Query Analyzer - yup still have SQL 2000 on an older desktop - Ran the following 3 times .. same result each time
CREATE ...
September 12, 2010 at 8:13 am
halifaxdal
I would discourage your doing what you seem to imply you need to do.
What would happen if the user of your progam input into Textbox one text such as:
DROP TABLE...
September 9, 2010 at 1:39 pm
Jeff - Allen White (MVP) is one of the leaders in setting up
SQL Sat#60 .. He is also the leader of the Ohio North Special Interest Group (SQL...
September 9, 2010 at 7:13 am
Hmm seems like we have a disagreement on moving the Resource DB.
Now which reference is Correct can it be moved or not? ? ?
http://technet.microsoft.com/en-us/library/ms345408(SQL.90).aspx
From the above reference (Bold emphasis...
September 9, 2010 at 5:42 am
Steve Jones
Red Rocks is great.
Never been there but just slightly south of Colorado Springs is the Broadmoor resort complex ..... Always liked the "Golden Bee" that english bar transported...
September 7, 2010 at 6:54 pm
Will this assist you?
CREATE TABLE #T(Something VARCHAR(20))
INSERT INTO #T
SELECT '12' UNION ALL
SELECT '.3' UNION ALL
SELECT '-' UNION ALL
SELECT ',1.0' UNION ALL
SELECT '>60' UNION ALL
SELECT '> 60' UNION ALL
SELECT '12,> 60,xyz'...
September 6, 2010 at 8:07 am
If you would post your table definitions some sample data (not anything that would divulge company confidential info), desired result from the sample data. To learn how to do...
September 5, 2010 at 4:07 pm
Steve .. is your place north or south of Denver? I used to travel to and from the old Denver (Stalpeton) airport to Pubelo failry frequently, passing that old...
September 5, 2010 at 4:01 pm
Your post appears to be somewhat confusing... if the date is only stored as a date say 09/04/2010 ... then how do we know if that entry was for the...
September 4, 2010 at 2:28 pm
IN order to receive tested help please post the tables definition, some sample data and the required results.
Refer to the first link in my signature block for simple instructions on...
September 4, 2010 at 8:54 am
Did you also install SSMS for SQL 2008?
1. Open SSMS - right click on the database name.
2. In the drop down list that appears - Select "Properties"
3....
September 4, 2010 at 8:47 am
I tested this and it did work (SQL 2005)
DECLARE @Table NVARCHAR(1000)
SET @Table =
'CREATE TABLE [dbo].[filestats](
[statskey] [int] IDENTITY(1,1) NOT NULL,
[dbname] [varchar](128) NULL,
[fName] [varchar](2048) NULL,
[timeStart] [datetime] NULL,
[readsNum1] [bigint] NULL,
[readsBytes1] [bigint] NULL,
[readsIoStall1]...
September 2, 2010 at 1:37 pm
Viewing 15 posts - 1,771 through 1,785 (of 3,221 total)