SQL SEVER

[ad.hasareli]

bmp

 

[123buddy]

mokakda ban me

 

[ad.hasareli]

mokakda ban me

Aio ban me mokakda me ??????? datat akkama script karanna puluwanda ban ???????? mage sql sever 2008 r2

 

[123buddy]

puluwan machan mageth thiyenne okama thama

 

[shan_n95]

table tika inner join karala if ekakin values check karapn

if(table1.billno!=null and table2.billno=null and table3.billno!=null)

etapasse wenda one eka karala ayeth else if ekakin table 2kak !null anika null kiyala aran chek karapan.....etapasse aye ekak! null anit 2ma null kiyala check karala wenda ona eka display karahan

try ekak deela balanda

 

[ad.hasareli]

puluwan machan mageth thiyenne okama thama

machan menna db ake mdf file aka

 

[kavijana]

machan bill no eka primary key karala Left Join ekak set karala machan query eka liyapan thn wada karai

 

[ad.hasareli]

machan bill no eka primary key karala Left Join ekak set karala machan query eka liyapan thn wada karai

ane machan poddak balala dipanko...

 

[ad.hasareli]

bmp

 

[HondaMPLG]

 

[ad.hasareli]

 

[ad.hasareli]

bmp

 

[HondaMPLG]

bump...

 

[tharind007]

Mokakda ban meke wenna onii... meka C# program ekak ekka thiyena case ekakda.. naththam pure SQL da...????

 

[penguinruwan]

Machan Mata DB eke oya table 3ta Data dala ee 3 witarak tiyala MS SQL hari Access walin hari table eke file eka meekat attach karanna boho vita view dekak yay man test karala dennam. ubat

 

[kavijana]

hmm mata PM karapan ube E-mail address eka n wenna ona widiya. mama mage email eka ewannan mata ewapan oka

 

[ad.hasareli]

Machan Mata DB eke oya table 3ta Data dala ee 3 witarak tiyala MS SQL hari Access walin hari table eke file eka meekat attach karanna boho vita view dekak yay man test karala dennam. ubat

thnx machan

menna meke program aka thiye
http://www.elakiri.com/forum/showthread.php?t=1460406&page=11

meke db aka thiyenawa
http://www.elakiri.com/forum/showthread.php?t=1460406&page=12

 

[yasitha_o3]

machn table 3k nam karanna hariyatama danne na.. 2knam puluwn, ubata puluwnnm http://stackoverflow.com/
ekata log wela. eke ube problem eka daapn... pattama wada karayo tikak inne. aniwa help karai...

 

[ad.hasareli]

bmp

 

[hirashgeff]

bmp

උඹේ ප්‍රශ්නේ හරියට සිංහලෙන් දාපන්
http://www.ucsc.cmb.ac.lk/ltrl/services/feconverter/t1.html