Very doubtful the below suggestion will work, as any 64 bit SQL machine requires the new ACE drivers.

There are no 64 bit JET drivers, so unless you explicitly installed...

terry999 (5/20/2013)

---

Hi

I need to update several tables which have the same field its a shopid.

e.g.

Update orders set Shopid =300 where shopid =3

Shopid is part of indices.

Will it make a...

the round function has an optional parameter for the # of decimal places;

the Absolute value function converts any number to positive:

/*

-13599.99 as 13600

162157.36 as 162157

7415781.64 AS 7415782

*/;With MySampleData([myval])

AS

(

SELECT '-13599.99' UNION...

No you cannot, not directly,

you have to call the operating system via xp_cmdshell to call the...

softwareeng2010 (5/20/2013)

---

hi all

i want to create table for fiscal year in sql server 2012.

the fields are :

1-ID

2-StartDate

3-EndDate

but i have some problems with ID column ,i want to set it for...

greeshatu (5/20/2013)

---

Hi ..

I have a Column 'X' NVARCHAR(10) in Table 'X' which is mapped to Column 'Y' Decimal(23,10) of Table 'Y'

I want to check in Table 'y' which are...

jayoub1 (5/17/2013)

---

I am a total newbie and have a question to ask. I am the only DBA on a team managing several SQL servers and we have a new...

Agreed the error about the profile is the giveaway about database mail.

take a look at this thread and solution i posted a while ago to Script Out your database mail...

if DecId is an identity() column, can can infer that if the data was ordered by DecId, only the last record applies;

Since this looks a lot like homework, I'll give...

partitioning the data, just by itself, does not mean the queries hitting it will be faster;

only on the queries where the optimizer determines that all the data required is all...

MichaelDep the problem with a logon trigger is it hits them with a hammer without regard to which database, so if both the OLTP and the reporting database is on...

select * from YourTable

where FLOOR(YourDecimalColumn) = YourDecimalColumn --can be converted to an int without data loss

AND YourDecimalColumn < 2147483647 --max size of an int

your not real clear on the question;

if the column is typed as (23,10), then every non-null value is a decimal, by definition;

so do you mean which values are null?

do you...

ok, it's possible if you newly created or attached a database, it might not be in the intellisense cache;

usually it gets rebuilt on connecting to a server, but in SSMS...

you'll need to add them with different names, because your collation is non-case sensitive in the master database;

you could rebuild the server with a case sensitive collation, but that...