Foreign Key in Table Declaration<\/strong><\/p>\n\n\nCREATE TABLE ORDERS (\n ID integer primary key, \n Order_Date datetime, \n Customer_ID integer references CUSTOMER(ID), \n Amount double\n); \n\nALTER TABLE ORDERS ADD FOREIGN KEY (customer_id) REFERENCES CUSTOMER(ID);\n\n<\/pre>\nStored Procedure Example<\/strong><\/p>\n\n CREATE PROCEDURE [dbo].[procedure_name]\n @param1 VARCHAR(100)\n ,@param2 VARCHAR(200) OUTPUT\n AS\n BEGIN\n DECLARE @param3 VARCHAR(100)\n SET @param3 = ' '\n IF @param1 IS NOT NULL AND LEN(@param1) > 1\n SELECT @param2 = 'The ' + @param1 + @param3\n ELSE \n SELECT @param2 = '...is cool!'\n RETURN\n \n END\n GO\n<\/pre>\nC# and Prepared Statements<\/strong><\/p>\n \n int id = 20;\n string desc = \"....\" ;\n SqlConnection rConn = new SqlConnection(\"Persist Security Info=False;Integrated Security=SSPI;\n database=northwind;server=mySQLServer\");\n rConn.Open();\n SqlCommand command = new SqlCommand(null, rConn);\n\n \/\/ Create and prepare an SQL statement.\n command.CommandText = \"insert into Region (ID, Description) values (@id, @desc)\" ;\n command.Parameters.Add ( \"@id\", id) ;\n command.Parameters.Add ( \"@desc\", desc) ;\n command.Prepare() ; \/\/ Calling Prepare after having set the Commandtext and parameters.\n command.ExecuteNonQuery();\n\n \/\/ Change parameter values and call ExecuteNonQuery.\n command.Parameters[0].Value = 21;\n command.Parameters[1].Value = \"mySecondRegion\";\n command.ExecuteNonQuery();\n<\/pre>\n\n conn = new SqlConnection(strConnectionString);\n SqlCommand cmd = new SqlCommand();\n cmd.CommandText =\"insert into Profile values(@Name,@Age)\";\n cmd.Connection = conn;\n cmd.CommandType = CommandType.Text;\n\n SqlParameter nameP = new SqlParameter();\n nameP.SqlDbType =SqlDbType.NVarChar;\n nameP.ParameterName = \"@Name\";\n nameP.Size = 50;\n nameP.Value = model.Name;\n\n SqlParameter ageP = new SqlParameter();\n ageP.SqlDbType =SqlDbType.Int;\n ageP.ParameterName = \"@Age\";\n ageP.Value = model.Age;\n\n cmd.Parameters.Add(nameP);\n cmd.Parameters.Add(ageP);\n\n conn.Open();\n cmd.Prepare(); \n\n cmd.ExecuteNonQuery();\n\n<\/pre>\nC# and Stored Procedure<\/strong><\/p>\n\n conn = new SqlConnection(\"Server=(local);DataBase=Northwind;Integrated Security=SSPI\");\n conn.Open();\n\n SqlCommand cmd = new SqlCommand(\"sp_name\", conn);\n\n cmd.CommandType = CommandType.StoredProcedure;\n cmd.Parameters.Add(new SqlParameter(\"@CustomerID\", custId));\n\n \/\/ execute the command\n rdr = cmd.ExecuteReader();\n\n \/\/ iterate through results, printing each to console\n while (rdr.Read())\n {\n Console.WriteLine(\"\" + rdr[\"Total\"] );\n }\n\n<\/pre>\nFrom: http:\/\/sitestree.com\/?p=3724
Categories:.Net Web Applications
Tags:
Post Data:2016-07-16 11:01:19<\/p>\n
Shop Online: <a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\">https:\/\/www.ShopForSoul.com\/<\/a>\n (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"> http:\/\/Training.SitesTree.com<\/a> \n In Bengali: <a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\">http:\/\/Bangla.SaLearningSchool.com<\/a>\n <a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\">http:\/\/SitesTree.com<\/a>\n 8112223 Canada Inc.\/JustEtc: <a href='http:\/\/JustEtc.net' target='new' rel=\"noopener\">http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) <\/a>\n Shop Online: <a href='https:\/\/www.ShopForSoul.com'> https:\/\/www.ShopForSoul.com\/<\/a>\n Medium: <a href='https:\/\/medium.com\/@SayedAhmedCanada' target='new' rel=\"noopener\"> https:\/\/medium.com\/@SayedAhmedCanada <\/a>\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"Brought from: http:\/\/salearningschool.com\/displayArticle.php?table=Articles&articleID=1321&title=Random%20C#%20and%20MS%20SQl%20Server Foreign Key in Table Declaration CREATE TABLE ORDERS ( ID integer primary key, Order_Date datetime, Customer_ID integer references CUSTOMER(ID), Amount double ); ALTER TABLE ORDERS ADD FOREIGN KEY (customer_id) REFERENCES CUSTOMER(ID); Stored Procedure Example CREATE PROCEDURE [dbo].[procedure_name] @param1 VARCHAR(100) ,@param2 VARCHAR(200) OUTPUT AS BEGIN DECLARE @param3 VARCHAR(100) SET @param3 = ‘ ‘ … <\/p>\n
Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[1973,1917],"tags":[],"class_list":["post-70287","post","type-post","status-publish","format-standard","hentry","category-c-misc","category-fromsitestree-com","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":69886,"url":"http:\/\/bangla.sitestree.com\/?p=69886","url_meta":{"origin":70287,"position":0},"title":"Random C# and MS SQl Server #19","author":"Author-Check- Article-or-Video","date":"August 21, 2021","format":false,"excerpt":"Foreign Key in Table Declaration CREATE TABLE ORDERS ( ID integer primary key, Order_Date datetime, Customer_ID integer references CUSTOMER(ID), Amount double); ALTER TABLE ORDERS ADD FOREIGN KEY (customer_id) REFERENCES CUSTOMER(ID); Stored Procedure Example CREATE PROCEDURE [dbo].[procedure_name] @param1 VARCHAR(100) ,@param2 VARCHAR(200) OUTPUT AS BEGIN DECLARE @param3 VARCHAR(100) SET @param3 = '\u2026","rel":"","context":"In "C# - Misc"","block_context":{"text":"C# - Misc","link":"http:\/\/bangla.sitestree.com\/?cat=1973"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10162,"url":"http:\/\/bangla.sitestree.com\/?p=10162","url_meta":{"origin":70287,"position":1},"title":"ThreeParams.java Servlet that reads and displays three request (form) parameters. Uses the ServletUtilities class.","author":"","date":"August 16, 2015","format":false,"excerpt":"ThreeParams.java\u00a0 Servlet that reads and displays three request (form) parameters. Uses the ServletUtilities\u00a0 class. package cwp; import java.io.*; import javax.servlet.*; import javax.servlet.http.*; \/** Simple servlet that reads three parameters from the \u00a0*\u00a0 form data. \u00a0* \u00a0 \u00a0*\u00a0 Taken from Core Web Programming Java 2 Edition \u00a0*\u00a0 from Prentice Hall and\u2026","rel":"","context":"In "Code . Programming Samples . \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae \u0989\u09a6\u09be\u09b9\u09b0\u09a8"","block_context":{"text":"Code . Programming Samples . \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae \u0989\u09a6\u09be\u09b9\u09b0\u09a8","link":"http:\/\/bangla.sitestree.com\/?cat=1417"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":26527,"url":"http:\/\/bangla.sitestree.com\/?p=26527","url_meta":{"origin":70287,"position":2},"title":"ThreeParams.java Servlet that reads and displays three request (form) parameters. Uses the ServletUtilities class. #Programming Code Examples #Java\/J2EE\/J2ME #Servlet","author":"Author-Check- Article-or-Video","date":"April 27, 2021","format":false,"excerpt":"ThreeParams.java Servlet that reads and displays three request (form) parameters. Uses the ServletUtilities class. package cwp; import java.io.*; import javax.servlet.*; import javax.servlet.http.*; \/** Simple servlet that reads three parameters from the * form data. * * Taken from Core Web Programming Java 2 Edition * from Prentice Hall and Sun\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":74657,"url":"http:\/\/bangla.sitestree.com\/?p=74657","url_meta":{"origin":70287,"position":3},"title":"Python and MySQL Operations. Code Examples","author":"Sayed","date":"May 17, 2022","format":false,"excerpt":"#!\/usr\/bin\/env python# coding: utf-8# In[1]: import mysql.connector # In[2]: # create a database connection # In[3]: import mysql.connectormydb = mysql.connector.connect(\u00a0 host=\"localhost\",\u00a0 user=\"root\",\u00a0 password=\"\")print(mydb) # In[4]: import mysql.connectormydb = mysql.connector.connect(\u00a0 host=\"localhost\",\u00a0 user=\"root\",\u00a0 password=\"\")mycursor = mydb.cursor()mycursor.execute(\"drop DATABASE mydatabase\");mycursor.execute(\"CREATE DATABASE mydatabase\"); # In[5]: # check if database exists # In[6]: import mysql.connectormydb =\u2026","rel":"","context":"In "Python"","block_context":{"text":"Python","link":"http:\/\/bangla.sitestree.com\/?cat=1428"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5888,"url":"http:\/\/bangla.sitestree.com\/?p=5888","url_meta":{"origin":70287,"position":4},"title":"SQL Update Statement","author":"Author-Check- Article-or-Video","date":"January 31, 2015","format":false,"excerpt":"\u09a8\u09be\u09ae-\u09b6\u09b0\u09bf\u09ab\u09c1\u09b2 \u0987\u09b8\u09b2\u09be\u09ae PHP Coder \u09ac\u09bf\u09b7\u09df- SQL Update Statement SQL Update statement \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09b9\u09df \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u098f\u09b0 \u09ad\u09bf\u09a4\u09b0\u09c7 \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u09a1\u09be\u099f\u09be \u0995\u09c7 \u09aa\u09b0\u09bf\u09ac\u09b0\u09a4\u09a8 \u0995\u09b0\u09be\u09b0 \u099c\u09a8\u09cd\u09af\u0964 \u098f\u0987 statement \u098f\u09b0 \u0995\u09bf\u09ad\u09be\u09ac\u09c7 \u0985\u09cd\u09af\u09be\u09aa\u09cd\u09b2\u09be\u0987 \u0995\u09b0\u09a4\u09c7 \u09b9\u09df \u09a4\u09be \u09a6\u09c7\u0996\u09be\u09b0 \u099c\u09a8\u09cd\u09af \u0986\u09ae\u09be\u09a6\u09c7\u09b0 localhost>phpmyadmin \u098f\u09b0 \u0986\u09a8\u09cd\u09a1\u09be\u09b0 \u098f \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09a4\u09c7 \u09b9\u09ac\u09c7 \u098f\u09ac\u0982 \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09a4\u09c7 \u09b9\u09ac\u09c7\u0964 \u09aa\u09cd\u09b0\u09a5\u09ae\u09c7\u2026","rel":"","context":"In "\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001"","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6087,"url":"http:\/\/bangla.sitestree.com\/?p=6087","url_meta":{"origin":70287,"position":5},"title":"\u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf : \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf (PHP Create MySQL Tables)","author":"Author-Check- Article-or-Video","date":"February 23, 2015","format":false,"excerpt":"\u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8 \u099f\u09c7\u09ac\u09bf\u09b2 \u098f\u09b0 \u09a8\u09bf\u099c\u09b8\u09cd\u09ac \u09a8\u09be\u09ae \u09a5\u09be\u0995\u09c7 \u098f\u09ac\u0982 \u098f\u099f\u09be \u0995\u09b2\u09be\u09ae \u0993 \u09b8\u09be\u09b0\u09bf \u09a8\u09bf\u09af\u09bc\u09c7 \u0997\u09a0\u09bf\u09a4 \u09b9\u09df\u0964 MySQLi \u098f\u09ac\u0982 PDO \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 \u098f\u0995\u099f\u09bf \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u099b\u0995 (table) \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09be \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u098f \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09a4\u09c7 CREATE TABLE \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f \u09ac\u09cd\u09af\u09be\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be \u09b9\u09df\u0964 \u0986\u09ae\u09b0\u09be \u098f\u0996\u09a8 \"MyGuests\" \u09a8\u09be\u09ae\u09c7 \u098f\u0995\u099f\u09bf \u099f\u09c7\u09ac\u09bf\u09b2 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09ac\u09cb \u09af\u09be\u09b0 \"id\", \"firstname\", \"lastname\", \"email\"\u2026","rel":"","context":"In "\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial"","block_context":{"text":"\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial","link":"http:\/\/bangla.sitestree.com\/?cat=172"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/70287","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=70287"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/70287\/revisions"}],"predecessor-version":[{"id":78120,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/70287\/revisions\/78120"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=70287"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=70287"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=70287"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}