CREATE OR REPLACE VIEW doesn't seem to work in SQL Server. So how do I port CREATE OR REPLACE VIEW to work on SQL Server?  This is what I'm trying to do:  CREATE OR REPLACE VIEW data_VVVV AS  SELECT      VCV.xxxx,         VCV.yyyy AS yyyy,         VCV.zzzz AS zzzz FROM  TABLE_A ;   Any ideas?
In Oracle, I can re-create a view with a single statement, as shown here:  CREATE OR REPLACE VIEW MY_VIEW AS SELECT SOME_FIELD FROM SOME_TABLE WHERE SOME_CONDITIONS   As the syntax implies, this will drop the old view and re-create it with whatever definition I've given.  Is there an equivalent in MSSQL (SQL Server 2005 or later) that will do the same thing?
How do you correctly use a meat thermometer? Annuity notation in LaTeX How do you write this in LaTeX: What does the term saturating nonlinearities mean? I was reading the paper  and in section 3 were they explain the architecture of their Convolutional Neural Network they explain how they preferred using:     non-saturating nonlinearity $f(x) = max(0, x). $   because it was faster to train. In that paper they seem to refer to saturating nonlinearities as the more traditional functions used in CNNs, the sigmoid and the hyperbolic tangent functions (i.e. $f(x) = tanh(x)$ and $f(x) = \frac{1}{1 + e^{-x}} = (1 + e^{-x})^{-1}$ as saturating).   Why do they refer to these functions as "saturating" or "non-saturating"? In what sense are these function "saturating" or "non-saturating"? What do those terms mean in the context of convolutional neural networks? Are they used in other areas of machine learning (and statistics)? How to run both Intel and Nvidia graphics card driver on dual monitor setup? I'm trying to get Intel and Nvidia graphics card working together with two monitors. One monitor should use the Intel card and the other the Nvidia card. Of course, I want to use only one keyboard and one mouse to switch between both screens. Bumblebee didn't work for me.  I don't want to use the xserver-xorg-video-all package because I need the Nvidia card for gaming and I can't use only one graphics card because I need one for KVM virtualisation and the other one for my Linux desktop  So I tried to install the drivers and to configure the Xserver manually. The Nvidia driver is working and I get a video output. But I don't get a video output with the Intel card.  I followed   The config files: Polite or unrectified placement of the word please Injectivity of Homomorphism in Localization Let $\alpha:A\to B$ be a ring homomorphism, $Q\subset B$ a prime ideal, $P=\alpha^{-1}(Q)\subset A$ a prime ideal. Consider the natural map $\alpha_Q:A_P\to B_Q$ defined by $\alpha_Q(a/b)=\alpha(a)/\alpha(b)$. Suppose that $\alpha$ is injective. Then is $\alpha_Q$ always injective?    I think so, but I'm clearly being too dense to prove it! My argument goes as follows.  Let $\alpha(a)/\alpha(b)=0$. Then $\exists c \in B\setminus Q$ s.t. $c\alpha(a)=0$. If $B$ is a domain we are done. If not we must exhibit some $d\in A\setminus P$ s.t. $da=0$. Obviously this is true if $c =\alpha(d)$. But I don't see how I have any information to prove this!  Am I wrong and this is actually false? If so could someone show me the trivial counterexample I must be missing?   Many thanks! Why L1 norm for sparse models Why are there $|G/G'|$ 1-dimensional representations of $G$? Let $G'$ be the derived subgroup of a finite group $G$.   We have a correspondence $\{\mathrm{reps \ of \ G/G'}\} \longleftrightarrow \{\mathrm{reps \ of \ G \ with \ kernel \ containing \ G' }\} $  If we restrict to 1-dimensional reps, we get:  $\{\mathrm{1\ dimensional \ reps \ of \ G/G'}\} \longleftrightarrow \{\mathrm{1 \ dimensional \ reps \ of \ G \ with \ kernel \ containing \ G' }\} $  Now my notes say that there are $|G/G'|$ 1-dimensional reps of $G$. Since there are $|G/G'|$ 1-dimensional reps of $G/G'$, this must mean that all 1-dimensional reps of $G$ have kernel containing $G'$. Why is this so?  Thanks Inverting direction of mouse scroll wheel Is there a way to make a mouse scroll wheel invert its direction? I'd like to scroll upwards and have that action scroll downwards and vice-versa. There is no setting on the Mouse control panel that makes this possible.   Any pointers to a hack or a particular mouse model that has such a setting would be appreciated. I am using Windows 7. To show that $\sum a_nb_n$ is absolutely convergent How does carbon dioxide or water vapour absorb thermal infra red radiation from the sun? We are all told at school water vapour and carbon dioxide are the top two greenhouse gases, and that they absorb thermal infra red radiation, trap heat and warm up the Earth. My question is how do they do that? Why can't Oxygen or Nitrogen or any other gas not absorb infra red radiation as well as water vapour or CO2? MySQL single table static and dynamic pivot I have a table that looks like this:  +----------------------------------------+ |Name                | kode      | jum   | +----------------------------------------+ | aman               |kode1      | 2     | | aman               |kode2      | 1     | | jhon               |kode1      | 4     | | amir               |kode2      | 4     | +--------------------+-----------+-------+   How can I make a view like this with MySQL?                      kode1    kode2     count aman                  2         1        3   jhon                  0         4        4 amir                  0         4        4 How to prove $C_1 \|x\|_\infty \leq \|x\| \leq C_2 \|x\|_\infty$? I want to prove the following theorem (no idea whether it has a name):  Let $V = \mathbb{R}^n$ or $\mathbb{C}^n$ and $\|\cdot\|$ be a norm on $V$. Then, there exist $C_1, C_2 &gt; 0$ such that for all $x \in V$:  $$C_1 \|x\|_\infty \leq \|x\| \leq C_2 \|x\|_\infty$$  I first let $x \neq 0$ (otherwise it would be trivial). Then, I divided by $\|x\|_\infty$ and normalized the vector $x$ such that $\|x\|_\infty = 1$. That left me with  $$C_1 \leq \|x\| \leq C_2$$  but I don't see how this could help me or how I could possibly limit an unknown norm. How can I proceed? Or is this the wrong way anyway? Thanks for any answers. Retrieving the last record in each group - MySQL I have a VIP skybag (I believe this does not matter). It has a 3-number TSA lock built into the suitcase. I know the combination to unlock, let's say it's 345. Recently it was locked and while there was a different number on the combination lock the reset/set lock button was pressed.  Since then the reset/set lock button is pressed (stuck) and the lock button also does not unlock. Any pointers on how to unlock it? I am thinking of unscrewing the lock from inside of the suitcase but it seems quite a hassle, as I may have to assemble it back. Let me know if there is any other option to unlock it from the outside. I get this error whenever I try to install programs using the terminal:  home@ubuntu:~$ apt-get install myunity E: Could not open lock file /var/lib/dpkg/lock - open (13: Permission denied) E: Unable to lock the administration directory (/var/lib/dpkg/), are you root?   Also I'm unable to install updates using the terminal. How do I login to the Gamecenter on PewDiePie's Tuber Simulator, if you have not done it when they asked? Calling a function of a module by using its name (a string) How to partition an encrypted disk On any SE post one can use the backtick symbol ("`") in order to mark some text as being a piece of code, or computer output. For example: void main().  Is there a way to make use of "`" the same way in a LaTeX document?