In SQL, there are essentially basically two ways to INSERT data into a table: One is to insert it one row at a time, the other is to insert multiple rows at a time. Let’s take a look at each of them individually: INSERT INTO VALUES The syntax for inserting data into a table one … Continue reading
Banyak orang mempercayai bahwa mencintai diri sendiri adalah tindakan yang egois dan terlalu narsis. Faktanya adalah mencintai dirimu sendiri sama sekali bukanlah suatu tindakan yang egois. Jika kamu tidak menghargai diri sendiri bagaimana kamu bisa menghargai orang lain? Kamu mencintai orang tuamu, kekasihmu, dan teman-temanmu tetapi seberapa besar kamu mencintai dirimu sendiri? Kamu harus tahu … Continue reading
MENCARI pekerjaan ternyata sama sulitnya seperti mencari jodoh, sekali salah memilih, selamanya Anda akan terjebak pada kebosanan dan performa kerja yang tidak maksimal. Sebelum memutuskan menandatangi kontrak kerja, sebaiknya pastikan diri Anda benar-benar menginginkan pekerjaan tersebut. Agar tak menyesal pindah kerja, lakukanlah analisa kecil-kecilan terhadap tawaran pekerjaan yang baru ini. 1. Keuntungan Pindah kerja ke tempat baru … Continue reading
Step by step assign table data value into dropdownlist using ASP.NET Framework studio. This example using Visual Studio 2005 and Microsoft SQL Server 2008 1. Create Table USE [dbname] GO /****** Object: Table [dbo].[tbl_level] Script Date: 12/02/2011 01:11:03 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[tbl_level]( [lvl_id] … Continue reading
1. NETWORK DESIGN Before implementation network at your office/home (area), first planning desing is very importen. This is kind of sample simple network design Example server using IP : 192.168.1.1 and client workstation using 192.168.1.xxx . 2. RJ5 Cable RJ45 is a standard type of connector for network cables. RJ45 connectors are most commonly … Continue reading
How do set variable and set value variable in MsSQL Server Stored Procodure? let’go to these example : USE [dbname] GO /****** Object: StoredProcedure [dbo].[sp_importCust] Script Date: 12/01/2011 22:30:33 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER Procedure [dbo].[sp_importCust] @parSessionID VARCHAR(16) AS DECLARE @cif varchar(255), @cust_name varchar(255), @join_date varchar, @sales_code varchar(255), @sales_name varchar(255), … Continue reading
Datetime functions allow manipulating columns with DATETIME/SMALLDATETIME data types. SQL server DateTime Function: GETDATE and GETUTCDATE Functions GETDATE and GETUTCDATE Functions are Nondeterministic function. Both functions returns the current date and time. GETDATE returns current system date and time of the computer where SQL Server is running. GETUTCDATE returns current UTC time (Universal Time Coordinate … Continue reading
String functions are mainly used to change the case of strings,concatenate strings,reverse strings,extract various part of strings and perform many other types of string manipulation. In SQL Server there is a Several built-in string functions to perform string manipulations.All below functions takes string input value and return a string or numeric value. ASCII : Returns … Continue reading
I’m trying to do something like : SELECT * FROM table LIMIT 10,20 or SELECT * FROM table LIMIT 10 OFFSET 10 but using SQLServer The only solution I found looks like overkill: SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (ORDER BY name) as row FROM sys.databases ) a WHERE row > 5 … Continue reading