تقييم الموضوع :
  • 0 أصوات - بمعدل 0
  • 1
  • 2
  • 3
  • 4
  • 5
الدرس 22- دوال sql server
#1
كاتب الموضوع : Tarek Aldwire


السلام عليكم ورحمة الله وبركاته...


دوال ال sql server ...

أولا قم بتجهيز ال database التي نستخدمها في الدورة دائما وهي إمسها mydatabase تحوي عامودان FirstName,Age وضع بها بعض البيانات...

1- AVG :

وتستخدم هذه الدالة لإيجاد المتوسط الحسابي لعمود ما ( رقم طبعا )...
يمكن إستخدامها كالتالي:

vb.net:


كود :
[color=#000000][COLOR=#0000bb]Dim c [/color][color=#007700]As New [/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlConnection[/color][color=#007700]([/color][color=#dd0000]"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\TD\Documents\mydatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"[/color][COLOR=#007700])
[/COLOR][color=#0000bb]Dim s [/color][color=#007700]As [/color][color=#0000bb]String [/color][color=#007700]= [/color][COLOR=#dd0000]"Select AVG(Age) From mytable"
[/COLOR][color=#0000bb]Dim cmd [/color][color=#007700]As New [/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlCommand[/color][color=#007700]([/color][color=#0000bb]s[/color][color=#007700], [/color][color=#0000bb]c[/color][COLOR=#007700])
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Open[/color][COLOR=#007700]()
[/COLOR][color=#0000bb]MsgBox[/color][color=#007700]([/color][color=#0000bb]cmd[/color][color=#007700].[/color][color=#0000bb]ExecuteScalar[/color][color=#007700]().[/color][color=#0000bb]ToString[/color][COLOR=#007700])
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Close[/color][COLOR=#007700]()  
[/COLOR][color=#0000bb][/color][/COLOR]

c#:

كود :
[COLOR=#000000][COLOR=#0000bb]
System[/COLOR][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlConnection c [/color][color=#007700]= new [/color][color=#0000bb]System[/color][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlConnection[/color][color=#007700](@[/color][color=#dd0000]"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\TD\Documents\mydatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"[/color][COLOR=#007700]);
[/COLOR][color=#0000bb]string s [/color][color=#007700]= [/color][color=#dd0000]"select AVG(Age) From mytable"[/color][COLOR=#007700];
[/COLOR][color=#0000bb]System[/color][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlCommand cmd [/color][color=#007700]= new [/color][color=#0000bb]System[/color][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlCommand[/color][color=#007700]([/color][color=#0000bb]s[/color][color=#007700], [/color][color=#0000bb]c[/color][COLOR=#007700]);
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Open[/color][COLOR=#007700]();
[/COLOR][color=#0000bb]MessageBox[/color][color=#007700].[/color][color=#0000bb]Show[/color][color=#007700]([/color][color=#0000bb]cmd[/color][color=#007700].[/color][color=#0000bb]ExecuteScalar[/color][color=#007700]().[/color][color=#0000bb]ToString[/color][COLOR=#007700]());
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Close[/color][COLOR=#007700]();  
[/COLOR][color=#0000bb][/color][/COLOR]

أو مثلا حساب المتوسط العمري لكل شخص يفوق عمره ال 15:

vb.net:


كود :
[color=#000000][COLOR=#0000bb]Dim c [/color][color=#007700]As New [/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlConnection[/color][color=#007700]([/color][color=#dd0000]"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\TD\Documents\mydatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"[/color][COLOR=#007700])
[/COLOR][color=#0000bb]Dim s [/color][color=#007700]As [/color][color=#0000bb]String [/color][color=#007700]= [/color][COLOR=#dd0000]"Select AVG(Age) From mytable where Age > 15"
[/COLOR][color=#0000bb]Dim cmd [/color][color=#007700]As New [/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlCommand[/color][color=#007700]([/color][color=#0000bb]s[/color][color=#007700], [/color][color=#0000bb]c[/color][COLOR=#007700])
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Open[/color][COLOR=#007700]()
[/COLOR][color=#0000bb]MsgBox[/color][color=#007700]([/color][color=#0000bb]cmd[/color][color=#007700].[/color][color=#0000bb]ExecuteScalar[/color][color=#007700]().[/color][color=#0000bb]ToString[/color][COLOR=#007700])
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Close[/color][COLOR=#007700]()  
[/COLOR][color=#0000bb][/color][/COLOR]

c#:


كود :
[color=#000000][COLOR=#0000bb]System[/color][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlConnection c [/color][color=#007700]= new [/color][color=#0000bb]System[/color][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlConnection[/color][color=#007700](@[/color][color=#dd0000]"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\TD\Documents\mydatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"[/color][COLOR=#007700]);
[/COLOR][color=#0000bb]string s [/color][color=#007700]= [/color][color=#dd0000]"select AVG(Age) From mytable where Age > 15"[/color][COLOR=#007700];
[/COLOR][color=#0000bb]System[/color][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlCommand cmd [/color][color=#007700]= new [/color][color=#0000bb]System[/color][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlCommand[/color][color=#007700]([/color][color=#0000bb]s[/color][color=#007700], [/color][color=#0000bb]c[/color][COLOR=#007700]);
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Open[/color][COLOR=#007700]();
[/COLOR][color=#0000bb]MessageBox[/color][color=#007700].[/color][color=#0000bb]Show[/color][color=#007700]([/color][color=#0000bb]cmd[/color][color=#007700].[/color][color=#0000bb]ExecuteScalar[/color][color=#007700]().[/color][color=#0000bb]ToString[/color][COLOR=#007700]());
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Close[/color][COLOR=#007700]();  
[/COLOR][color=#0000bb][/color][/COLOR]


2- الدالة Count ...

تعود هذه الدالة بكم عدد الأعمار الموجودة داخل الجدول بشرط أو بدون شرط...

يتم إستخدامها كالتالي...

vb.net:

كود :
[COLOR=#000000][COLOR=#0000bb]
Dim c [/COLOR][color=#007700]As New [/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlConnection[/color][color=#007700]([/color][color=#dd0000]"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\TD\Documents\mydatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"[/color][COLOR=#007700])
[/COLOR][color=#0000bb]Dim s [/color][color=#007700]As [/color][color=#0000bb]String [/color][color=#007700]= [/color][COLOR=#dd0000]"Select Count(Age) From mytable"
[/COLOR][color=#0000bb]Dim cmd [/color][color=#007700]As New [/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlCommand[/color][color=#007700]([/color][color=#0000bb]s[/color][color=#007700], [/color][color=#0000bb]c[/color][COLOR=#007700])
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Open[/color][COLOR=#007700]()
[/COLOR][color=#0000bb]MsgBox[/color][color=#007700]([/color][color=#0000bb]cmd[/color][color=#007700].[/color][color=#0000bb]ExecuteScalar[/color][color=#007700]().[/color][color=#0000bb]ToString[/color][COLOR=#007700])
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Close[/color][COLOR=#007700]()  
[/COLOR][color=#0000bb][/color][/COLOR]


c#:



كود :
[color=#000000][COLOR=#0000bb]System[/color][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlConnection c [/color][color=#007700]= new [/color][color=#0000bb]System[/color][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlConnection[/color][color=#007700](@[/color][color=#dd0000]"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\TD\Documents\mydatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"[/color][COLOR=#007700]);
[/COLOR][color=#0000bb]string s [/color][color=#007700]= [/color][color=#dd0000]"Select Count(Age) From mytable"[/color][COLOR=#007700];
[/COLOR][color=#0000bb]System[/color][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlCommand cmd [/color][color=#007700]= new [/color][color=#0000bb]System[/color][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlCommand[/color][color=#007700]([/color][color=#0000bb]s[/color][color=#007700], [/color][color=#0000bb]c[/color][COLOR=#007700]);
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Open[/color][COLOR=#007700]();
[/COLOR][color=#0000bb]MessageBox[/color][color=#007700].[/color][color=#0000bb]Show[/color][color=#007700]([/color][color=#0000bb]cmd[/color][color=#007700].[/color][color=#0000bb]ExecuteScalar[/color][color=#007700]().[/color][color=#0000bb]ToString[/color][COLOR=#007700]());
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Close[/color][COLOR=#007700]();  
[/COLOR][color=#0000bb][/color][/COLOR]

3- الدالة sum ...

تعيد هذه الدالة مجموع العمود المسندة إليه مثلا مجموع الAge ( أيضا يمكن إستخدامها بشرط مثل where Age > 15 ) ...

vb.net :


كود :
[color=#000000][COLOR=#0000bb]Dim c [/color][color=#007700]As New [/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlConnection[/color][color=#007700]([/color][color=#dd0000]"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\TD\Documents\mydatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"[/color][COLOR=#007700])
[/COLOR][color=#0000bb]Dim s [/color][color=#007700]As [/color][color=#0000bb]String [/color][color=#007700]= [/color][COLOR=#dd0000]"Select sum(Age) From mytable"
[/COLOR][color=#0000bb]Dim cmd [/color][color=#007700]As New [/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlCommand[/color][color=#007700]([/color][color=#0000bb]s[/color][color=#007700], [/color][color=#0000bb]c[/color][COLOR=#007700])
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Open[/color][COLOR=#007700]()
[/COLOR][color=#0000bb]MsgBox[/color][color=#007700]([/color][color=#0000bb]cmd[/color][color=#007700].[/color][color=#0000bb]ExecuteScalar[/color][color=#007700]().[/color][color=#0000bb]ToString[/color][COLOR=#007700])
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Close[/color][COLOR=#007700]()  
[/COLOR][color=#0000bb][/color][/COLOR]

c#:

كود :
[COLOR=#000000][COLOR=#0000bb]
System[/COLOR][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlConnection c [/color][color=#007700]= new [/color][color=#0000bb]System[/color][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlConnection[/color][color=#007700](@[/color][color=#dd0000]"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\TD\Documents\mydatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"[/color][COLOR=#007700]);
[/COLOR][color=#0000bb]string s [/color][color=#007700]= [/color][color=#dd0000]"Select sum(Age) From mytable"[/color][COLOR=#007700];
[/COLOR][color=#0000bb]System[/color][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlCommand cmd [/color][color=#007700]= new [/color][color=#0000bb]System[/color][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlCommand[/color][color=#007700]([/color][color=#0000bb]s[/color][color=#007700], [/color][color=#0000bb]c[/color][COLOR=#007700]);
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Open[/color][COLOR=#007700]();
[/COLOR][color=#0000bb]MessageBox[/color][color=#007700].[/color][color=#0000bb]Show[/color][color=#007700]([/color][color=#0000bb]cmd[/color][color=#007700].[/color][color=#0000bb]ExecuteScalar[/color][color=#007700]().[/color][color=#0000bb]ToString[/color][COLOR=#007700]());
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Close[/color][COLOR=#007700]();  
[/COLOR][color=#0000bb][/color][/COLOR]


الدالة Max ...
تعود هذه الدالة بأكبر قيمة موجودة بالعامود المسندة له ...
مثلا هنا سوف تعود بعمر اكبر شخص موجود...

vb.net:


كود :
[color=#000000][COLOR=#0000bb]Dim c [/color][color=#007700]As New [/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlConnection[/color][color=#007700]([/color][color=#dd0000]"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\TD\Documents\mydatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"[/color][COLOR=#007700])
[/COLOR][color=#0000bb]Dim s [/color][color=#007700]As [/color][color=#0000bb]String [/color][color=#007700]= [/color][COLOR=#dd0000]"Select max(Age) From mytable"
[/COLOR][color=#0000bb]Dim cmd [/color][color=#007700]As New [/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlCommand[/color][color=#007700]([/color][color=#0000bb]s[/color][color=#007700], [/color][color=#0000bb]c[/color][COLOR=#007700])
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Open[/color][COLOR=#007700]()
[/COLOR][color=#0000bb]MsgBox[/color][color=#007700]([/color][color=#0000bb]cmd[/color][color=#007700].[/color][color=#0000bb]ExecuteScalar[/color][color=#007700]().[/color][color=#0000bb]ToString[/color][COLOR=#007700])
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Close[/color][COLOR=#007700]()  
[/COLOR][color=#0000bb][/color][/COLOR]

[SIZE=2]c#:

[/SIZE]
كود :
[color=#000000][COLOR=#0000bb]System[/color][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlConnection c [/color][color=#007700]= new [/color][color=#0000bb]System[/color][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlConnection[/color][color=#007700](@[/color][color=#dd0000]"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\TD\Documents\mydatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"[/color][COLOR=#007700]);
[/COLOR][color=#0000bb]string s [/color][color=#007700]= [/color][color=#dd0000]"Select max(Age) From mytable"[/color][COLOR=#007700];
[/COLOR][color=#0000bb]System[/color][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlCommand cmd [/color][color=#007700]= new [/color][color=#0000bb]System[/color][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlCommand[/color][color=#007700]([/color][color=#0000bb]s[/color][color=#007700], [/color][color=#0000bb]c[/color][COLOR=#007700]);
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Open[/color][COLOR=#007700]();
[/COLOR][color=#0000bb]MessageBox[/color][color=#007700].[/color][color=#0000bb]Show[/color][color=#007700]([/color][color=#0000bb]cmd[/color][color=#007700].[/color][color=#0000bb]ExecuteScalar[/color][color=#007700]().[/color][color=#0000bb]ToString[/color][COLOR=#007700]());
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Close[/color][COLOR=#007700]();  
[/COLOR][color=#0000bb][/color][/COLOR]

الدالة Min ...

وهي عكس الدالة Max حيث تعيد أصغر قيمة في العامود المسندة له ...
هنا سوف تعيد أصغر عمر في العامود Age...

vb.net:

كود :
[COLOR=#000000][COLOR=#0000bb]
Dim c [/COLOR][color=#007700]As New [/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlConnection[/color][color=#007700]([/color][color=#dd0000]"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\TD\Documents\mydatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"[/color][COLOR=#007700])
[/COLOR][color=#0000bb]Dim s [/color][color=#007700]As [/color][color=#0000bb]String [/color][color=#007700]= [/color][COLOR=#dd0000]"Select min(Age) From mytable"
[/COLOR][color=#0000bb]Dim cmd [/color][color=#007700]As New [/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlCommand[/color][color=#007700]([/color][color=#0000bb]s[/color][color=#007700], [/color][color=#0000bb]c[/color][COLOR=#007700])
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Open[/color][COLOR=#007700]()
[/COLOR][color=#0000bb]MsgBox[/color][color=#007700]([/color][color=#0000bb]cmd[/color][color=#007700].[/color][color=#0000bb]ExecuteScalar[/color][color=#007700]().[/color][color=#0000bb]ToString[/color][COLOR=#007700])
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Close[/color][COLOR=#007700]()  
[/COLOR][color=#0000bb][/color][/COLOR]

c#:


كود :
[color=#000000][COLOR=#0000bb]System[/color][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlConnection c [/color][color=#007700]= new [/color][color=#0000bb]System[/color][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlConnection[/color][color=#007700](@[/color][color=#dd0000]"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\TD\Documents\mydatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"[/color][COLOR=#007700]);
[/COLOR][color=#0000bb]string s [/color][color=#007700]= [/color][color=#dd0000]"Select min(Age) From mytable"[/color][COLOR=#007700];
[/COLOR][color=#0000bb]System[/color][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlCommand cmd [/color][color=#007700]= new [/color][color=#0000bb]System[/color][color=#007700].[/color][color=#0000bb]Data[/color][color=#007700].[/color][color=#0000bb]SqlClient[/color][color=#007700].[/color][color=#0000bb]SqlCommand[/color][color=#007700]([/color][color=#0000bb]s[/color][color=#007700], [/color][color=#0000bb]c[/color][COLOR=#007700]);
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Open[/color][COLOR=#007700]();
[/COLOR][color=#0000bb]MessageBox[/color][color=#007700].[/color][color=#0000bb]Show[/color][color=#007700]([/color][color=#0000bb]cmd[/color][color=#007700].[/color][color=#0000bb]ExecuteScalar[/color][color=#007700]().[/color][color=#0000bb]ToString[/color][COLOR=#007700]());
[/COLOR][color=#0000bb]c[/color][color=#007700].[/color][color=#0000bb]Close[/color][COLOR=#007700]();  
[/COLOR][color=#0000bb][/color][/COLOR]



هكذا نكون قد تعرفنا على بعض دوال ال sql server وكيفية التعامل معهم...
}}}}
تم الشكر بواسطة:


المواضيع المحتمل أن تكون متشابهة .
الموضوع : الكاتب الردود : المشاهدات : آخر رد
  الدرس 21- Stored Procedures RaggiTech 0 923 18-10-12, 04:09 PM
آخر رد: RaggiTech
  الدرس 20- تنفيذ جمل الإستعلام insert-update-delete RaggiTech 2 964 18-10-12, 04:08 PM
آخر رد: RaggiTech
  الدرس 19- ربط قاعدة بيانات accessمع c#-vb.net وتنفيذ جمل إستعلام - الوضع المتصل RaggiTech 0 1,316 18-10-12, 03:41 PM
آخر رد: RaggiTech
  الدرس 18- ربط قاعدة بيانات sql مع c#-vb.net وتنفيذ جمل إستعلام - الوضع المتصل RaggiTech 0 2,466 18-10-12, 03:29 PM
آخر رد: RaggiTech
  الدرس 17- مقدمة إلى قواعد البيانات RaggiTech 0 732 18-10-12, 03:21 PM
آخر رد: RaggiTech
  الدرس 16- تصميم الأدوات الخاصة RaggiTech 0 700 18-10-12, 03:20 PM
آخر رد: RaggiTech
  الدرس 15- البداية مع gdi+ RaggiTech 1 751 18-10-12, 03:16 PM
آخر رد: RaggiTech
  الدرس 14- شرح تقنية ال wpf مع بعض الأمثلة RaggiTech 4 1,097 18-10-12, 03:12 PM
آخر رد: RaggiTech
  الدرس 13- Multi-Threading RaggiTech 0 770 18-10-12, 03:03 PM
آخر رد: RaggiTech
  الدرس 12- شرح تقنية WCF والتخصص بال Sockets مع مثال RaggiTech 0 2,428 18-10-12, 02:57 PM
آخر رد: RaggiTech

التنقل السريع :


يقوم بقرائة الموضوع: بالاضافة الى ( 1 ) ضيف كريم