MySQL's SHOW GRANTS shows the permissions of the current user.
Is there a way to log in as root and show the permissions of all users?
Try
SELECT COL_A,
COL_B,
COL_C,
ROW_NUMBER() OVER(ORDER BY COL_C) ROW
FROM A_TABLE
order by 4 asc
i have to execute two statements in a sequence. My Statement is as below. I get the above error when i run this.
TRUNCATE TABLE MANUAL_LIST_BACKUP
INSERT INTO MANUAL_LIST_BACKUP AS SELECT * FROM MANUAL_TRANSACTIONS
The database scheme consists of four tables:
Product(maker, model, type)
PC(code, model, speed, ram, hd, cd, price)
Laptop(code, model, speed, ram, hd, screen, price)
Printer(code, model, color, type, price)
The table "Product" includes information about the maker, model number, and type ...
We get questions from time to time like this one or the odd 'how do I join two tables' SQL question, which fall short of our 'expert-level'.
Some are best migrated to SO, but for the rest, would it help to have a custom close reason of 'too basic'?
It could link to our 'what can I ask here' pag...
SQL:
SELECT
MAX(ansprechpartner.timestamp),
MAX(gallery.timestamp),
MAX(instrument.timestamp),
MAX(kurs.timestamp),
DATE_FORMAT('maxDate', '%d. %M %Y') as MaxDateFormat,
CASE
WHEN MAX(ansprechpartner.timestamp) > MAX(gallery.timestamp)
AND MA...
I have run SQL server command (update command)
is there any way to take back in that command ?
note: no backup taken
All routes through a case statement must output the same data type. Try casting the ID to a string like this and it will work.
DECLARE @SortOrder nvarchar(max);
SET @SortOrder = 'name';
SELECT * FROM [database_name].[schema_name].[table_name]
ORDER BY CASE @SortOrder
WHEN 'id' THEN cast(id...
Here's the relevant data
SELECT item_group_id
,item_id
,invoice_id
FROM item
WHERE item_group_id = 92480
# Results
92480 215342 88902
92480 215343 88902
92480 215344 88902
92480 215345 88902
92480 215346 90690
92480 215347 90690
92480 215348 NULL
92480 215349 ...
select case 'NULL' when 'NULL' then 'f' end as out
output: 1
but
select case (select (SELECT LEFT(l.list,LEN(l.list)-1)
FROM
(SELECT o.Reciting_Path + '|' + o.Declaimer +',' AS [text()]
FROM Poetry_Reciting AS o
where o.Poetry_I...
THE MEANING OF LIFE
http://safeshare.tv/w/OkKZmtFOEa
Influential section - Yusuf Estes with a young Christian
http://safeshare.tv/w/hcmjDAYrop
((( O mankind! Say No God But Allah, Achieve Eternal Salvation )))
" Laa ilaaha illallah " ( There is none worthy of worship except Allah )
( Introd...
I have a table which shows me my users' downloads reports.
The table looks like this:
╔═══╦════════════╦═════════════╗
║ ║ url ║ user ║
╠═══╬════════════╬═════════════╣
║ 1 ║ Bla ║ 1 ║
║ 2 ║ Bla Bla ║ 1 ║
║ 3 ║ Bla Bla Bla║ 1 ║
║ 4 ║ Bla2 ...
I have a json stored in SQL NVARCHAR(MAX) column something like this:
{ "field1":"value1", "field2":"value2" ...}.
I want to do wildcard search on any of the fields. A sample query can be:
Give me all rows that contains substring ax in field2. The query should return records with fax, axe, et...
I want to pivot data using the AVG() function, but I want to round the results to prevent repeating decimals from displaying.
When I try something like this: PIVOT( ROUND( AVG(column_name), 2) FOR ...)
I get an error: ORA-56902: expect aggregate function inside pivot operation
Here is a very...
No more re-typing the same comments over and over!
This script adds a little 'auto' link next to all comments boxes. When you click the link, you see a popup with 6 configurable auto-comments (canned responses), which you can easily click to insert.
This script was inspired by answers to thi...
I have the following existing SQL. I would like to rewrite this to NOT use the table variable. But I don't understand this well enough to write a replacement. It seems overly complex to me for just inserting into a table.
declare @FullOrderHeaderTable TABLE ( OrderId int, UpdatedTime DateTime)...We use Microsoft SQL as a repository of images and data about those images. We record in real time and never care about recovery. If the database slows down and can't handle the number of images, we report this event to the user.
So why do I need to use Transactions. Even if the user deletes the...
What are the defining characteristics of star schemas and snowflake schemas, and what are the different practical tradeoffs of using either one?
We use Microsoft SQL as a repository of images and data about those images. We record in real time and never care about recovery. If the database slows down and can't handle the number of images, we report this event to the user.
So why do I need to use Transactions. Even if the user deletes the...
You are the victim of branch prediction fail.
What is Branch Prediction?
Consider a railroad junction:
Image by Mecanismo, from Wikimedia Commons: http://commons.wikimedia.org/wiki/File:Entroncamento_do_Transpraia.JPG
Now for the sake of argument, suppose this is back in the 1800s - before...
