Temp tables

Technical Article

RE: How to Determine Whole Dollar Amount

  • Reply

I'm trying to SELECT all records where the Amount is a whole dollar.  I need to exclude all records where the Amount field contains cents.  Using Dinakar's suggestion:SELECT * FROM Sales WHERE CAST(Amount AS int) = Amountappears to give me what I need.  I just need to verify that this is the correct syntax to […]


Technical Article

SMS Text messaging

  • Topic

HiHas anybody used SQL Server 2000 to send text messages to mobile phones.  We have groups of students we would like to able to text to perhaps say a class has been cancelled or something similar.  We currently do this with email (using Access VBA and Microsoft Exchange) but feel that text would be a better […]


1 reads


What do we want to achieve by encrypting our data?


On the face of it, this is a very obvious question with a very...

Daily Coping 5 Dec 2022


Today’s coping tip is to look for new reasons to be hopeful, even in...

Speaking at SQLSaturday MN 2022


Thanks all for joining me for two sessions at SQLSaturday Minnesota 2023, and for...

Read the latest Blogs


Pivot not working, pivot without aggregate functions.

By sbhagyalakshmi95

Hi Team,   Can you please help me to get data pivot data. my...

10 years as Sql server dba but still fears of Interview and lack of Confidence

By anoop.mig29

I dont know whether i may asking question at right or worng place but...

T-SQL Code Review - Where Field DOES NOT contain

By carlton 84646

Hello community, Quick question to get your opinion on simply T-SQL code. I want...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers