Re: SSIS Question - Database Discussion Boards

Re: whats the date function for sql statement?

Krish - KP4-Apr-07 20:53

4-Apr-07 20:53

getdate() function returns current date & time

ex.
SELECT getdate()
returns current system date & time

INSERT INTO tblA (col1) VALUES (getdate()
inserts current system date & time into "col1" of "tblA"

Regards
KP

Re: whats the date function for sql statement?

neodeaths8-Apr-07 15:30

neodeaths

8-Apr-07 15:30

i'll try it out thx

Help with parameters

User 66584-Apr-07 13:21

User 6658

4-Apr-07 13:21

Hi
I'm using this code:

cmd = new MySqlCommand("SELECT * FROM @table ORDER BY size LIMIT 20", conn);
cmd.Parameters.Add("@table", table);
reader = cmd.ExecuteReader();

However, @table is not replaced with the variable table, and thus I get an exception that my SQL query is not correct. Can someone tell me what I'm doing wrong?

regards

modified 12-Sep-18 21:01pm.

Re: Help with parameters

rujuc#4-Apr-07 21:09

rujuc#

4-Apr-07 21:09

You can solve your problem by taking help from this link

http://www.nigelrivett.net/SQLTsql/TableNameAsVariable.html[^]

cheers!! Smile | :)

Re: Help with parameters

User 66585-Apr-07 12:59

User 6658

5-Apr-07 12:59

Thanks

Do I really need stored procedures for this task? I actually just wanted to avoid SQL injections, something like mysql_escape_string(table) does in PHP.

regards

modified 12-Sep-18 21:01pm.

SSIS Question

Marcus Spitzmiller4-Apr-07 8:13

Marcus Spitzmiller

4-Apr-07 8:13

Hope this is the right place - is anyone using SSIS here?

Let's say I have an input source which gives me a column of data that I'm interested in. Before inserting this data into my target, I need a couple of additional columns added to this data. One column is a sequence, 1, 2, 3, etc.. and the second column is a literal string. I'm pretty new to SSIS and I'm having some trouble getting off the ground.

Can anyone point me in the right direction?

Thanks!
Marcus

Marcus Spitzmiller

You will never hear me say, "I listen to pretty much everything." That is for people who don't care what goes in their ears.

Re: SSIS Question

Marek Grzenkowicz4-Apr-07 23:33

Marek Grzenkowicz

4-Apr-07 23:33

Use a Derived Column task to add new columns to the data.

If I work out a simple method to generate a sequence, I'll let you know.

Re: SSIS Question

Marcus Spitzmiller6-Apr-07 14:00

Marcus Spitzmiller

6-Apr-07 14:00

Thanks for the help!

Marcus Spitzmiller

You will never hear me say, "I listen to pretty much everything." That is for people who don't care what goes in their ears.

searching betweent two dates

Kunal P4-Apr-07 6:47

Kunal P

4-Apr-07 6:47

hi
i wanted to perform a search for records based on the date range specified by the user..

the input method is in mm/dd/yyyy in the webform

before going to the web from i just queried the table using the query builder and it constructed a query

SELECT patient.*
FROM patient
WHERE (Dt BETWEEN CONVERT(DATETIME, '2006-08-09 00:00:00', 102) AND CONVERT(DATETIME, '2006-09-09 00:00:00', 102))

now how do i use the same query to the webform... also how will i display the results in a gridview control..

also.. shud i create an stored procedure, by which i can make this possible

thx

Kunal

Re: searching betweent two dates

Christian Graus4-Apr-07 16:24

Christian Graus

4-Apr-07 16:24

A stored proc is always a better idea. You can just pass a DateTime as a param to a stored proc

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: searching betweent two dates

Frank Kerrigan5-Apr-07 0:04

Frank Kerrigan

5-Apr-07 0:04

like this

<br />
<br />
create proc getrecords<br />
<br />
@StartDate datetime,<br />
@EndDate datetime<br />
<br />
AS<br />
<br />
SELECT patient.*<br />
FROM patient<br />
WHERE (Dt BETWEEN @StartDate AND @EndDate)<br />
<br />
<br />
go<br />

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

