Code Generation

Technical Article

RE: Date Comparision of the Month Part

  • Reply

If I see this right, you want to query for a specific month, right?If so, why extract dateparts and convert anyway? You could also query for something like this:WHERE  < your date > >= DATEADD(MONTH,DATEDIFF(MONTH,30,GETDATE())-2,30)+1 AND  < your date > < DATEADD(MONTH,DATEDIFF(MONTH,30,GETDATE())-1,30) +1That example above would query the previous month. You might need to tweak this […]

2004-11-23

Technical Article

RE: Remote SQL Server Administration

  • Reply

My recommendation is to use Microsoft Terminal Client. It's better than PCA, you can have multiple connections, and the Remote server can still be locked while you access it from here.I used to control many servers in Saudi Arabia from Sri Lanka with a 128k line without any problem.you can also copy and paste easilty […]

2004-11-15

Technical Article

RE: Adding Column to a Table with Desired Order

  • Reply

I realize position doesn't affect anything and EM is not an option for me.Here is a script I found that reorders columns in sequential order. I thought someone has the script to do more.How to Fix Inconsistent Metadata ErrorsWhy does changing a table on a SQL Server 7.0 server cause "OLE DB provider 'SQLOLEDB' supplied […]

2004-11-12

Technical Article

RE: Index not used on Select *

  • Reply

Ray -Since there is no clustered index on this table, I would assume that data rows are stored sequntially.  Regardless of what is in my select statement, as long as I have the right where clauses, the query engine should use index seek to get to the addresses of the desired rows and then get the information […]

2004-03-18

Blogs

Advent of Code 2022

By

Foreword Advent of Code is an annual event in which participants solve a series of...

Daily Coping 8 Dec 2022

By

Today’s coping tip is to be curious. Learn about a new topic or an...

#PowershellBasics: Warnings and how to hide them.

By

One of my favorite parts of having a new job is that I learn...

Read the latest Blogs

Forums

The Enterprise Roadmap to Reducing Costs (While Increasing Value)

By Additional Articles

Comments posted to this topic are about the item The Enterprise Roadmap to Reducing...

The Temp Alias

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Temp Alias

Connect to SQL Server with Python to Create Tables, Insert Data and Build Connection String

By Additional Articles

Comments posted to this topic are about the item Connect to SQL Server with...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Temp Alias

See possible answers