منتدى فيجوال بيسك لكل العرب | منتدى المبرمجين العرب
الدرس 22- دوال sql server - نسخة قابلة للطباعة

+- منتدى فيجوال بيسك لكل العرب | منتدى المبرمجين العرب (http://vb4arb.com/vb)
+-- قسم : الأقسام التعليمية - المنتدى القديم (http://vb4arb.com/vb/forumdisplay.php?fid=90)
+--- قسم : قسم دورات المنتدى (http://vb4arb.com/vb/forumdisplay.php?fid=113)
+---- قسم : دورة البرمجة باستخدام C# (http://vb4arb.com/vb/forumdisplay.php?fid=131)
+---- الموضوع : الدرس 22- دوال sql server (/showthread.php?tid=6479)

الدرس 22- دوال sql server - RaggiTech - 18-10-12

كاتب الموضوع : 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 وكيفية التعامل معهم...