is there any difference between the follow exemples?  ProjNum int      CONSTRAINT nn_ProjNum NOT NULL          CONSTRAINT C_ProjNum CHECK (ProjNum &gt;= 10)   and  ProjNum int NOT NULL      CHECK (ProjNum &gt;= 10)   Thanks.
I have some auto-generated T-SQL, which is probably valid, but I don't really understand.  ALTER TABLE [dbo].[MyTable] WITH CHECK CHECK CONSTRAINT [My_FORIEGN_KEY];   I know what a foreign key constraint is, but what's the CHECK CHECK?
How to input Traditional Chinese in pdfLaTeX I'm trying to write Chinese using pdfLaTeX. But currently I can only write Simplified Chinese Characters, If I try writing Traditional Chinese then the text wont show up.  This is what I have:  \documentclass{article} \usepackage{CJKutf8} \begin{document} \begin{CJK*}{UTF8}{gbsn} 文章内容。 \clearpage\end{CJK*} \end{document}   What would I need to do to get Traditional Chinese? How to prove $a^3 + b^3 +c^3 - 3abc =1 $, If a,b,c are infinite series as given in the description box below? How do I prove that $$ a^3+b^3+c^3−3abc = 1 $$ if   $ a = 1+\frac{x^3}{3!}+\frac{x^6}{6!}......$ , $b=x+\frac{x^4}{4!}+\frac{x^7}{7!}....$ , $c=\frac{x^2}{2!}+\frac{x^5}{5!}+\frac{x^8}{8!}......$ ?  I have tried the following :-  I discovered that $a+b+c=e^x$ and that $a=\frac{d(b)}{dx}$, $b=\frac{d(c)}{dx}$, $c=\frac{d(a)}{dx}$ . But I am unable to proceed further with these information. I have a data frame in python where I need to find all categorical variables. Checking the type of the column doesn't always work because int type can also be categorical.   So I seek help in finding the right hypothesis test method to identify if a column is categorical or not.   I was trying below chi-square test but I am not sure if this is good enough  import numpy as np data = np.random.randint(0,5,100) import scipy.stats as ss ss.chisquare(data)   Please advise. Can a satellite remain directly over a city? Is it possible to put an artificial satellite into an orbit in such a way that it will always remain direct over a city (I mean at any specific place)? Cannot translate vertice/edge will duplicate Most of the time when I try to move a vertex or an edge, instead of translating that, it extrudes it, it creates another face or, vertiex or whatever. I do not really get why it behaves like that. I hope I explained it in depth. I am sorry if this is a duplicate post but I could not find anything! Why aren't search engines indexing my content? I am currently writing a paper with several multiple regression analyses. While visualizing univariate linear regression is easy via scatter plots, I was wondering whether there is any good way to visualize multiple linear regressions?   I am currently just plotting scatter plots like dependent variable vs. 1st independent variable, then vs. 2nd independent variable, etc. I would really appreciate any suggestions. How to generate a random alpha-numeric string I have defined my own custom vim file type with highlighting etc.  I would like to open it using the terminal based vim when I double click on it.  I am using mac os x.  Any pointers on how to start on this? What does the exclamation mark do before the function? What is the best file extension for an SEO friendly URL? I'm working for a website to convert the website URL to an SEO friendly URL. I plan to use this:  example.com/category-name/pageid-123-page-name  I looked at some similarly categorized, highly ranked websites. They have the same structure, except for one thing. In one case, the URL format was  example.com/category-name/pageid-123-page-name.html  Another was   example.com/category-name/pageid-123-page-name.php  Now I know the text in URLs help with SEO. Is it more helpful to have a file extension? If yes, which one is better?  Or if my current plan is okay, will it be better with a / at the end? How can I do traffic shaping in Linux by IP? We have a transparent proxy setup. I tried looking for traffic shaping in Linux, and all I could find online was to limit traffic by interface (eth0/eth1...).  I need to limit the bandwidth (never exceeding a specific limit) by IP address or IP ranges and I can't find a way to do that.  Is there any way to do that? Frequent Write to Non-volatile Memory Two domains (when SSL) on same directory Update to latest version of java after ppa is discontinued I have been trying to install the latest version of java-8. However, I found out that the  due to changes in the java licence.  How should I update my java to 8.0_201 or 8.0_211 now?  Thanks! SELECT * EXCEPT Is there any RDBMS that implements something like SELECT * EXCEPT?  What I'm after is getting all of the fields except a specific TEXT/BLOB field, and I'd like to just select everything else.  Almost daily I complain to my coworkers that someone should implement this...  It's terribly annoying that it doesn't exist.  Edit: I understand everyone's concern for SELECT *.  I know the risks associated with SELECT *.  However, this, at least in my situation, would not be used for any Production level code, or even Development level code; strictly for debugging, when I need to see all of the values easily.  As I've stated in some of the comments, where I work is strictly a commandline shop, doing everything over ssh.  This makes it difficult to use any gui tools (external connections to the database aren't allowed), etc etc.  Thanks for the suggestions though. Seeking block (sub-district) level boundaries for India? I'm looking for block (sub-district) level shapefiles for India. The GADM database only has files for the 2300 Tehsils, whereas I'm looking for the about 5500 Census blocks (sub-districts) for any year possible. Is it possible to find the origin of a virus? Is there any method with which you can determine the origin for a given piece of malware in Windows?  One of my PCs was recently infected with the  password stealing trojan. Is there any way to tell from what source this virus was downloaded from? Let $X_n$ be iid random variables with $P(X_n=(-1)^kk)=\dfrac{C}{k^2\log k}$ for all $k\geq 2$. Here $C$ is just a constant so that the sum of probabilities is $1$. Find constant $\mu$ such that $S_n/n\to \mu$ in probability where $S_n=\sum_{k=1}^nX_k$.   Here $E(X_n)=\infty$. I'm a bit lost after this. In general how does one find constants like this? Why doesn't terminal show color schema once logged as root? I'm currently using Debian 7 Wheezy, and I've noticed that the colors palette on terminal (which might be useful to identify among a large set of files and folders) are not enabled once I log as root.  Same, I've noticed the tab completion doesn't work the same in this situation.  How can I configure these issues?