A | B | C | D | Formel | Ergebnis |
---|---|---|---|---|---|
702 | 701 | 704 | 703 | =ZÄHLENWENN(A1:D1;A1)=4 | FALSCH |
799 | 799 | 799 | 799 | =ZÄHLENWENN(A2:D2;A2)=4 | RICHTIG |
=ZÄHLENWENN(B12:E12;B12)=4
A | B | C | D | Formel | Ergebnis |
---|---|---|---|---|---|
702 | 701 | 704 | 703 | =ZÄHLENWENN(A1:D1;A1)=4 | FALSCH |
799 | 799 | 799 | 799 | =ZÄHLENWENN(A2:D2;A2)=4 | RICHTIG |
In Query Windows enter this:
sp_helptext N'NameOfView'
If you want to get The Create Table Statment:
SELECT c.name +' ' +t.name +
case t.name
when 'nvarchar'
then ' ('+convert(varchar,c.max_length/2)+') '
else ''
end +','
--,t.name data_type
--,c.max_length max_length
--,c.precision precision
--,c.scale scale
--,c.is_nullable is_nullable
--,c.is_identity is_identity
--,c.collation_name collation_name
FROM sys.columns c
,sys.objects o
,sys.types t
WHERE c.object_id = o.object_id
AND t.system_type_id = c.system_type_id
and o.name = 'yourTableName'
and t.name != 'sysname'
How about:
where text is the string with the possible extraneous lines?http://stackoverflow.com/questions/1140958/whats-a-quick-one-liner-to-remove-empty-lines-from-a-python-string/1140966#1140966 |
sudo fdisk /dev/mmcblk0
sudo resize2fs /dev/mmcblk0p2
http://forum.tinycorelinux.net/index.php?topic=18932.0
SCYL=$(sudo fdisk -l /dev/mmcblk0 | grep mmcblk0p2 | awk '{ print $2 }')
echo -e "p\nd\n2\nn\np\n2\n${SCYL}\n\n\np\nw\n" | sudo fdisk /dev/mmcblk0
sudo reboot
sudo resize2fs /dev/mmcblk0p2
tc@box:~$ wget https://bootstrap.pypa.io/get-pip.py
tc@box:~$ sudo python get-pip.py
sudo fdisk /dev/mmcblk0
sudo resize2fs /dev/mmcblk0p2
Syntax objNetwork.MapNetworkDrive(strLocalDrive, strRemoteShare, [persistent], [strUser], [strPassword]) Key objNetwork : A WScript.network object strLocalDrive : The drive letter (e.g. L:) strRemoteShare : The UNC path to the remote drive \\MyServer\MyPrinter (String value) persistent : True/False - store the mapping persistently in the users profile default = false strUser : The user name. (Optional) strPassword : The password. (Optional)
sort --field-separator=';' --key=2,1,3
Input:
3;1;2
2;1;3
3;2;1
1;2;3
2;3;1
1;3;2
Output:
2;1;3
3;1;2
1;2;3
3;2;1
1;3;2
2;3;1
the dir:
-2015-10-05-2044
cd ./-2015-10-05-2044
First see whats the most recent version:
ftp://ftp.rarlab.com/rar/
look for unrarsrc-*.tar.gz
wget http://www.rarlab.com/rar/unrarsrc-4.1.4.tar.gz
tar xzvf unrarsrc-4.1.4.tar.gz # replace Version
cd unrar
make
sudo make install
SELECT * FROM (
SELECT 'OA' OBJECT_NAME, 'EU' REGION FROM DUAL UNION ALL
SELECT 'OB' OBJECT_NAME, 'EU' REGION FROM DUAL UNION ALL
SELECT 'OC' OBJECT_NAME, 'EU' REGION FROM DUAL UNION ALL
SELECT 'OA' OBJECT_NAME, 'US' REGION FROM DUAL UNION ALL
SELECT 'OB' OBJECT_NAME, 'AS' REGION FROM DUAL UNION ALL
SELECT 'OC' OBJECT_NAME, 'AS' REGION FROM DUAL ) S
PIVOT (COUNT (*) FOR REGION IN ('EU', 'US', 'AS'))
1: SET SERVEROUTPUT ON;
2: SET LINES 256
3: SET TRIMOUT ON
4: SET SPACE 1
5: SET tab OFF
6: DECLARE
7: dummy NUMBER;
8: BEGIN
9: FOR n IN (SELECT 'A.B' func FROM DUAL
10: UNION ALL
11: SELECT 'A.C' func FROM DUAL) LOOP
12: DBMS_OUTPUT.put_line ('<Action type="3" message="1700" wParam="0" lParam="0" sParam="" />');
13: DBMS_OUTPUT.put_line ('<Action type="3" message="1601" wParam="0" lParam="0" sParam="' || n.func || '" />');
14: DBMS_OUTPUT.put_line ('<Action type="3" message="1625" wParam="0" lParam="0" sParam="" />');
15: DBMS_OUTPUT.put_line ('<Action type="3" message="1653" wParam="0" lParam="0" sParam="C:\repo_facts\branches\" />');
16: DBMS_OUTPUT.put_line ('<Action type="3" message="1652" wParam="0" lParam="0" sParam="*.*" />');
17: DBMS_OUTPUT.put_line ('<Action type="3" message="1702" wParam="0" lParam="32" sParam="" />');
18: DBMS_OUTPUT.put_line ('<Action type="3" message="1701" wParam="0" lParam="1656" sParam="" />');
19: END LOOP;
20: EXCEPTION
21: WHEN NO_DATA_FOUND THEN
22: NULL;
23: WHEN OTHERS THEN
24: NULL;
25: END;
26: /
nohup find . -regex \.\*part[0]?[0]?1.rar -exec unrar x -inul {} \; &
nohup find . -regex \.\*part[0]?[0]?1.rar -exec unrar x -inul -pPASSWORD {} \; &