coding @ the speed of thought RSS 2.0
 Wednesday, May 23, 2007

Bırakın veritabanına kullanıcılar kendi formüllerini girsinler, uğraşılmaz bu kullanıcılarla canım...

declare
@v1        int,
        @v2        int,
        @v3        int

declare @formula    nvarchar(50)

set @v1=2
set @v2=4
set @v3=5
set @formula='SELECT (@v1+@v3)*@v2'

set @formula=replace(@formula,'@v1',convert(varchar,@v1))
set @formula=replace(@formula,'@v2',convert(varchar,@v2))
set @formula=replace(@formula,'@v3',convert(varchar,@v3))

print @formula
EXEC sp_executesql @formula

Wednesday, May 23, 2007 9:27:05 PM (GTB Standard Time, UTC+02:00)  #    Comments [0] -
Post-It | T-Sql
 Saturday, May 19, 2007

 declare CURS_X cursor read_only forward_only for 
  (
  select X1,X2 from ...
  )

 open CURS_X
 fetch next from CURS_X into @X1,@X2
 while @@FETCH_STATUS=0
  begin
   .........
   .........
   --bir sonraki kayit okunuyor   
   fetch next from CURS_X into @X1,@X2
  end
 close CURS_X
 deallocate CURS_X

bundan sonra böyle, post-it lerimi burda tutmaya karar verdim.
bu da ilki.yazarken iyi oluyor.

Saturday, May 19, 2007 3:04:30 PM (GTB Standard Time, UTC+02:00)  #    Comments [0] -
Post-It | T-Sql
Archive
<July 2008>
SunMonTueWedThuFriSat
293012345
6789101112
13141516171819
20212223242526
272829303112
3456789
About the author/Disclaimer

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2008
Levent YILDIZ
Sign In
Statistics
Total Posts: 88
This Year: 20
This Month: 4
This Week: 0
Comments: 28
Themes
Pick a theme:
All Content © 2008, Levent YILDIZ
DasBlog theme 'Business' created by Christoph De Baene (delarou)