Viewing 15 posts - 16 through 30 (of 56 total)
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...
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius
August 16, 2016 at 8:00 am
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.
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius
July 27, 2016 at 12:22 pm
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,...
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius
July 27, 2016 at 8:16 am
http://www.sqlskills.com/blogs/erin/understanding-when-statistics-will-automatically-update/
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius
June 15, 2016 at 8:48 am
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...
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius
February 19, 2016 at 11:38 am
Don, you are right, we should try only use explicit conversion for better performance.
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius
October 29, 2015 at 8:37 am
try select cast('19.4615381' * -1.0 *1.00000 as numeric(18,6))
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius
October 26, 2015 at 8:21 am
If change count(1) to SUM(id), it return NULL and why?
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius
August 31, 2015 at 9:06 am
Every Problem has a Solution; Every Solution has a Problem: Smile:-P
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius
July 27, 2015 at 8:04 am
Do not realized need to use Sql Server 2012 forward version. Is it possible to do same thing in SSRS 2008 R2?
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius
July 23, 2015 at 11:58 am
How about BIT = 0&1|1%2; '' ; & ....?
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius
July 20, 2015 at 3:50 pm
try './/Book'
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius
July 13, 2015 at 9:49 am
How about use ISNULL?
-- Q3
SELECT
*
FROM
#abc a
...
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius
April 29, 2015 at 7:50 am
Can we use Group By 1,2,3, ... to make query DRYer it?
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius
April 7, 2015 at 12:48 pm
Viewing 15 posts - 16 through 30 (of 56 total)