all groups > sql server misc > january 2007
Design help please
Posted by Jester98x at 1/26/2007 7:19:01 AM
I hope that I can get some help with database design.
Specifically I have been working on a database which holds all company
records in single table, this is then linked to a table containing
company type indicators e.g. Client, Supplier etc.
I'm about 95% sure that we understand all the typ... more >>
Help with SQL 2005 and sourcesafe!
Posted by Nomad at 1/22/2007 9:21:34 PM
Hi,
My office are currently upgrading to SQL 2005, and as part of the upgrade
process we would like to take advantage of the source control functionality.
We already use Microsoft Visual SourceSafe 6 to store our VB programs, but
we would also like to use it to store our stored procedures and ... more >>
How to extract Hour, Minute & Second
Posted by Dale at 1/21/2007 6:45:10 AM
A table has a field containing the date and time. Example 2006-2-20
08:11:44.123...field name is DateInitiated. I can extract the month, day and
year by using Day(DateInitiated), Month(DateInitiated), Year(DateInitiated).
How would the time be extracted for hours, minutes and seconds?
Thank... more >>
Help, I Need SQL 2005 training
Posted by Clayton Sutton at 1/19/2007 8:25:06 PM
Hey everyone,
My company wants to send me to MS SQL 2005 training. Anyone know of a good
company that offers the training?
--
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
******... more >>
work problem cracking me up
Posted by Toe Dipper at 1/9/2007 11:53:58 PM
Hi all,
SQL 2000
I am cracking up in work with what appeared to be a simple task.
I have a script in work which returns a data set concerning duplicate
data. This is by design and a third party then takes the results and
goes of and decides using their head which duplicates should be del... more >>
SQL Server Refusing Connections
Posted by John Bailo at 1/5/2007 10:00:49 AM
I run several web applications servers ( Weblogic ) on Windows 2000.
These access databases on several SQL 2000/W2K servers.
Occasionally, my application servers will shut down because the database
server closes connections. On restart the service will have trouble
reacquiring connectio... more >>
|