CREATE TABLE TableTest1 (

ID INT NOT NULL,

CONSTRAINT PK_ID1 PRIMARY KEY(ID)

);

CREATE TABLE #TableTest2 (

ID INT NOT NULL

CONSTRAINT FK_TableTest1_ID FOREIGN KEY (ID) REFERENCES TableTest1(ID)

);

INSERT INTO TableTest1 (ID)

VALUES

(1);

INSERT INTO #TableTest2 (ID)

VALUES

(2);

select * from...

Thank you George Vobr, you are right, but if you do not use tempdb, it will not give you the information. The @@trancount will do.

If I use #tbl for insert values, and use 'dbcc opentran' to see the active transactions, it give me

No active open transactions.

DBCC execution completed. If DBCC printed error messages,...

http://www.sqlskills.com/blogs/erin/understanding-when-statistics-will-automatically-update/

The question did not tell us what data type and how many characters it is. So the correcter answer will be depend on. for example:

declare @myString char(12);

set @myString...

Don, you are right, we should try only use explicit conversion for better performance.

try select cast('19.4615381' * -1.0 *1.00000 as numeric(18,6))

How About

SELECT ROUND($0.999,1)

And

SELECT ROUND(0.999,$3)

?

If change count(1) to SUM(id), it return NULL and why?

Every Problem has a Solution; Every Solution has a Problem: Smile:-P

Do not realized need to use Sql Server 2012 forward version. Is it possible to do same thing in SSRS 2008 R2?

How about BIT = 0&1|1%2; '' ; & ....?

try './/Book'

How about use ISNULL?

-- Q3

SELECT

*

FROM

#abc a

...

Can we use Group By 1,2,3, ... to make query DRYer it?