| Groups | Blog | Home |
|
January 2003 March 2003 April 2003 May 2003 June 2003 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 April 2008 August 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 a question for the soldiers on the line Posted by WebBuilder451 at 8/26/2006 9:41:01 PM As with any new weapon holding the promise of a greater edge in battle,
sql2k5’s true worth can only be measured by the seasoned veteran who has used
it under fire. To you veterans i now ask: Is the CLR feature proving it self
a better performance alternative to application level processing ...more >>
Trigger expression always evaluates to true Posted by craniumclw NO[at]SPAM yahoo.com at 8/26/2006 6:01:22 PM In the following trigger statement all I want to do is check for a vin
with the same value as the one being inserted and that the status field
on the same row does not have a value of 'NE'. If there is a vin in
the elt table with a status other than NE I want to send back an error
and rollback ...more >>
Need advice on Backup Posted by Sam at 8/26/2006 1:16:02 PM Hi,
We're running SQL Server 2005 Std. We have two mission critical databases on
this server. Because of our backup policies -- Full Recovery, the transaction
files on these databases ate up all the available space on the server. Here's
the actual space usage data on these databases:
DB1...more >>
Explicit insert for Timestamp column in Insert Trigger Posted by Joy at 8/26/2006 11:21:01 AM Hi all,
I am writing a Insert trigger but to my dismay it is not able to insert
explicitly into columns of type Timestamp.
Please let me know the work around for this.
regards,
Joy...more >>
requete sql Posted by Raben at 8/26/2006 10:42:56 AM Bonjour,
Je voudrais savoir s'il existe une fonction sql permettant d'obtenir le
pourcentage que repr=E9sente une valeur(num=E9rique) d'un champ par
rapport par rapport au total des valeurs d'une colonne.
Je m'explique: j'ai une colonne 'nbville' qui contient le nombre
d'habitant par ville.Je ...more >>
nText,Text,Image field problem for Update/Delete Trigger Posted by Joy at 8/26/2006 4:59:01 AM Hi all,
I am writing a update/delete trigger for some tables. But i am faced with a
problem for the tables that have text/ntext or Image kind of columns.
Please let me know how this could be solved.
regards,
Joy...more >>
SQL Server 2005 Standard Ed on 4 way servers Posted by andsm at 8/26/2006 2:53:01 AM I looking at results of tpc-c tests for 4 way computers. Best results for
SQL2k5 was established on 4x AMD Opteron dual core servers, with usage of SQL
Server 2005 Enterprise Edition. The question is - why Enterprise Edition, why
not Standard Edition which also support 4 CPUs and same memory? ...more >>
Comparison of text and varchar(max) Posted by andsm at 8/26/2006 2:23:01 AM I reading BOL, and try to understand when it is better to use text datatype,
and when varchar(max). From what I read, it looks like varchar(max) is close
to text field with turned on 'text in row' option. What if I want to have
only pointer to varchar(max) data in row, is it possible? Or usage...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
export stored proc from sql server to access db Posted by ads at 8/26/2006 1:05:01 AM how do i include stored procedures in sqlserver2000 in dts export to access
database?only tables and views were exported
Thanks....more >>
How to get the defined size of nvarchar column (that of CREATE TABLE)? Posted by pedestrian via SQLMonster.com at 8/26/2006 12:05:06 AM Is it possible to use SQL statement to determine the predefined
size (that was set during CREATE TABLE) of a nvarchar column?
--
Regards,
Pedestrian, Penang.
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/200608/1
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |