大约有 40,000 项符合查询结果（耗时：0.0250秒） [XML]
Create PostgreSQL ROLE (user) if it doesn't exist
...r fashion to what you had in mind:
DO
$do$
BEGIN
IF NOT EXISTS (
SELECT FROM pg_catalog.pg_roles -- SELECT list can be empty for this
WHERE rolname = 'my_user') THEN
CREATE ROLE my_user LOGIN PASSWORD 'my_password';
END IF;
END
$do$;
(Building on @a_horse_with_no_name's...
Batch file include external file for variables
...off
rem Empty the variable to be ready for label config_all
set config_all_selected=
rem Go to the label with the parameter you selected
goto :config_%1
REM This next line is just to go to end of file
REM in case that the parameter %1 is not set
goto :end
REM next label is to jump here and get a...
SQL Server: Query fast, but slow from procedure
...:
CREATE PROCEDURE GetOrderForCustomers(@CustID varchar(20))
AS
BEGIN
SELECT *
FROM orders
WHERE customerid = @CustID
END
Fast way:
CREATE PROCEDURE GetOrderForCustomersWithoutPS(@CustID varchar(20))
AS
BEGIN
DECLARE @LocCustID varchar(20)
SET @LocCustID = @CustID
SELEC...
Compare two files in Visual Studio
... the desktop. That's all!
Usage:
Open the Windows explorer via Win + E
Select two files to compare in the explorer
Drag and drop them as shown in the animation below:
After a few seconds (depending on the launch time of Visual Studio), the results will be shown in Visual Studio:
Note: It d...
How to reset sequence in postgres and fill id column with new data?
...
SELECT setval('seq', 1, FALSE) should do the same (here, the third argument, FALSE, does the magic, as it shows that nextval must be 1 instead of 2)
– Vasilen Donchev
Sep 22 '15 at 14:43...
Stored procedure slow when called from web, fast from Management Studio
...ariables.
eg. change:
ALTER PROCEDURE [dbo].[sproc]
@param1 int,
AS
SELECT * FROM Table WHERE ID = @param1
to:
ALTER PROCEDURE [dbo].[sproc]
@param1 int,
AS
DECLARE @param1a int
SET @param1a = @param1
SELECT * FROM Table WHERE ID = @param1a
Seems strange, but it fixed my problem.
...
Parse JSON in TSQL
...ing
The article and code is here: Consuming Json strings in SQL server.
Select * from parseJSON('{
"Person":
{
"firstName": "John",
"lastName": "Smith",
"age": 25,
"Address":
{
"streetAddress":"21 2nd Street",
"city":"New York",
"state":"NY",
...
Oracle query to fetch column names
...r case, I'd imagine the query would look something like:
String sqlStr= "
SELECT column_name
FROM all_tab_cols
WHERE table_name = 'USERS'
AND owner = '" +_db+ "'
AND column_name NOT IN ( 'PASSWORD', 'VERSION', 'ID' )"
Note that with this approach, you risk SQL injection.
EDIT: Uppercase...
MySQL IF NOT NULL, then display 1, else display 0
...
SELECT c.name, IF(a.addressid IS NULL,0,1) AS addressexists
FROM customers c
LEFT JOIN addresses a ON c.customerid = a.customerid
WHERE customerid = 123
...
Check if value is in select list with JQuery
...
Use the Attribute Equals Selector
var thevalue = 'foo';
var exists = 0 != $('#select-box option[value='+thevalue+']').length;
If the option's value was set via Javascript, that will not work. In this case we can do the following:
var exists = fal...