Explain Codes LogoExplain Codes Logo

Sql

How to print VARCHAR(MAX) using Print Statement?

sql
dynamic-slicing
varchar-max
print-statement

Describe table structure

sql
information-schema
sql-queries
database-structure

Select from one table matching criteria in another?

sql
prompt-engineering
best-practices
data-modeling

How to store MySQL query results in another Table?

sql
database-design
query-performance
data-integrity

Sql Server 2008: how do I grant privileges to a username?

sql
database-security
sql-server
role-based-access-control

Add row to query result using select

sql
join
data-types
best-practices

T-sql datetime rounded to nearest minute and nearest hours with using functions

sql
datetime
functions
performance

Sql COUNT* GROUP BY bigger than

sql
prompt-engineering
best-practices
join

How to update multiple rows at a time using LINQ to SQL?

sql
bulk-updates
linq-to-sql
performance-optimization

Select all the columns of a table except one column?

sql
dynamic-sql
sql-server
performance

Get most recent row for given ID

sql
prompt-engineering
best-practices
join

Create FILE encountered operating system error 5(failed to retrieve text for this error. Reason: 15105)

sql
file-permissions
sql-server-management-studio
database-attachment

Drop all tables command

sql
database-management
sqlite
sql-commands

Are there disadvantages to using a generic varchar(255) for all text-based fields?

sql
database-optimization
data-integrity
validation

Sql multiple join statement

sql
join
subqueries
best-practices

"case" statement within "WHERE" clause in SQL Server 2008

sql
best-practices
performance
sql-optimization

How can I join multiple SQL tables using the IDs?

sql
join
best-practices
data-management

Sql query to make all data in a column UPPER CASE?

sql
case-conversion
sql-functions
database-management

Setting two scalar variables in one SELECT statement?

sql
best-practices
performance
sql-server

Sql Server: Replace specific word in all rows of a particular column

sql
best-practices
join
sql-server
explain.codes / Sql