تقييم الموضوع :
  • 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 وكيفية التعامل معهم...
}}}
تم الشكر بواسطة:



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


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