Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Ask a Question
Sql questions and answers
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.
asked
May 22
in
Sql
by
AdilsonLima
sql--lite
0
votes
Q: What is Cartesian product in SQL?
asked
Jan 28
in
Sql
by
AdilsonLima
sql-server
0
votes
Q: What is degree and cardinality in SQL?
asked
Jan 28
in
Sql
by
AdilsonLima
sql-server
sql
+1
vote
Q: How would you prevent T-SQL code from running on a production SQL Server?
asked
Jan 15
in
Sql
by
GeorgeBell
t-sql
+1
vote
Q: What is the use of GO in Transact SQL?
asked
Jan 15
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What is the difference between PARTITION BY and GROUP BY
asked
Jan 15
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What is the difference between EXEC vs sp_executesql?
asked
Jan 15
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?
asked
Jan 15
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What's the difference between TRUNCATE and DELETE in SQL?
asked
Jan 15
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What are types of XML indexes in SQL Server?
asked
Jan 15
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What are the practical differences between COALESCE() and ISNULL(,'')?
asked
Jan 15
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What are bitwise operators and what is the value from a database design perspective?
asked
Jan 15
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: Provide an example of Left Outer Join with Exclusions?
asked
Jan 15
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What is uncommittable transactions?
asked
Jan 15
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What does the T-SQL command IDENT_CURRENT does?
asked
Jan 14
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What are the Join Types in TSQL?
asked
Jan 14
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: What are ROLLUP and CUBE in T-SQL?
asked
Jan 14
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: Is there a difference between T-SQL linked server and a synonym?
asked
Jan 14
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: How can you delete duplicate records in a table with no primary key?
asked
Jan 14
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?
asked
Jan 14
in
Sql
by
GeorgeBell
t-sql
+2
votes
Q: When should we use primary key or index?
asked
Jan 14
in
Sql
by
GeorgeBell
t-sql
+1
vote
Q: What is TSQL Window functions?
asked
Jan 14
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?
asked
Jan 14
in
Sql
by
GeorgeBell
t-sql
+1
vote
Q: What are the three ways that Dynamic SQL can be issued?
asked
Jan 14
in
Sql
by
GeorgeBell
t-sql
+1
vote
Q: What are 5 commands that can be used to manipulate text in T-SQL code?
asked
Jan 14
in
Sql
by
GeorgeBell
t-sql
+1
vote
Q: What is OFFSET-FETCH filter in tsql?
asked
Jan 14
in
Sql
by
GeorgeBell
t-sql
+1
vote
Q: what are the limitations of IDENTITY column?
asked
Jan 14
in
Sql
by
GeorgeBell
sql
0
votes
Q: What are functions and their usage in SQL?
asked
Nov 8, 2021
in
Sql
by
rajeshsharma
sql-functions
0
votes
Q: Is a blank space or zero the same as a NULL value?
asked
Nov 8, 2021
in
Sql
by
rajeshsharma
null-value
0
votes
Q: What is the ACID property in a database?
asked
Nov 8, 2021
in
Sql
by
rajeshsharma
acid-property
Page:
1
2
3
4
...
10
next »
...
