Re: Excel spreadsheet report with dollar totals, grouped by sales person in region - Database Discussion Boards

automatice databackup in sql server 2005

Member 1026685111-Sep-13 1:56

Member 10266851

11-Sep-13 1:56

how to set automatice data backup in sql server 2005

Re: automatice databackup in sql server 2005

Richard Deeming11-Sep-13 2:11

Richard Deeming

11-Sep-13 2:11

Setting up a Maintenance Plan to backup databases:
http://technet.microsoft.com/en-us/sqlserver/dd430301.aspx[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: automatice databackup in sql server 2005

Corporal Agarn11-Sep-13 2:39

Corporal Agarn

11-Sep-13 2:39

You could always setup a SQL Job to run:

SQL

BACKUP DATABASE MyDB TO DISK = N'G:\SQLBackup\MyDB_Backup.bak' 
        WITH INIT, NAME = N'MyDB Backup', SKIP, NOFORMAT, COMPRESSION

how to sql injection attackes for security login form

Member 1030263011-Sep-13 0:13

Member 10302630

11-Sep-13 0:13

It's a good site or not ? plz tell me any code project link

thanks

Re: how to sql injection attackes for security login form

Chris Quinn11-Sep-13 0:31

Chris Quinn

11-Sep-13 0:31

Do you want us to tell you how to carry out a sql injection attack, or how to prevent it?

=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================

Re: how to sql injection attackes for security login form

Amol_B11-Oct-13 4:24

Amol_B

11-Oct-13 4:24

Please refer
SQL Injection Attacks and Some Tips on How to Prevent Them[^]

Excel spreadsheet report with dollar totals, grouped by sales person in region

vkEE9-Sep-13 5:19

vkEE

9-Sep-13 5:19

Hi,

what is the best way to present a report, showing the dollar value per month for each salesperson in a certain region? Suppose we have Eastern and Western regions. Salesperson Sam, Sammantha, Roger,will

Should I use SSIS package for this purpose, or would a stored proc be able to create this same type of layout?

The report should look like, in an excel spreadsheet:

Region Salesperson Month(Total)
Eastern  Sam        $1050.00
         Roger      $100.00
         Will       $100.00
         Total      $1250.00

Western  Sammantha   $2000.00
         Total       $2000.00
Grand total         $3250.00

Any ideas is appreciated!

thanks.

Re: Excel spreadsheet report with dollar totals, grouped by sales person in region

Mycroft Holmes9-Sep-13 12:58

Mycroft Holmes

9-Sep-13 12:58

The UI (report layout) has absolutely NOTHING to do with the database. Use the stored proc to prepare the data for you.

Use the UI (excel or a reporting tool) to do the formatting and layout. You sub/grand totalling should be done in the reporting app, the pretty currency format belongs in the reporting app as well.

Never underestimate the power of human stupidity
RAH

Ms access database and vb6.0

Otekpo Emmanuel6-Sep-13 8:48

Otekpo Emmanuel

6-Sep-13 8:48

Hello everyone! My name is Emmanuel. Please, I wrote a name dictionary program with visualbasic 6.0 using ms access 2003 as my database. I linked the database with the visual basic program using adodc control. In my system, the application runs fine. But when I installed the application in other systems and tried to run it, an error message will occur saying that the C:\Name dictionary\NameDict.mdb is not a valid path. Please help. Thanks in advance!

Re: Ms access database and vb6.0

jschell6-Sep-13 8:51

jschell

6-Sep-13 8:51

When you install it you must also provide the database file.

Depending on your app either it is a empty file or with some pre-existing data.
The file should installed relative to your code. And I suspect in the same directory is probably going to be best for you.

Then the way you connect must specify that. If you are using ODBC then you need to research the connection string/parameters to discover how to specify the file specifically.

Re: Ms access database and vb6.0

Mycroft Holmes6-Sep-13 13:50

Mycroft Holmes

6-Sep-13 13:50

