|
|
|
July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 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 Changing Date Format in SQL Posted by Ramin Sahafi at 11/6/2003 7:46:22 AM Anyone could give me an idea, how can I change the French
SQL server Date format to accept American Date format?
I have installed a SQL French version and need to get
query based on USA Date version and it messed up.
I want to send query in MM-DD--YYYY
but this French version send ...more >>
Latest SQL service packs Posted by jano at 11/5/2003 2:36:12 AM Does anyone know of a website/newsgroup/any way or means
of keeping informed of exactly when new service packs and
hotfixes come out for SQL Server?
Especially after the Slammer virus i try and keep our
server completely up to date, but this is difficult
because i need to search the inter...more >>
FWD: Look at critical pack for Windows Posted by MOURAGRO at 11/4/2003 12:47:36 PM Microsoft Customer
this is the latest version of security update, the
"November 2003, Cumulative Patch" update which fixes
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to he...more >>
problem displaying x/y as a percentage Posted by Brad Martin at 11/4/2003 9:17:56 AM I'm having a very frustrating time trying to display the
quotient of x / y in my SELECT statement. If the result is
> 1, it displays everything to the left of the decimal. If
the result is < 1, it displays a 0.
SELECT CAST(1/2 AS decimal(5,2)) AS MatchRate
The result of this operation i...more >>
Select date time values from a table Posted by Jawahar Rajan at 11/3/2003 9:23:01 AM All,
I have MS SQL 6.5 Database.
One of the tables is an audit table with a date time
column called time_stamp.
When I display the values for this column the data time is
shown as : e.g.
'Nov 03 2003 9:42AM'
If try and select the values for this row
as
Select * from trial_audit
where ti...more >>
Email Problem Posted by Deepa at 11/3/2003 8:20:39 AM I want to send a mail without the involvement of SMTP from
a stored procedure in sql server. Basically a specific
table will be read, records count will be extracted and
emailed to a hardcoded email address. Please tell how i
can go about it.
...more >>
Variables, scope Posted by Ken at 11/2/2003 2:29:32 PM Is there a way to create/update a connection scope
variable that I could reference from a trigger?
I have been using SUSER_SNAME() in a trigger that writes
field level audit records. Previously, I have been using
NT authentication to connect to the server, so the audit
records reflected ...more >>
SQL Server 6.5 sp_addlogin error Posted by Ron at 11/1/2003 1:16:59 PM Will having a period in a login name create a invalid
character error when adding name to database?
Example; previous login names that worked - navsea_jonesrb
name that will not work - navsea_ronald.jones...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |