Posts

SQL - ISO Country Names and Codes

SQL - ISO Country Names and Codes This document provides the necessary SQL statements for ISO 3166 country names and two and three letter codes. This page and the data are in UTF-8 encoding. Create Country Table Table is called base_country as it follows Edoceo naming conventions, change as necessary. This is for a PostgreSQL database, CREATE TABLE statements may need to be altered for your RDBMS. create table base_country ( id integer primary key, iso2 char(2), iso3 char(3), name_en varchar(64), name_fr varchar(64), name_de varchar(64) ); Create indexes as necessary, which may not be as this table is so small. Insert the Country Data This SQL should work on any SQL-99 compliant RDBMS. INSERT INTO base_country (id, iso2, iso3, name_en, name_fr) VALUES (1, 'AF', 'AFG', 'Afghanistan', NULL); INSERT INTO base_country (id, iso2, iso3, name_en, name_fr) VALUES (2, 'AX', 'ALA', 'Ă…land Islands', NULL); INSERT INTO ba

Sql StoredProcedure Optimization Tips

We will go over how to optimize Stored Procedure with making simple changes in the code. Please note there are many more other tips, which we will cover in future articles. Include SET NOCOUNT ON statement: With every SELECT and DML statement, the SQL server returns a message that indicates the number of affected rows by that statement. This information is mostly helpful in debugging the code, but it is useless after that. By setting SET NOCOUNT ON, we can disable the feature of returning this extra information. For stored procedures that contain several statements or contain Transact-SQL loops, setting SET NOCOUNT to ON can provide a significant performance boost because network traffic is greatly reduced. CREATE PROC dbo.ProcName AS SET NOCOUNT ON; --Procedure code here SELECT column1 FROM dbo.TblTable1 -- Reset SET NOCOUNT to OFF SET NOCOUNT OFF; GO 

Command-line Building With csc.exe

Command-line Building With csc.exe You can invoke the C# compiler by typing the name of its executable file (csc.exe) on the command line. If you use the Visual Studio Command Prompt (available as a shortcut on the start menu under Visual Studio Tools), all the necessary environment variables are set for you. Otherwise, you must adjust your path in order to enable csc.exe to be invoked from any subdirectory on your computer. If you do not use the Visual Studio Command Prompt, you must run vsvars32.bat to set the appropriate environment variables to support command line builds. For more information about vsvars32.bat, see How to: Set Environment Variables. If you are working on a computer that only has the Windows Software Development Kit (SDK), you can use the C# compiler at the command line if you use the SDK Command Prompt , which is available from the Microsoft .NET Framework SDK menu option. You can also use MSBuild to programmatically build C# programs. For more informat

Differences Between C# Compiler and C++ Compiler Output

Differences Between C# Compiler and C++ Compiler Output -------------------------------------------------------------------------------- There are no object (.obj) files created as a result of invoking the C# compiler; output files are created directly. As a result of this, the C# compiler does not need a linker.

how to enable instance using sp_configure

hi friends, i find too many issues while attaching any database file in asp..net project so for that use the below command for enable instance configuration in your sqlExpress sp_configure  'user instances enabled', 1; RECONFIGURE

Computer on rent in Gandhinagar

sunrise computer sec-24 Reference by Vikaram Sagar Candid computer contact number sivrambhai 9427055568, nanjibhai 9408474313 P-3 on 400Rs. P-4 on 600Rs. Core 2 dual on 800 laxmi info sec-21 Reference by Mr.Drumil Kanani (Niral's old room mate ) hareshbhai 9825332949 P-4 on 1200 P-3 on 800

Jquey with Webservice in asp.net

Image
how to call webservice from JQuery please find following steps Please find following steps for Create one WebService in asp.net project with DummyTest.asmx [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] [System.ComponentModel.ToolboxItem(false)] Create one Webmethod with SessionEnable = true [Webmethod(EnableSession=true)] Public string HelloWorld(string name) { //apply your logic here Return “Hello World” + name; } Come to aspx page and add jQuery Library at top of the page <script languge=”javascript” src=”jquery-1.3.2.js” ></script> <script languge=”javascript” src=”jquery-ui-1.7.2.min.js” ></script> ajax method parameters Type: “Post” or “Get” URL : your web service file name /Method name Data : paramert data for webmethod contentType: "application/json; charset=utf-8" dataType: "json" success : function error : function