Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Ask a Question
Top 100+ questions and answers in Sql
Home
Questions
Sql
0
votes
Q: Query to insert SQL carriage return and line break in query? Below query will helps you to insert carriage return or line break while working with the string data.
answered
May 22, 2022
in
Sql
by
AdilsonLima
sql--lite
0
votes
Q: What is Cartesian product in SQL?
answered
Jan 28, 2022
in
Sql
by
AdilsonLima
sql-server
0
votes
Q: What is degree and cardinality in SQL?
answered
Jan 28, 2022
in
Sql
by
AdilsonLima
sql-server
sql
+1
vote
Q: How would you prevent T-SQL code from running on a production SQL Server?
answered
Jan 15, 2022
in
Sql
by
GeorgeBell
t-sql
+1
vote
Q: What is the use of GO in Transact SQL?
answered
Jan 15, 2022
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What is the difference between PARTITION BY and GROUP BY
answered
Jan 15, 2022
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What is the difference between EXEC vs sp_executesql?
answered
Jan 15, 2022
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: Is it possible to import data directly from T-SQL commands without using SQL Server Integration Services? If so, what are the commands?
answered
Jan 15, 2022
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What's the difference between TRUNCATE and DELETE in SQL?
answered
Jan 15, 2022
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What are types of XML indexes in SQL Server?
answered
Jan 15, 2022
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What are the practical differences between COALESCE() and ISNULL(,'')?
answered
Jan 15, 2022
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What are bitwise operators and what is the value from a database design perspective?
answered
Jan 15, 2022
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: Provide an example of Left Outer Join with Exclusions?
answered
Jan 15, 2022
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What is uncommittable transactions?
answered
Jan 15, 2022
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What does the T-SQL command IDENT_CURRENT does?
answered
Jan 14, 2022
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What are the Join Types in TSQL?
answered
Jan 14, 2022
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What are ROLLUP and CUBE in T-SQL?
answered
Jan 14, 2022
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: Is there a difference between T-SQL linked server and a synonym?
answered
Jan 14, 2022
in
Sql
by
GeorgeBell
t-sql
+3
votes
Q: How can you delete duplicate records in a table with no primary key?
answered
Jan 14, 2022
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: How can you capture the length of a column when it is a Text, NText and/or Image data type?
answered
Jan 14, 2022
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: When should we use primary key or index?
answered
Jan 14, 2022
in
Sql
by
GeorgeBell
t-sql
+1
vote
Q: What is TSQL Window functions?
answered
Jan 14, 2022
in
Sql
by
GeorgeBell
t-sql
+1
vote
Q: What are the two commands to remove all of the data from a table? Are there any implications with the specific commands?
answered
Jan 14, 2022
in
Sql
by
GeorgeBell
t-sql
+1
vote
Q: What are the three ways that Dynamic SQL can be issued?
answered
Jan 14, 2022
in
Sql
by
GeorgeBell
t-sql
+1
vote
Q: What are 5 commands that can be used to manipulate text in T-SQL code?
answered
Jan 14, 2022
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What is OFFSET-FETCH filter in tsql?
answered
Jan 14, 2022
in
Sql
by
GeorgeBell
t-sql
+1
vote
Q: what are the limitations of IDENTITY column?
answered
Jan 14, 2022
in
Sql
by
GeorgeBell
sql
0
votes
Q: What are functions and their usage in SQL?
answered
Nov 8, 2021
in
Sql
by
rajeshsharma
sql-functions
0
votes
Q: Is a blank space or zero the same as a NULL value?
answered
Nov 8, 2021
in
Sql
by
rajeshsharma
null-value
0
votes
Q: What is the ACID property in a database?
answered
Nov 8, 2021
in
Sql
by
rajeshsharma
acid-property
To see more, click for all the
questions in this category
.
...