Okay, I was just curious as it is a pet peeve of mine. The semicolon is a statement terminator not a statement begininator.

Have you tried looking this up in Books Online? While in SSMS press Shift-F1.

vignesh.ms (1/3/2014)

---

Please explain following querys, how it works in back end and which one is preferable?

Query 1:

select *

from Mapping_tbl_1 a,Mapping_tbl_2 b

where iccid_trn between b.from and b.to

Query...

Eirikur Eiriksson (1/4/2014)

---

Thank you Jeff for a good "filler", there are many cracks "float"ing around when it comes to math and numbers on the platform. It is also far to...

To the OP: And you can learn...

Now, I have a suggestion. You should get to know Books Online. In SSMS press Shift-F1. There is a lot of good information in there and you...

Assuming this is still true: billed_date datetime

right('0' + cast(month(billed_date) as varchar(2)),2) + '-' + cast(year(billed_date) as varchar(4))

Because you are now working with SQL Server, not a desktop application.

The import/export wizard uses SSIS behind the scenes....

Just curious but in which order are you trying to drop them? Sounds like you are trying to drop the functions first then the schemes. Have you tried...

Congrats to all!!

Looking forward to next year! I'll be back!!

We had a database on an Enterprise version of SQL Server 2005. They had tested partitioning and dropped the partitions. While attempting to move that database to a...

jeandlauro (12/24/2013)

---

Hi,

I am running a POC database on my desktop using SQL Server Express 2012. I have created some triggers that work when I manually run a DML statement but...

isuckatsql (12/30/2013)

---

I partitioned a table some time ago to see if i could get any performance gains.

Since i did not, i deleted the table from the DB and the partitions...

ChrisM@Work (12/30/2013)

---

Lowell (12/27/2013)

---

I've got teh same answer ad Ed Wagner does, i just processed your post through a macro so i had some consumable data.

if you want solid help like...