|
|
|
November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Convert csv to smalldate Posted by SAC at 1/31/2007 1:01:21 PM Convert text to smalldate.
I have a text field which is formatted as yyyymmdd and I'd like to convert
it to a smalldate.
For example, I need 20070116 to become a smalldate field which would display
01/16/2007
How do I do this?
Then I want to add some days to a smalldate field
For ...more >>
Redistributing Application, which uses SQL Server Express Posted by Artchil Gogava at 1/30/2007 10:52:32 PM Hello All,
I am planning to redistribute an application, which uses SQL server express.
I have registered for redistribution rights at
http://www.microsoft.com/sql/editions/express/redistregister.mspx
It looks like, it should be enough, but I just wanted to be sure that I am
not going t...more >>
Query Help Posted by Hulicat at 1/30/2007 4:15:03 PM I am trying to join these two select statements into a single result
that would look like the following:
Ticket Number, Issue, Email
meeting this criteria from table "job_ticket" WHERE
job_ticket.location_id = '5' and status_type_id like '[1-2]'
Both select statements work fine by thems...more >>
SQL Service Icon Posted by Timber at 1/30/2007 10:24:31 AM Hello,
the sql server service manager icon disappeared from the taskbar
notification area. how de we get it back? It's sometimes hard to determine
the state to of server when you don't see it. thanks
timber
...more >>
SQL Service Manager in Notification Area Posted by Timber at 1/30/2007 10:15:58 AM Hello,
Previously, I had the SQL Server Service Manager icon appearing in the
notification area of the taskbar. But I seem to have lost it. How do I put
it back? Sometimes its hard to know the status of the service - whether it
is started or stopped
thanks for the help!
...more >>
How to set data in SQL Server case sensitive, but database/table.. Posted by William Cai at 1/30/2007 2:17:01 AM Hello folks,
Is there an option in SQL Server to set all data case sensitive, but
database/table/column name case-insensitive? I know it's possible to set
column collation to a case-sensitive one when creating individual table. I'm
looking for a system wide setting so that I need not specify ...more >>
timer Posted by Ana at 1/29/2007 10:45:49 PM Hi,
How to write a one minute timer delay using SQL?
TIA
Ana
--------------------------------------------------------------------------------
Estoy utilizando la versión gratuita de SPAMfighter para usuarios privados.
Ha eliminado 2103 correos spam hasta la fecha.
Los abonados no tienen est...more >>
SQL database churn Posted by Nirman R Shetty [MSFT] at 1/29/2007 4:58:01 AM Hello,
I was doing some research on the kind of churn SQL databases typically go
through.
Can anyone here please point me to a whitepaper/study etc that describes
what would constitute high/medium/low churn for SQL DBs?
(Say in terms of daily tlog backup size, OR MB of data that churned per d...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |