Viewing 15 posts - 3,031 through 3,045 (of 3,221 total)
Take your choice of formats:
SELECT [OrderID]
,CONVERT(VARCHAR(10),[OrderDate], 101) AS 'OrderDate'
,CONVERT(VARCHAR(10),[shippedDate],121) AS 'ShippedDate'
,CONVERT(VARCHAR(11),[RequiredDate], 106)...
July 5, 2008 at 9:45 am
This might do what you are asking: It uses the current date to determine the prior Monday. When tested today (Saturday July 5th the results were:
Monday ...
July 5, 2008 at 9:01 am
Visit their web site for a free SDK (apparently uses C or C++) and you might be able to generate a CSV per Jeff's suggestion and then import from that....
July 5, 2008 at 7:37 am
From BOL
bigint
Integer (whole number) data from -2^63 (-9,223,372,036,854,775,808) through 2^63-1 (9,223,372,036,854,775,807). Storage size is 8 bytes.
July 5, 2008 at 7:26 am
To assist you in expanding BigJohn's procedure the following will give you the name of each table, the columns which are character type, perhaps you can merge these 2 to...
July 5, 2008 at 6:55 am
Extracted from your post
CreateTree sql, "xRoot"
Calls this subroutine
Public Sub CreateTree(sql As String, parentKey As String)
Dim rst As ADODB.Recordset
Dim nd As MSComctlLib.Node
...
July 4, 2008 at 11:19 am
dost.kumar your original question was:
i want change the CId IDENTITY (1,3)..
how can i alter the table..
which is what resulted following my suggestion.
Do you want your existing entries to...
July 3, 2008 at 6:20 pm
When reading this. Scroll up to the top of this page in the upper frame you will see Search: type in the word "injection" (without the quotes) and...
July 3, 2008 at 3:59 pm
Another possibility for you to check
Microsoft® SQL Server™ 2005 collects statistical information about indexes and column data stored in the database. These statistics are used by the SQL Server...
July 3, 2008 at 3:27 pm
This may seem to be a little brash on my part or my natual denseness, and hope you will pardon me for asking but have you really examined the use...
July 3, 2008 at 2:56 pm
Be carefully about advancing too far up the ladder. I know of companies (names with held for obvious reasons) that have promoted DBA's to titles like 'System Architect' in...
July 3, 2008 at 2:20 pm
This SP will find the desired text as shown in the procedure and can be used in SQL 2000 and 2005 - note it will find the watchword even if...
July 3, 2008 at 12:49 pm
In addition to:
I would recommend running the SQL Server 2005 upgrade advisor on your DB first so that you can look at depricated functionality and possible issues that you...
July 3, 2008 at 11:26 am
Viewing 15 posts - 3,031 through 3,045 (of 3,221 total)