Recent questions tagged sql

0 votes
1 answer

What is the candidate key in SQL Server?

Feb 22 in Database by Vaani
• 7,020 points
376 views
0 votes
0 answers

What is "with (nolock)" in SQL Server?

Feb 22 in Database by Vaani
• 7,020 points
256 views
0 votes
1 answer

SQL SELECT WHERE field contains words

Feb 21 in Database by Vaani
• 7,020 points
4,399 views
0 votes
1 answer
0 votes
1 answer

What is "with (nolock)" in SQL Server?

Feb 21 in Database by Vaani
• 7,020 points
119 views
0 votes
1 answer

How do I use ROW_NUMBER()?

Feb 18 in Database by Neha
• 8,940 points
93 views
0 votes
0 answers
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

SQL WITH clause example

Feb 17 in Database by Vaani
• 7,020 points
45 views
0 votes
1 answer

Insert date value in SQL table

Feb 17 in Database by Vaani
• 7,020 points
35,651 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Is SQL syntax case sensitive?

Feb 16 in Database by Neha
• 8,940 points
2,243 views
0 votes
1 answer

Syntax of for-loop in SQL Server

Feb 15 in Database by Vaani
• 7,020 points
236 views
0 votes
1 answer
0 votes
1 answer
0 votes
0 answers

Selecting COUNT(*) with DISTINCT

Feb 14 in Database by Neha
• 8,940 points
128 views
0 votes
1 answer

Should I use != or <> for not equal in T-SQL?

Feb 14 in Database by Neha
• 8,940 points
85 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

NOT IN vs NOT EXISTS

Feb 11 in Database by Vaani
• 7,020 points
139 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

SQL Group By with an Order By

Feb 10 in Database by Neha
• 8,940 points
54 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

What are DDL and DML?

Feb 8 in Database by Neha
• 8,940 points
295 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

SQL Switch/Case in 'where' clause

Feb 7 in Database by Neha
• 8,940 points
221 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
2 answers

Case in Select Statement

Feb 4 in Database by Vaani
• 7,020 points
107 views
0 votes
1 answer

What is a stored procedure?

Feb 4 in Database by Vaani
• 7,020 points
303 views
0 votes
0 answers
0 votes
1 answer

What is an index in SQL?

Feb 3 in Database by Neha
• 8,940 points
117 views