Re: Trigger with aggregate possible ?

From: obakush_at_osfi-bsif.gc.ca ((obakush_at_osfi-bsif.gc.ca))
Date: 03/30/04 

Date: Tue, 30 Mar 2004 11:19:52 -0800

Sorry, the correct syntax would be:
declare @id int
select top 1 @id=ColumnName from TableName Order By ColumnName Desc
Select @id=@id+1

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Relevant Pages

  • error of the system stored procedure MSSQL Server
    ... procdure of MSSQL Server) to use her with OleDb driver and I've got ... ,?BlankSpaceAdded int ... if (?columnname is not null) ... ?BasePos, ?AddOnLen), N'')) ...
    (microsoft.public.data.ado)
  • code of sp_helptext
    ... declare ?dbname sysname ... ,?BlankSpaceAdded int ... if (?columnname is not null) ... ?BasePos, ?AddOnLen), N'')) ...
    (microsoft.public.data.ado)
  • Re: SqlDataReader showing Empty columns until after error.
    ... with the actual data in reader. ... public static int GetInt(IDataReader reader, string columnName) ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SqlDataReader showing Empty columns until after error.
    ... at the value of the reader column. ... dealing with DBNulls which don't convert directly to .Net nulls, ... Does return (int) reader.GetInt32; handle the DBNull issue? ... string columnName) ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Order By NEWID() and Sorting by another field.
    ... INSERT #test SELECT columnName FROM tableName ORDER BY NEWID ... anotherColumnName FROM tableName WHERE columnName IN ... > i need to query a DB and select the TOP X random records and then need to ...
    (microsoft.public.sqlserver.programming)