Hi,
I have a list of tables in a Netezza database and I want to get the name of primary key for each of the tables.
Can anyone provide me the query.
akshaycjoshi
Last Activity: Sep 15 '10, 11:26 PM
Joined: Jan 28 '07
Location:
-
NULL In IN clause
I have a table called NUMS with a single column n.
And I fill values 1,2,3,4,5,null in it.
Consider a query
SELECT n FROM Nums
WHERE n NOT IN (1, 2, null)
In this case I guess it's converted to
SELECT n FROM Nums
Where NOT(n = 1 OR n = 2 OR n = null)
The comparison n=null will evaluate UNKNOWN for all the values on n
including null.
... -
What's unclear ?
I want the database to be opened only by one login, not even by windows authentication.
Ordinarily you can access all the databases when u use windows authentication. -
About Sql Server(Posted in .NET coz it's easy)
I want to set a login for a database that i will create in an SQL server instance.
For ex.
After installing Sql Server Express, i will first create a script to create a login.
Then by using the username and password(for the login I created) i will create a database by using script.
Now i want that the database should be accessable by anyone connecting with that username and password only.
... -
hahahaha :)
Thanks !Leave a comment:
-
What's that for ?
:)Leave a comment:
-
Thread.Sleep() emulates some actual work.
Anyways I have found the answer.
Here is the code
...Code:WaitForm waitfrm = new WaitForm(); delegate void del(); void CLOSE() { waitfrm.Close();<br/>} private void button1_Click(object sender, EventArgs e) { Thread th = new Thread(FUNC); th.Start(); waitfrm = new WaitForm(); waitfrm.ShowDialog(); }Leave a comment:
-
HOW TO SHOW: Processing...
There are some textboxes placed on a form along with one button.When the user presses the button a modal window pops up till the work is finished and that window shows that circling processing GIF image.
By showing the form as modal , the user will not be able to press the button again untill the shown modal window is closed, which happens automatically when the processing is done.
This I tried to achieve this effect by creating the... -
How would I do that ?...Leave a comment:
-
Validation Of Controls
Ok here is what I have got on my Form.
One Tab with 3 TabPages.
Each Tab page cantains some group boxes.
Each groupBox cantains DatTimePicker,T extBoxes,CheckB oxes etc.
Some of the controls need to be validated.
Ex-I want one textbox to have float value only.
I did that by handling the Validating event and when the error is found, an ErrorProvider is flashed and e.Cancel is set to true to reset... -
No reply ?
It's happening with me these days.Leave a comment:
-
C# version and .NET version
.NET version c# version
1.0----------c# 1.0
1.1----------c# 1.0
2.0----------c# 2.0
3.0----------c# 2.0
3.5----------c# 3.0
I guess I have made the above table right because I have come to know that C# version and .NET framework version is different.
The .NET framework is installed as setup packages like dotnetfx for .net 2.0.
It contains the c# compiler also csc.exe.
... -
Regarding type promotion
consider this
My teacher used to tell me that when the statements is executed the following happens.Code:int a=1+2;
(1) Literal 1 is infered to be the smallest among int,uint,long,u long.
In this case 1 is infered as int
(2) Same with literal 2.
(3)So we have got 2 ints
The addition of the two ints will be performed and the type of result will depend of which is bigger among the two.In... -
Need help to understand virtual functions
I am reading a book which says
Even though unboxed value types don't have a type object pointer, you can still call virtual
methods (such as Equals, GetHashCode, or ToString) inherited or overridden by the type. The
reason is because the CLR can just call these methods nonvirtually and System.ValueTyp e
overrides all of these virtual methods and expects the value in the this argument to refer to an
unboxed... -
Also he says
The JITCompiler function then searches the defining assembly's meta-
data for the called method's IL
Searches metadata for the IL ?Leave a comment:
-
managed code and managed data
I am reading CLR via C#.
The author says
Microsoft's C#, Visual Basic, JScript, J#, and the IL Assembler always produce modules that
contain managed code (IL) and managed data (garbage-collected data types). End users must
have the CLR (presently shipping as part of the .NET Framework) installed on their machine
in order to execute any modules that contain managed code and/or managed data in the... -
Select MEMO datatype in your Access database.Leave a comment:
-
Default file group
Default filegroup is the one in which all database files are created when created without specifying a filegroup, all books say.
I did this
CREATE DATABASE Akshay_DB
ALTER DATABASE Akshay_DB
ADD FILEGROUP Secondary_FG
ALTER DATABASE Akshay_DB
ADD FILE
(
NAME = NonClust,
FILENAME = 'E:\fileone.ndf ',
SIZE = 5MB,
... -
Just see Internet Explorer 7's menu....Leave a comment:
-
UPDATE:The drag and drop is working with Xtreme database provided as sample but not with Sql server.
I tried and i can see the images.Leave a comment:
No activity results to display
Leave a comment: