bitbucket (12/6/2008)

---

You might want to read this article:

http://support.microsoft.com/kb/154886

for how varchar values are stored. It also contains very simple sample code so that you can test and view the...

please forgive me,i didnt ask completely:

i have a table named Gallery

i wanna select some fields from Gallery base on a specific RowNumber

i wanna return a value that show whether this...

i need to select a record base on a RowNumber,besides i need to check and return a value that shows whethere this record is or is not the last record...

GilaMonster (11/1/2008)

---

Try this.

DECLARE @state BIT

SET @state='0'

;WITH Im AS (

SELECT Id,Name,Tag,ROW_NUMBER() OVER(ORDER BY Name DESC)AS 'RowNumber' FROM Galery ...

yes,the error is :

Incorrect syntax near the keyword 'IF'. :O(

the Table is this :

CREATE TABLE [dbo].[Galery](

[Id] [int] IDENTITY(1,1) NOT NULL,

[Name] [nchar](50) NOT NULL CONSTRAINT [DF_Galery_Name] DEFAULT (N'~/Images/Gallery/pic.gif'),

[Tag] [nvarchar](200) NULL,

...

its a windows service writing with C#

i googled and found xp_cmdshell to run my .exe with parameters.

but when i use this,SQL remain in Executing query batch .. mode!

whats wrong with this ?

DECLARE @Parameters CHAR(30)

SET @Parameters='"calc.exe"'

EXEC master...

Matt Miller (10/7/2008)

---

dr_csharp (10/7/2008)

---

thanks Jason you are right,but why we do...

thanks Jason you are right,but why we do this ?

i see...

Jeff Moden (10/7/2008)

---

dr_csharp (10/7/2008)

---

thanks jack . i do this :

CREATE TRIGGER test ON CallRecorder

FOR INSERT

AS

DECLARE @RecId INT;

DECLARE @BeginTime NVARCHAR(8);

SELECT @RecId=RecId,@BeginTime=BeginTime FROM Inserted

set @BeginTime=substring(@BeginTime,1,3);

Update CallRecorder

...

thanks jack . i do this :

CREATE TRIGGER test ON CallRecorder

FOR INSERT

AS

DECLARE @RecId INT;

DECLARE @BeginTime NVARCHAR(8);

SELECT @RecId=RecId,@BeginTime=BeginTime FROM Inserted

set @BeginTime=substring(@BeginTime,1,3);

Update CallRecorder

...

Jack Corbett (10/7/2008)

---

While this trigger would work it may not be the best way to handle the situation. First you have to define what you mean by last row...

GilaMonster (10/6/2008)

---

@@identity will get you the identity value that you just inserted. MAX(ID) will get you the last value inserted. If multiple users cn be inserting at the same time,...

which one is better :

i save @@Identity in a field when record insert in Table and i read saved id in...

consider this table :

CREATE TABLE [dbo].[Customer] (

[Id] [int] IDENTITY (1, 1) NOT NULL ,

[Code] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

[Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

[Family] [nvarchar] (70)...