Sql

05/14/19

How to find current transaction level?
How do you find current database's transaction level on SQL Server?
Follows • 1
Expert Answers •1
Sql

05/13/19

How to create composite primary key in SQL Server 2008?
I want to create tables in SQL Server 2008, but I don't know how to create composite primary key. How can I achieve this?
Follows • 1
Expert Answers •1
Sql

04/23/19

Does MS SQL Server's "between" include the range boundaries?
For instance can SELECT foo FROM bar WHERE foo BETWEEN 5 AND 10 select 5 and 10 or they are excluded from the range?
Follows • 1
Expert Answers •1
Sql

04/04/19

Is there ever a time where using a database 1:1 relationship makes sense?
I was thinking the other day on normalization, and it occurred to me, I cannot think of a time where there should be a 1:1 relationship in a database. Name:SSN? I'd have them in the same... more
Follows • 1
Expert Answers •1
Sql

03/27/19

Equivalent of LIMIT and OFFSET for SQL Server?
In PostgreSQL there is the `Limit` and `Offset` keywords which will allow very easy pagination of result sets. What is the equivalent syntax for Sql Server?
Follows • 1
Expert Answers •1
Sql

03/18/19

Find all tables containing column with specified name - MS SQL Server?
Is it possible to query for table names which contain columns being LIKE '%myName%' ?
Follows • 1
Expert Answers •1

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.