What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-11-19 02:00:09
what are all the different types of indexes in sql
"There are two types of Indexes in SQL Server 1. Clustered Index A clustered index defines the order in which data is physically stored in a table. Table data can be sorted in only way, therefore, there can be only one clustered index per table.... Add solution -
SQL 2021-11-14 07:27:12
sql server management studio
/* Answer to: "sql server management studio" */ /* SQL Server Management Studio is a software application first launched with Microsoft SQL Server 2005 that is used for configuring, managing, and administering all components within Micr... Add solution -
C# 2021-11-05 13:56:08
create dropdown in datatable c# dynamically
DataTable dtt1 = (DataTable)Session["dbasecolumns"]; int l = dtt1.Columns.Count; string[] sqlcolumn = new string[l]; DropDownList drd = new DropDownList(); foreach (String colname in sqlcolumn) { drd.Items.Add(colname); } Add solution -
SQL 2021-10-29 15:21:14
sql to model c#
Generate C# class from SQL Server table without Store Procedure Is there any way to generate a class for table in SQL Server without adding table in project with ADO.net Entity Framework? enter image description here public class Approval { pub... Add solution -
SQL 2021-10-24 18:44:12
comparison operators sql
(Between) operator same as ">= <=" For example: Select * From Employees Where salary Between 4000 AND 6000; (NOT) operator excluding given For example: Select last_name, job_id From Employees Where "Not" job_id = 'ABC'; (IN)... Add solution -
SQL 2021-10-24 17:08:07
install ms sql server management studio
/* Answer to: "sql server management studio" */ /* SQL Server Management Studio is a software application first launched with Microsoft SQL Server 2005 that is used for configuring, managing, and administering all components within Micr... Add solution -
SQL 2021-10-23 14:27:07
joins in sql
JOINING 2 Tables in sql SELECT X.Column_Name , Y.Column_Name2 FROM TABLES1_NAME X INNER JOIN TABLES2_NAME Y ON X.Primary_key = Y.Foreign_key; --FOR EXAMPLE --GET THE FIRST_NAME AND JOB_TITLE --USE EMPLOYEES AND JOBS TABLE --THE RELATIONSHIP IS JOB_ID ... Add solution