In this article you'll find methods hos to share data between procedures:

http://www.sommarskog.se/share_data.html

There are some functions, you can use. Choose appropriate one:

declare @i int

declare @f float

set @f = 3.789

set @i = cast(@f as int)

select @i

set @i = round(@f,...

manjulaatapattu (2/16/2009)

---

I have a table like this,

MachineName Varchar(50),

EntryTime DateTime

within one minutes around 500 records get inserted to this table., so I need to get

count of records inserted last min,count of...

SET @query = '

SELECT

ID

, Email

, Class

, Session

, Quantity

FROM

TEST

WHERE

Session IN (''' + @Session + ''')'

But it's good only for the actual database, isn't it? So, there is no...

You can use an undocumented stored procedure sp_msforeachdb:

EXEC sp_msforeachdb 'select * from sys.tables'

or, if you need one resulset:

select Replicate(' ', 128) DB, * into #temp from sys.tables

delete #temp

exec sp_msforeachdb...

SET @Text = 'Line 1' + Char(13) + Char(10) + 'Line 2'

Why don't you use IF Statement?

DECLARE @var INT

DECLARE @ID_MIN INT

DECLARE @ID_MAX INT

SET @var = 5

IF @var < 20

BEGIN

SET @ID_MIN = @var

SET @ID_MAX = @var

END

ELSE

BEGIN

SET...

Yes, you can.

CREATE FUNCTION [dbo].[Sign]

(

@C Char(1)

)

RETURNS int AS

BEGIN

declare @I int

IF @C = 'S'

set @I = 1

ELSE

set @I = -1

Return @I

END

Where Coalesce(CancelFlag, 0) = 0

karthikeyan (12/12/2008)

---

yes...it should work..

because it should use the ascii value..so ascii value for b is always greater than ascii value of a...so it will show the first part...

but in my...

Try this:

IF 'b' > 'a'

...

And here is one more option:

select cast(Floor(cast(Getdate() as float)) as datetime)

You can use a ROW_NUMBER function.

UPDATE T

SET [Field] = Row_num

FROM

YourTable T

INNER JOIN

(SELECT [PrimaryKey], ROW_NUMBER() OVER (ORDER BY PrimaryKey) Row_num...

1. You check the system views, whether the column exists on the table, if yes -- OK.

2. If the column does not exists you check for it in your mapping...