1.
How do I UPDATE from a SELECT in SQL Server?
- SQL Server
- 2,026
- Nov 03, 2020
2.
How can I remove duplicate rows in SQL Server?
- SQL Server
- 1,824
- Nov 03, 2020
3.
How to split a string with a comma or a specific delimiter in SQL Server 2016 and later?
- SQL Server
- 1,789
- Nov 03, 2020
4.
How to concatenate text from multiple rows into a single text string in the SQL Server 2017 and later?
- SQL Server
- 2,101
- Nov 03, 2020
5.
How to concatenate text from multiple rows into a single text string in the SQL Server?
- SQL Server
- 1,845
- Nov 03, 2020
6.
How to search for particular keyword in all procedures
- SQL Server
- 2,274
- Oct 03, 2020
7.
How to get a list of SQL Jobs in SQL Server
- SQL Server
- 2,294
- Oct 03, 2020
8.
How to get a list of Stored Procedures with Created Date and Modified Date in SQL Server
- SQL Server
- 2,731
- Oct 03, 2020
9.
Different types of variables in SQL Server
- SQL Server
- 3,644
- Oct 03, 2020
10.
How to use Triggers in SQL Server
- SQL Server
- 3,088
- Oct 03, 2020
11.
What is the difference between Stored Procedure and Function in SQL Server
- SQL Server
- 3,122
- Oct 03, 2020
12.
What are the different types of functions in SQL Server?
- SQL Server
- 2,394
- Nov 03, 2020
13.
What are the different types of Named Batches in SQL Server?
- SQL Server
- 2,561
- Nov 03, 2020
14.
Anonymous Batches in SQL Server
- SQL Server
- 2,558
- Oct 03, 2020
15.
What are the different types of Batches in SQL Server?
- SQL Server
- 2,201
- Nov 03, 2020
16.
What is Non Equi Join in SQL Server
- SQL Server
- 2,912
- Oct 03, 2020
17.
What is Equi Join in SQL Server
- SQL Server
- 2,323
- Oct 03, 2020
18.
What is Cross Join in SQL Server
- SQL Server
- 3,475
- Oct 03, 2020
19.
What is Full Join (or) Full Outer Join in SQL Server?
- SQL Server
- 2,308
- Nov 03, 2020
20.
What are the different types of Joins in SQL Server?
- SQL Server
- 2,660
- Nov 03, 2020
21.
How delete record from parent table when there is Foreign Key relation in SQL Server
- SQL Server
- 11,659
- Oct 03, 2020
22.
What is DEFAULT Constraint in SQL Server?
- SQL Server
- 2,309
- Nov 03, 2020
23.
What is FOREIGN KEY Constraint in SQL Server?
- SQL Server
- 3,121
- Nov 03, 2020
24.
What is PRIMARY KEY Constraint in SQL Server?
- SQL Server
- 2,267
- Nov 03, 2020
25.
What is UNIQUE Constraint in SQL Server?
- SQL Server
- 2,274
- Oct 03, 2020
26.
What is CHECK Constraint in SQL Server?
- SQL Server
- 2,267
- Oct 03, 2020
27.
What is NOT NULL Constraint in SQL Server?
- SQL Server
- 2,346
- Oct 03, 2020
28.
What are the different types of Constraints in SQL Server?
- SQL Server
- 2,031
- Oct 03, 2020
29.
What is Temporary Table in SQL Server?
- SQL Server
- 2,276
- Oct 03, 2020
30.
What is the differences between CHAR, NCHAR, VARCHAR and NVARCHAR in SQL Server?
- SQL Server
- 3,685
- Oct 03, 2020
31.
How to create an Identity Column in SQL Server?
- SQL Server
- 2,098
- Oct 03, 2020
32.
How to use Drop Command in SQL Server?
- SQL Server
- 2,165
- Oct 03, 2020
33.
How to use Truncate Command in SQL Server?
- SQL Server
- 2,325
- Nov 03, 2020
34.
How to use Delete Command in SQL Server?
- SQL Server
- 3,405
- Nov 03, 2020
35.
How to use Update command in SQL Server?
- SQL Server
- 2,226
- Nov 03, 2020
36.
How to rename a column or Table in SQL Server?
- SQL Server
- 2,870
- Oct 03, 2020
37.
How to add or remove a column from a table in SQL Server?
- SQL Server
- 4,542
- Oct 03, 2020
38.
How to alter the table column in SQL Server?
- SQL Server
- 2,128
- Oct 03, 2020
39.
How to create a table in SQL Server?
- SQL Server
- 2,173
- Oct 03, 2020
40.
What are the different types of System Databases in SQL Server?
- SQL Server
- 2,481
- Oct 03, 2020
41.
How to insert values into Identity Column in SQL Server?
- SQL Server
- 19,900
- Oct 03, 2020
42.
How to replace string in SQL Server?
- SQL Server
- 2,282
- Oct 03, 2020
43.
How to get a fixed-length value in SQL Server?
- SQL Server
- 5,281
- Oct 03, 2020
44.
How to split a string in SQL Server?
- SQL Server
- 3,308
- Oct 03, 2020
45.
DDL, DML, DCL and TCL Commands in SQL Server
- SQL Server
- 2,741
- Oct 03, 2020
46.
What is Right Join (or) Right Outer Join in SQL Server?
- SQL Server
- 2,470
- Oct 03, 2020
47.
What is Left Join (or) Left Outer Join in SQL Server?
- SQL Server
- 3,455
- Nov 03, 2020
48.
What is Inner Join (or) Join in SQL Server?
- SQL Server
- 2,600
- Nov 03, 2020
49.
How to get current week dates in SQL Server?
- SQL Server
- 3,934
- Oct 03, 2020
50.
What is Cartesian Product in SQL Server?
- SQL Server
- 2,696
- Oct 03, 2020
51.
What are the different types of Date formats in SQL Server?
- SQL Server
- 3,984
- Nov 03, 2020
Categories