What?
A super quick article on how to pre-select the pipeline on deal creation within CRM based on the department specified on a user's profile.
Why?
A client asked that when staff create a deal/opportunity ...
What?
An article with a quick snippet of code which builds up the address from a Lead record to geocode into latitude and longitude coordinates to feed a third-party API which returns a timezone.
...
... the process would be: allow a user to apply for leave, then on save/submit, auto approve/reject the application based on a custom function that could calculate the percentage of staff who already booked ...
What
A quick note as I had difficulty finding a clear answer on this. I need a cron job setup where the permissions for a database user is required to do a backup (reading and copying data from a LIVE ...
What?
A quick article on how to populate a database column from another table using a string comparison.
Why?
I have several database tables which replicate country names and I would rather they ...
Applies to:
MS SQL Server Management Studio 2008
Two Transact-SQL databases
What?
A quick article on how to compare two Microsoft databases using the tools provided with SQL Server and without ...
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 ...
What?
This is an article on how to do a restore from backup on a database but when you get the error: "... database is in use".
-- SQL Server 2005
EXEC SP_WHO // details on who is logged ...
What?
This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database.
Why? ...
... that would replace my HTML tags with . Not I want to switch these back.
How?
For demo purposes, I'm searching a column called introtext in a database table called MYTABLE_content.
First let me ...
What?
So this is a quick article on how to install the mySQL add-on for Oracle SQL Developer v3.0.04.
Why?
I've used various mySQL administration tools to manage mySQL databases over the years, ...
What?
Apologies for posting yet another article on how to access the Joomla Database using the Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation ...
What?
We have a datawarehouse and we want to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called ...
... same values, so I should go through the database and change all variations to be typed the same way in the same case.
Wouldn't it be nice to search through your entire database for similar sounding ...
What?
I have a PHP script which behaves like PhpMyAdmin, in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone ...
... of these need to connect to the database but as they sit outside of the MVC structure, we need them to use the existing configuration file in order to retrieve the credentials (ie. username, password, ...
... of results (comparing various reports) in a table and then to color the backgrounds based on whether they are the fastest or slowest in the set.
Something like:
The DataSet
This should ...
... as to what this database is and how it populates its data.
View: ExecutionLog
InstanceName nvarchar(38) NOT NULL Name of the report server instance that handled the request. Usually YOURSERVERNAME\MSSQLSERVER ...
Well I tried the SQL Server Management Studio solution to connect to a MySQL database then lost my way wondering what was I trying to achieve?
I've written this article because this is how I connected ...
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.