Viewing 15 posts - 1,891 through 1,905 (of 7,191 total)
Post your CREATE DATABASE statement, please. If you're doing it through the GUI (which I don't advise), click on the Script button in the New Database window.
John
February 1, 2017 at 7:30 am
Is it an upgrade, or a new install? This is my guess: you wanted to upgrade from 2014 to 2016, but you put Install instead of Upgrade in your config...
February 1, 2017 at 7:23 am
Raj
You're wrong, I think. If you have two dates that you need to compare, you need to make sure they can both be converted to datetime. The lesson...
February 1, 2017 at 5:12 am
Use the STUFF function to make your string look like this: '20140626 19:08:25'.
John
February 1, 2017 at 4:57 am
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
Viewing 15 posts - 1,891 through 1,905 (of 7,191 total)