Tagged Questions
0
votes
1answer
98 views
Group By - Incorrect syntax near 'mycolumn' [closed]
I'm getting a syntax error in SQL Server Management Studio (SQL Server 2008) for the following query:
SELECT
MIN(EffectiveOn) AS EffectiveOn,
Address1,
Address2,
Address3,
...
4
votes
1answer
141 views
Detecting if bit set in numeric value
I have a tinyint column that represents a set of flags. Assuming I wanted to know if a specific bit was set or not, how can I do bitwise AND/OR in a stored procedure?
2
votes
2answers
2k views
What is the easiest way to move data from Oracle to SQL Server?
One of our products supports both Oracle and SQL Server as database backend. We have a customer who wishes to switch from an Oracle backend to Microsoft SQL Server, which isn't a typical transition ...
2
votes
1answer
124 views
Is it possible to make a reference to the result of an aggregate function in a SELECT clause from the same SELECT clause?
I'm not a Database Administrator--just a Software Engineer. I would like to know if it is possible to reduce the following T-SQL query:
SELECT
SUM(Price * Quantity) as 'Total',
SUM(Price * ...
0
votes
3answers
85 views
Is it possible to check a date in SQL?
I'm trying to write a Microsoft SQL Server stored procedure which takes an account ID, and returns an authentication ticket and whether the ticket is expired.
Something like this:
SELECT ...
0
votes
3answers
38 views
helping hand for sql server resources
I'm just getting into SQL-SERVER, so forgive me if this is a basic question.
I need help, recently work on database programming, For my query development, to understand complex query, to can ...
17
votes
3answers
2k views
Performance difference for COALESCE versus ISNULL?
I've seen a lot of people use the COALESCE function in place of ISNULL. From internet searches, I've found that COALESCE is ANSI standard, so there is an advantage that we know what to expect when ...