Re: searching betweent two dates

meeram3955-Apr-07 1:42

meeram395

5-Apr-07 1:42

For searching data between two dates, you can also write the query as follows: Suppose that you want to search data between 01/03/2007 and 31/103/2007

Select field1, field2, datefield from tablename
where datediff(day,'01/03/2007',datefield) >= 0 and datediff(day,'31/03/2007',datefield) <=0 order by datefield

Meeram395

Problem with using OLEDB read excel file

kokain4-Apr-07 5:37

kokain

4-Apr-07 5:37

Hi all,

I'm using OLEDB to reading data from an excel file, using connection string below:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";

The problem I'm get in stuck in is OLEDB just read an excel file which have to have the first row is header, and then data row.

My excel file is formatted to use 6 beginning rows for introduction (not have any data), row 7 as header, then below is data row.

I couldn't read the file...Please help me!

Thanks in advance.

Re: Problem with using OLEDB read excel file

Rob Graham4-Apr-07 5:44

Rob Graham

4-Apr-07 5:44

As you have discovered, Oledb will not handle that format. You will have to use the Excel automation / interop to handle that (bizarre) format.

Re: Problem with using OLEDB read excel file

kokain4-Apr-07 16:16

kokain

4-Apr-07 16:16

Thank you. Please give me hint about that...

Image.

nclauder4-Apr-07 4:46

nclauder

4-Apr-07 4:46

HI,
Which Data Type accepts both image and character in one sql column?
Thanks

Re: Image.

mghiassi4-Apr-07 6:15

mghiassi

4-Apr-07 6:15

You can store an address of image file and use a HyperLink in runtime

Re: Image.

Frank Kerrigan4-Apr-07 23:20

Frank Kerrigan

4-Apr-07 23:20

TEXT : but you have to encode the image data to base64 (ie text).

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

RowCount property cannot be set on a data-bound DataGridView control.

kindman_nb4-Apr-07 3:38

kindman_nb

4-Apr-07 3:38

I want to increase the no of rows to prevent the backcolor of the Grid View

When I tried to increase DataGridrows as :
If Me.DataGridView1.RowCount < 20 Then DataGridView1.RowCount = 20

the error message :
RowCount property cannot be set on a data-bound DataGridView control.

can I deal with that to increase no of rows

jooooo

Re: RowCount property cannot be set on a data-bound DataGridView control.

Rob Graham4-Apr-07 4:00

Rob Graham

4-Apr-07 4:00

Since the grid is bound to a dataset, the number of rows in the dataset determine what is displayed in the grid. Why not just change the backcolor of the grid to match the backcolor of a row?

Re: RowCount property cannot be set on a data-bound DataGridView control.

kindman_nb4-Apr-07 4:13

kindman_nb

4-Apr-07 4:13

you are right ..
but I made alternating rows color ,, and some cells has it's own backcolor ,, then I can't make a single color
I hope you are see

jooooo

Re: RowCount property cannot be set on a data-bound DataGridView control.

Rob Graham4-Apr-07 5:45

Rob Graham

4-Apr-07 5:45

I guess you are just out of luck then.

Re: RowCount property cannot be set on a data-bound DataGridView control.

Frank Kerrigan4-Apr-07 23:22

Frank Kerrigan

4-Apr-07 23:22

Use the ItemDataBound property on the Datagrid.

see this for more details

http://www.codeproject.com/aspnet/PrettyDatagrids.asp[^]

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

backup and restore Database

Maira K4-Apr-07 3:25

Maira K

4-Apr-07 3:25

hi,
I want to know if there is a way - other than backup and restore database - to transfer all the data from one database on the server to another on a local SQLServer. it has to be done daily, so that the manager will always have an updated copy of the data on his machine.

Thanks in advance

Re: backup and restore Database

kubben4-Apr-07 3:55

kubben

4-Apr-07 3:55

I guess you could set up replication to do this as well. It might be kind of a pain depending on the number of tables and things like that.

Hope that helps.
Ben

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.