SQL SEVER

[ad.hasareli]

mama project aka and db aka denna karala denna puluwan katada ???? danna kenekuta nam 10 minite wedak

 

[HondaMPLG]

bump...

 

[ad.hasareli]

mama project aka and db aka denna karala denna puluwan katada ???? danna kenekuta nam 10 minite wedak

 

[prazadx]

If you need more information regarding the Sql Joins please use the following Link :

http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins

me link ekata thanks machan. very helpful
rep+

 

[HondaMPLG]

 

[ad.hasareli]

 

[amila.ela]

bumpiyooo

 

[ltty head]

ok media fire up karala methana dapan machan.. ethakota kawur hari sup ekak deyi umbata.. mata weekends wala nam puluwan wei help ekak denna.. anywz.. post it bro...

 

[ad.hasareli]

menna machan project aka

Menna table 3ma query aka




CREATE TABLE [dbo].[bill](
[Iname] [varchar](max) NULL,
[nchar](10) NULL, [Uprice] [money] NULL, [Qty] [real] NULL, [dis_4] [real] NULL, [dis_6] [real] NULL, [amt] [money] NULL, [billno] [real] NULL, [billdate] [date] NULL, [rname] [nchar](10) NULL, [cusname] [varchar](50) NULL, [tot] [real] NULL, [type] [varchar](50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Return_item]( [billno] [real] NULL, [Itmname] [varchar](50) NULL, [Itmcode] [real] NULL, [uprice] [real] NULL, [qntity] [real] NULL, [dscnt] [real] NULL, [amount] [real] NULL, [fullamount] [real] NULL, [date] [date] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[rotation]( [billno] [real] NULL, [itemname] [varchar](50) NULL, [itemcode] [real] NULL, [uprice] [real] NULL, [qntity] [real] NULL, [discnt] [real] NULL, [amount] [real] NULL, [total] [real] NULL ) ON [PRIMARY] GO [COLOR=Red] [/COLOR]

 

[ad.hasareli]

ok media fire up karala methana dapan machan.. ethakota kawur hari sup ekak deyi umbata.. mata weekends wala nam puluwan wei help ekak denna.. anywz.. post it bro...

Onna machan denma...

 

[hirashgeff]

Good mrng machanla....

Lokuma loku help akak oni wela tamai me tread aka danne SQL danne netnam plz bump akak wath dila support akak denna....


Menna mekai wenna oni,
Akama billno aken table 3ma value thiyenawa nam table 3ma value display karanna ona...akama billno aken table 2ka witarai nam valuve thiyenne a table 2 display karala anith table ake valuwe Null widihata display karanna oni (sometime akama billno aken value thiyenna puluwan 1 table akaka witak wennath puluwan ehema unoth anith table 2kema valuve Null widihata display karanna ona).... yatin mama table 3 screen short 3k attach karanawa

Ane mata onna okata SQL akak liyala dennako plz loku help akak.

sinhalen type karala dhanna

 

[ad.hasareli]

sinhalen type karala dhanna

ai machan a ? terune nedda ?

 

[ad.hasareli]

menna machan project aka

Menna table 3ma query aka




CREATE TABLE [dbo].[bill](
[Iname] [varchar](max) NULL,
[nchar](10) NULL, [Uprice] [money] NULL, [Qty] [real] NULL, [dis_4] [real] NULL, [dis_6] [real] NULL, [amt] [money] NULL, [billno] [real] NULL, [billdate] [date] NULL, [rname] [nchar](10) NULL, [cusname] [varchar](50) NULL, [tot] [real] NULL, [type] [varchar](50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Return_item]( [billno] [real] NULL, [Itmname] [varchar](50) NULL, [Itmcode] [real] NULL, [uprice] [real] NULL, [qntity] [real] NULL, [dscnt] [real] NULL, [amount] [real] NULL, [fullamount] [real] NULL, [date] [date] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[rotation]( [billno] [real] NULL, [itemname] [varchar](50) NULL, [itemcode] [real] NULL, [uprice] [real] NULL, [qntity] [real] NULL, [discnt] [real] NULL, [amount] [real] NULL, [total] [real] NULL ) ON [PRIMARY] GO [COLOR=Red][/COLOR]

 

[ad.hasareli]

bmp

 

[123buddy]

meke table wala Script ekaka danna Data th ekka .balamu

 

[ad.hasareli]

meke table wala Script ekaka danna Data th ekka .balamu

machan script aka dala thiyenne datat akka script aka ganna puluwanda machan ???????

 

[123buddy]

Right Click on Database. then cick on Task then you can see the Genarates Script ....
Click on Genarates Script ....

Ita passe wizard ekak ei eke next click karala . database eka select karala . next yaman. ethakota mewage screen ekak ei eke Script data True karapan.

Eta passe next gihin ona table tika dipan target out put ekath ekka.

 

[penguinruwan]

Ade Mage Mulma Post eka

Help ekak denna balannam Den office eke gedara gihin hode

 

[ad.hasareli]

Right Click on Database. then cick on Task then you can see the Genarates Script ....
Click on Genarates Script ....

Ita passe wizard ekak ei eke next click karala . database eka select karala . next yaman. ethakota mewage screen ekak ei eke Script data True karapan.

Eta passe next gihin ona table tika dipan target out put ekath ekka.

mage thiyenne sql sever 2008 r2 aka me wage window akak nam awe nehe ban mama script aka gatta..menna script aka

 

[ad.hasareli]

Help ekak denna balannam Den office eke gedara gihin hode

uba retada ban ofc anne ???? its joke machan.... ane ban balala dipan loku help akak