Viewing 15 posts - 1,891 through 1,905 (of 7,187 total)
February 1, 2017 at 4:55 am
As Eirikur says, all changes are logged. But if your query doesn't make any changes, for example a SELECT query, the answer to your question is yes.
John
February 1, 2017 at 4:41 am
Something like this?
DECLARE @John table (CustName varchar(10))
INSERT INTO @John VALUES ('John'),('10234'),('John22'),('22John'),('123-456')
SELECT CustName
FROM @John
WHERE CustName NOT LIKE '%[^0-9\-]%' ESCAPE '\'
Edit -...
February 1, 2017 at 4:18 am
February 1, 2017 at 2:11 am
February 1, 2017 at 2:04 am
I'm working on an SP that will be run as part of an SSIS...
January 31, 2017 at 10:00 am
WITH MySampleTable([ID],[FIRST_NAME],[LAST_NAME],[START_DATE],[END_DATE],[status],[comment])
AS
(
SELECT '1234567','JANE','DOE','2016-09-06','2017-01-31','TERMINATED','for this line' UNION ALL
SELECT '1234567','JANE','DOE','2015-09-22','2016-09-05','ACTIVE','I''d like to get this...
January 31, 2017 at 9:20 am
January 31, 2017 at 9:06 am
select
MAX(Users.Fullname) as 'Name'
, MAX(Targets.FeesBilled) as...
January 31, 2017 at 8:32 am
SELECT
COUNT(UID)
, DATEDIFF(second,'20160101',datetimestamp)/20 AS Interval
, UID
FROM TABLE
WHERE datetimestamp >=...
January 31, 2017 at 7:16 am
DECLARE @DBCC NVARCHAR(256) ;
DECLARE @Database_Name NVARCHAR(50);
CREATE TABLE #DBCC
(
[Error] VARCHAR(255) ,
...
January 31, 2017 at 7:03 am
January 31, 2017 at 5:00 am
John
January 31, 2017 at 4:50 am
January 31, 2017 at 4:45 am
January 31, 2017 at 4:29 am
Viewing 15 posts - 1,891 through 1,905 (of 7,187 total)