Latest ads

Ad icon
Jobreceive.com for sale
- Blogerwiki
- Updated: Today at 8:55 PM
Post Your Vehicle for Sale — FREE! - https://libro.lk
- Kalu_Puth
- Updated: Today at 7:38 PM
ඔයාගෙ Assignment හෝ Thesis එක හරියට හදාගමු
- ErMurazor
- Updated: Saturday at 10:52 PM
Ad icon
BlackWall V2ray servers
- hu KANNA
- Updated: Wednesday at 4:58 AM
Peppa Pig Family Plush Toy Set – 5 Characters
- anil1961
- Updated: Sep 19, 2026

Reply to thread

Message: <blockquote data-quote="sachithmadu" data-source="post: 20274527" data-attributes="member: 355533"><p style="text-align: center"><span style="font-size: 12px">SQL Server උදව්වක් ඕනි..</span></p> <p style="text-align: center"></p><p></p><p><span style="font-size: 12px"><span style="color: Blue">මචන් අපි SQL Server එකේ ඩේටාබේස් එකක් හදනවා කියමුකෝ queries ලියලා....</span></span></p><p><span style="font-size: 12px"><span style="color: Blue">උදාහරණයක් විදිහට මෙහෙම.. <img src="/styles/default/xenforo/smilies/default/happy.gif"  class="smilie" loading="lazy" alt=":)" title="Happy    :)" data-shortname=":)" /></span></span></p><p><span style="font-size: 12px"><span style="color: Blue"></span></span></p><p><span style="font-size: 12px"><span style="color: Blue">[PHP]</span></span></p><p><span style="font-size: 12px"><span style="color: Blue"></span></span></p><p><span style="font-size: 12px"><span style="color: Blue">CREATE DATABASE myDB;</span></span></p><p><span style="font-size: 12px"><span style="color: Blue"></span></span></p><p><span style="font-size: 12px"><span style="color: Blue">USE myDB;</span></span></p><p><span style="font-size: 12px"><span style="color: Blue"></span></span></p><p><span style="font-size: 12px"><span style="color: Blue">CREATE TABLE Student(</span></span></p><p><span style="font-size: 12px"><span style="color: Blue">First_Name VARCHAR(15) NOT NULL,</span></span></p><p><span style="font-size: 12px"><span style="color: Blue">Mid_Name CHAR,</span></span></p><p><span style="font-size: 12px"><span style="color: Blue">Last_Name VARCHAR(15) NOT NULL,</span></span></p><p><span style="font-size: 12px"><span style="color: Blue">SSN_Number CHAR(9) PRIMARY KEY NOT NULL,</span></span></p><p><span style="font-size: 12px"><span style="color: Blue">Birthday DATE,</span></span></p><p><span style="font-size: 12px"><span style="color: Blue">Address_Line VARCHAR(50),</span></span></p><p><span style="font-size: 12px"><span style="color: Blue">Sex CHAR CHECK (Sex in('M','F','m','f')),</span></span></p><p><span style="font-size: 12px"><span style="color: Blue">Salary DECIMAL(10,2) DEFAULT(800),</span></span></p><p><span style="font-size: 12px"><span style="color: Blue">Supervisor_SSN CHAR(9),</span></span></p><p><span style="font-size: 12px"><span style="color: Blue">Department_Number INT,</span></span></p><p><span style="font-size: 12px"><span style="color: Blue">FOREIGN KEY(Supervisor_SSN) REFERENCES Employee(SSN_Number) </span></span></p><p><span style="font-size: 12px"><span style="color: Blue">);</span></span></p><p><span style="font-size: 12px"><span style="color: Blue"></span></span></p><p><span style="font-size: 12px"><span style="color: Blue">[/PHP]</span></span></p><p><span style="font-size: 12px"><span style="color: Blue"></span></span></p><p><span style="font-size: 12px"><span style="color: Blue"></span><span style="color: Blue">පස්සේ ඩේටාබේස් එක සේව් වෙලා tableත් create උනාට පස්සේ...මේකේ අපි අර ගහපු queries බලන්නේ කොහොමද...SQL Server close කරලා ආපහු Open කලාට පස්සේ මම අහන්නේ...මට ඕනි මුලු ඩේටාබේස් එකේම query එක බලාග්න්ඩ..අපි ඩේටා manual data insert කලාට පස්සෙ එහෙම කෝඩ් එක බලාගන්ඩ බැරිද <img src="/styles/default/xenforo/smilies/default/sad.gif"  class="smilie" loading="lazy" alt=":(" title="Sad    :(" data-shortname=":(" /></span></span></p></blockquote><p></p>

Verification: Nawa warak dahaya keeyada? (Namaya wadi kireema dahaya)

Top Bottom