sql-server Archives - Page 9 of 16

How can you represent inheritance in a database?

I’m thinking about how to represent a complex structure in a SQL Server database. Consider an application that needs to store details of ...

May 17, 2022
0 Comments

What is the PostgreSQL equivalent for ISNULL()

In MS SQL-Server, I can do: SELECT ISNULL(Field,'Empty') from Table But in PostgreSQL I get a syntax error. How do I emulate the ...

May 17, 2022
0 Comments

Turning a Comma Separated string into individual rows

May 17, 2022
0 Comments

SQL Server Text type vs. varchar data type [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, ...

May 17, 2022
0 Comments

SQL Server: Query fast, but slow from procedure

A query runs fast: DECLARE @SessionGUID uniqueidentifier SET @SessionGUID = 'BCBA333C-B6A1-4155-9833-C495F22EA908' SELECT * FROM Report_Opener WHERE SessionGUID = @SessionGUID ORDER BY CurrencyTypeOrder, Rank ...

May 17, 2022
0 Comments

What are the differences between a clustered and a non-clustered index?

What are the differences between a clustered and a non-clustered index? 13 Answers 13

May 17, 2022
0 Comments

SELECT DISTINCT on one column

Using SQL Server, I have… ID SKU PRODUCT ======================= 1 FOO-23 Orange 2 BAR-23 Orange 3 FOO-24 Apple 4 FOO-25 Orange I want ...

May 16, 2022
0 Comments

How can I truncate a datetime in SQL Server?

What’s the best way to truncate a datetime value (as to remove hours minutes and seconds) in SQL Server 2008? For example: declare ...

May 16, 2022
0 Comments

How to check if a database exists in SQL Server?

What is the ideal way to check if a database exists on a SQL Server using TSQL? It seems multiple approaches to implement ...

May 16, 2022
0 Comments

Reset AutoIncrement in SQL Server after Delete

I’ve deleted some records from a table in a SQL Server database. The IDs in the table look like this: 99 100 101 ...

May 16, 2022
0 Comments