Viewing 15 posts - 211 through 225 (of 2,894 total)
I wouldn't use foreachDB:
SET NOCOUNT ON;
IF OBJECT_ID(N'tempdb..#TempDBs') IS NOT NULL DROP TABLE #TempDBs;
CREATE TABLE #TempDBs(DatabaseName NVARCHAR(250), ExtendedProp NVARCHAR(MAX));
DECLARE @sql VARCHAR(MAX);
SET @sql = '';
February 6, 2014 at 5:52 am
As far as I am aware, it is impossible to create new system functions in SQL Server (unlike system procs).
Closest think you might want to do is to create function...
February 6, 2014 at 5:42 am
But it ony gives me AD users and I need AD Users, AD Groups and SQL users.
...
Do you Active Directory groups and user? If so...
February 6, 2014 at 5:34 am
What I want is this:
RowID, 1stAddr1, 1stAddr2, 1stAddr3, 1stAddr4, 1stPostcode, 2ndAddr1, 2ndAddr2, 2ndAddr3 (etc)
If you need just two columns: RowId and ConcatenatedAddress - use advised FOR XML with STUFF thingy.
If...
February 6, 2014 at 5:29 am
Select and RaisError only display the string up to the Char(0), but Print displays the entire string, even though both strings show the same Len() and DataLength()....
February 6, 2014 at 5:14 am
No need in windowed functions, you can achieve the same by simple ORDER BY of UNION ALL:
SELECT ItemName
FROM (SELECT *
FROM ...
August 23, 2013 at 10:25 am
GilaMonster (8/23/2013)
Eugene Elutin (8/23/2013)
SET ANSI_NULLS OFF;
IF 'x' <> NULL PRINT 'Well, it is known, sometimes... '
In a future version of SQL Server, ANSI_NULLS will always be ON and any applications...
August 23, 2013 at 9:57 am
GilaMonster (8/23/2013)
'x' = NULL returns UNKNOWN, not TRUE or FALSE
'x'<> NULL returns UNKNOWN, not TRUE...
August 23, 2013 at 9:40 am
Does your proc have input parameters which then used directly in WHERE clauses or JOINS?
If so, try to declare local variables at the top of proc, assign them to input...
August 23, 2013 at 9:35 am
There is another, more cryptic way, if you wish:
select * from @t where case when name = 'Check' then 1 else 0 end = 0
:hehe:
August 23, 2013 at 9:19 am
You need to specify TYPE COLUMN which holds file type extention.
Read BoL: http://technet.microsoft.com/en-us/library/ms187317.aspx
So you need a column to keep extention in.
August 23, 2013 at 8:45 am
BFSTEP (8/1/2013)
August 1, 2013 at 11:16 am
Eugene Elutin (8/1/2013)
GilaMonster (8/1/2013)
Eugene Elutin (8/1/2013)
3. Dirty read may not read data which was committed long ago...
That's not a dirty read. The definition of dirty read is reading uncommitted data.
That...
August 1, 2013 at 10:07 am
GilaMonster (8/1/2013)
Eugene Elutin (8/1/2013)
3. Dirty read may not read data which was committed long ago...
That's not a dirty read. The definition of dirty read is reading uncommitted data.
That nolock can...
August 1, 2013 at 10:03 am
vignesh.ms (8/1/2013)
How do I nested common table expression?
To nest CTE just use comma:
;WITH cte1 AS (SELECT .... FROM [sometable])
,cte2 AS (SELECT .......
August 1, 2013 at 9:58 am
Viewing 15 posts - 211 through 225 (of 2,894 total)