You are in Switzerland, that is not a 3rd world country (you don't have the excuse that you cannot afford/access .Net tech), why the hell are you developing in VB6, the language is dead and is no longer supported. You should be using VB.Net express which is FREE and supported.

[edit] sorry I seem to be repeating myself [/edit]

Never underestimate the power of human stupidity
RAH

Database name keeps on Disapearing from SQL SMS

chdboy5-Sep-13 17:19

chdboy

5-Sep-13 17:19

I'm fed up of my Ms SQL databases keeps on Disapearing from SMS ,and then keeps on coming back ..it is really frustrating ,is there any other database similar to ms sql which does not have any problem like this?

Re: Database name keeps on Disapearing from SQL SMS

Mycroft Holmes5-Sep-13 17:51

Mycroft Holmes

5-Sep-13 17:51

Well thats a new one, I have never heard this complaint about SSMS before, I suspect it is your environment rather than SSMS.

Never underestimate the power of human stupidity
RAH

Re: Database name keeps on Disapearing from SQL SMS

chdboy5-Sep-13 17:54

chdboy

5-Sep-13 17:54

It is not a new one I think,

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/e1679502-e6c2-4a06-8ee7-3572088bc6d7/sql-server-database-disappearing[^]

Re: Database name keeps on Disapearing from SQL SMS

Eddy Vluggen6-Sep-13 0:31

Eddy Vluggen

6-Sep-13 0:31

chdboy wrote:
I'm fed up of my Ms SQL databases keeps on Disapearing from SMS [..],is there any other database similar to ms sql which does not have any problem like this?

The IDE and the Database server are two distinctly different applications. What is dissapearing exactly? The alias as defined in SMS, the database (how? is it simply not visisble in the IDE, or is the actual physical file gone?)

MSAccess doesn't have this problem, but that's hardly a good replacement for Sql Server. Switching db-server will have more impact than simply a different IDE. FWIW, you can always download and use another IDE if you dislike SMS.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: Database name keeps on Disapearing from SQL SMS

Richard Deeming6-Sep-13 1:53

Richard Deeming

6-Sep-13 1:53

Are you using a SQL Express User Instance[^] (AttachDBFilename in your connection string)? These databases will automatically be closed and removed after a period of inactivity, which is why you can't see them in SQL Server Management Studio.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Using Textbox and dropdownlist while displaying a grid in struts2

VKey1133-Sep-13 18:25

VKey113

3-Sep-13 18:25

Dear Friends,

I am new to struts2 concept, can any one help me in creating a grid. While displaying the grid it should contain one column which fetches the data from database and another two columns of textfield and dropdown list.
Note:The database connectivity is done with the help of Hibernate

Re: Using Textbox and dropdownlist while displaying a grid in struts2

Mycroft Holmes3-Sep-13 19:11

Mycroft Holmes

3-Sep-13 19:11

Wrong forum, you need web development, this is not a database problem.

Never underestimate the power of human stupidity
RAH

[solved]The conversion of the nvarchar value overflowed an int column.

chdboy3-Sep-13 5:13

chdboy

3-Sep-13 5:13

This is the error

SQL

com.microsoft.sqlserver.jdbc.SQLServerException: The conversion of the nvarchar value '8737383838' overflowed an int column.

I'm putting the value integer into bank account number column.

Java

statement.setString(10,acnotxtfield.getText());

Using prepared Statement.

Re: The conversion of the nvarchar value overflowed an int column.

Simon_Whale3-Sep-13 5:37

Simon_Whale

3-Sep-13 5:37

the value that you are trying to convert is larger than the int can handle. I would suggest that you change the type to Big Int

int, bigint, smallint, and tinyint (Transact-SQL)[^]

Every day, thousands of innocent plants are killed by vegetarians.

Help end the violence EAT BACON

Re: The conversion of the nvarchar value overflowed an int column.

chdboy3-Sep-13 6:13

chdboy

3-Sep-13 6:13

Thanks a lot .

Re: [solved]The conversion of the nvarchar value overflowed an int column.

Bernhard Hiller3-Sep-13 23:28

Bernhard Hiller

3-Sep-13 23:28

chdboy wrote:
bank account number

No, a bank account number IS NOT a number. A number is something you do maths with. But what's the meaning of the sum of two bank account numbers? Consequently, use a textual respresentation, e.g. char(10).

Re: [solved]The conversion of the nvarchar value overflowed an int column.

Eddy Vluggen3-Sep-13 23:52

Eddy Vluggen

3-Sep-13 23:52

Re: [solved]The conversion of the nvarchar value overflowed an int column.

GuyThiebaut4-Sep-13 0:15

GuyThiebaut

4-Sep-13 0:15

Exactly! Bank account numbers can start with a zero or even contain non-numeric characters.

“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens

Re: [solved]The conversion of the nvarchar value overflowed an int column.

chdboy4-Sep-13 17:35

chdboy

4-Sep-13 17:35

We have only numeric bank account numbers .

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