Database

Erdinc276-Dec-10 4:50

6-Dec-10 4:50

i am not sure if u really meant that..here i sent cek_no value to my stored proc. like that..
cmd.Parameters.AddWithValue("cek_no", System.Data.SqlDbType.NVarChar).Value=table.Row[i][0].ToString();

vemedya.com

tasumisra6-Dec-10 5:13

tasumisra

6-Dec-10 5:13

Thanks for the answer i ment in my question was suppose u need to pass 5 parameters .. so we can wither pass them separately or is there any other way to pass them when i can pass as single argument.

vikas da

jschell6-Dec-10 11:57

jschell

6-Dec-10 11:57

Then you repeat the above 5 times.

Mycroft Holmes6-Dec-10 13:27

Mycroft Holmes

6-Dec-10 13:27

Create a command object (sql client)
add an array of sql parameters
add a valid connection string to the command object
execute the command (executescalar)

Will you please do some research, a simple Google query will do - this question has been answered 1000s of times before and there are many many examples on the net showing you how to do this.

Never underestimate the power of human stupidity
RAH

PIEBALDconsult6-Dec-10 14:43

PIEBALDconsult

6-Dec-10 14:43

No, it seems that he wants to pass a class or struct or something.

Mycroft Holmes6-Dec-10 15:19

Mycroft Holmes

6-Dec-10 15:19

PIEBALDconsult wrote:
pass a class or struct

How did you get that from the OP.

The the answer would still be the same with an explanation that you cannot pass objects unless they are as xml data type Dead | X|

Never underestimate the power of human stupidity
RAH

adding Group by result to each other

Jörgen Andersson6-Dec-10 20:13

Jörgen Andersson

6-Dec-10 20:13

Mycroft Holmes wrote:
How did you get that from the OP.

He's cheating, the mindreader function is to be released with SQL:2012.

"When did ignorance become a point of view" - Dilbert

Erdinc276-Dec-10 1:50

6-Dec-10 1:50

i have a table which was created in MsSql 2005 Express..
http://img441.imageshack.us/f/numaralar.jpg/[^]
i have numbers in 6 columns..i can group every column and count which number was selected how many times in columns...
but for example number 10 exist in column1 and column2 and column3 also..how i can add that count results that i found for every column seperately to each other to find the total of the number 10 selected ...

vemedya.com

Goutam Patra6-Dec-10 2:09

Goutam Patra

6-Dec-10 2:09

Are you looking for something like this

SELECT

CASE WHEN NUM1 = 10 THEN 1 ELSE 0 END + 
CASE WHEN NUM2 = 10 THEN 1 ELSE 0 END + 
CASE WHEN NUM3 = 10 THEN 1 ELSE 0 END +
CASE WHEN NUM4 = 10 THEN 1 ELSE 0 END +
CASE WHEN NUM5 = 10 THEN 1 ELSE 0 END +
CASE WHEN NUM6 = 10 THEN 1 ELSE 0 END
AS TOTAL

FROM MYTABLE

Erdinc276-Dec-10 2:27

6-Dec-10 2:27

thanks for reply friend..when i write that code

SELECT num1,count(*) FROM NumaraBilgileri
GROUP BY num1

i got that http://img827.imageshack.us/f/num1column.png/[^]
as u see i have 22 numbers there..it is just for column1 and i have 5 more columns.. i mean that after that Select executed i have number 10 here 4 times..and in column2 i have 5 times number 10 so total makes 9..and so on.. i want to get the all numbers total in that table from 1 to 49..how i can get it

vemedya.com

Goutam Patra6-Dec-10 2:38

Goutam Patra

6-Dec-10 2:38

Then try using UNION Query like

SELECT A.NUM, SUM(A.TOTAL) AS TOTAL FROM (
SELECT num1 AS NUM,count(*) AS TOTAL FROM NumaraBilgileri
GROUP BY num1
UNION ALL
SELECT num2 AS NUM,count(*) AS TOTAL  FROM NumaraBilgileri
GROUP BY num2
) AS A
GROUP BY A.NUM

You need to create union for all fields.

Erdinc276-Dec-10 2:55

6-Dec-10 2:55

thanks for the reply man..that was the what exactly i mean
now it works for all columns

vemedya.com

Mass Data on db

Alireza Loghmani5-Dec-10 8:22

Alireza Loghmani

5-Dec-10 8:22

Hi

I'll develop a website that people will post something formatted with HTML with some pictures. Which way is better to save these content (long HTML with several pictures)? Save them in db or save them on disk? Why?

Thanks a lot.

Eddy Vluggen5-Dec-10 11:35

5-Dec-10 11:35

Alireza Loghmani wrote:
Which way is better to save these content (long HTML with several pictures)?

That depends on your needs, both have advantages and disadvantages. I listed some in the answer over here[^].

A website; how many space do you have on your ftp-account, and how many space is available in your database? If it's a very busy database-server (lots o' queries, lots o' records), I'd opt to save the files in the directory-structure. Otherwise, they'd go into the database. Especially with an online-host, where they might have separate backupplans for databases and normal files.

There's an extra advantage to having them saved as files on the system; if the directory is accessibly from IIS, you could hotlink to that file from outside your server - without the need of adding any load to your databaseserver at all Smile | :)

I are Troll Suspicious | :suss:

Alireza Loghmani5-Dec-10 11:42

Alireza Loghmani

5-Dec-10 11:42

OK man, thanx. that's my answer.

Eddy Vluggen5-Dec-10 11:56

5-Dec-10 11:56

My pleasure Smile | :)

random unique number [mysql]

PIEBALDconsult5-Dec-10 13:22

PIEBALDconsult

5-Dec-10 13:22

Alireza Loghmani wrote:
Save them in db or save them on disk?

Isn't the DB on disk? Confused | :confused:

I'd just stick it in the database; easier to backup, copy, etc. Plus, I'd live in fear of someone deleting or modifying the files.

Jassim Rahma5-Dec-10 3:27

Jassim Rahma

5-Dec-10 3:27

how can I generate a random unique Int64 number in the activation_number field but I want to make sure the generated number doesn't exist in the table?

Blue_Boy5-Dec-10 11:09

Blue_Boy

5-Dec-10 11:09

select sum(activation_number)+1 from mytable

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

www.aktualiteti.com

Luc Pattyn5-Dec-10 11:42

Luc Pattyn

5-Dec-10 11:42

that will not work well, unless the table is extremely short.

1, 2, 4, 8, 16, ..., 2<<31, 0, 1, 2, 4, ...

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.

Eddy Vluggen5-Dec-10 11:51

5-Dec-10 11:51

Sql>

I are Troll :suss:

Eddy Vluggen5-Dec-10 11:46

5-Dec-10 11:46

That's "generating a number" and "verify it's occurance". For that you'd need;

An efficient way of generating a number
An efficient way of looking up a number (index the field!!)

Or, more efficient, use an auto-incremented[^] column. Isn't type BigInt allowed in MySql? Something like below, if I adapted the example correctly;

SQL

CREATE TABLE animals 
(
     id BIGINT NOT NULL AUTO_INCREMENT,
     name CHAR(30) NOT NULL,
     PRIMARY KEY (id)
) ENGINE=MyISAM;

I are Troll Suspicious | :suss: