... string value in the space separated string
** Assumptions : None
** Inputs : @StringInput = the space separated string values
** Outputs : Single table
** Output ...
... What I want:
Why?
Outputting from SITS:Vision to our staging environment, the application would only output blank values using single tags so we had to find a place to introduce it. On strings ...
... #NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases.
#SingleInstance Force ; Skips the prompt that a current instance is ...
... report with a new template comprising of a single Tablix which contained the images of the corners and sides of the report. It looked beautiful if simply displayed on a single page (the top half of the ...
Applies to:
Microsoft Windows 7 Professional
What?
Looking at ways of displaying different drives per user on a single computer. This one is by modifying the system registry, so if you aren't familiar ...
...
FROM [dbo].[XML_EVENTS]
-- value() returns single value, specify data type as second parameter
SELECT Event_XML.value('(/STAFF/EMPLOYEE_NUMBER/@name)[1]','varchar(20)')
FROM [dbo].[XML_EVENTS]
...
What?
Somebody said I could pay to get an export list of my Joomla users. I said Joomla is a FREE OpenSource system, why?
Why?
I want to move a client's list of Joomla users to a new system which ...
What?
A quick reminder on basic regular expressions.
Match Any Character Dot
The dot operator '.' matches any single character in the current character set. For example, to find the ...
Applies to
Transact-SQL (T-SQL)
What?
This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table.
Why?
I have a table that ...
... is quickly forgotten.
How?
You need to set the database to single-user mode.
In SSMS, connect to an instance of the SQL Server Database Engine, and then expand that instance.
Right-click ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.