Re: SQL CE license question... - Database Discussion Boards

Re: should i Make new database after Financial year

Eddy Vluggen11-Jul-12 23:39

Eddy Vluggen

11-Jul-12 23:39

The idea to start a "new" database comes from an accountant, not a technician; a new year means a new book, a new page, a clean slate to them.

In a database, that's just silly. Include a date on the record, and you can select/manipulate the data is if you were working in a database with only data from that particular year (thanks to the WHERE clause)

Advantages include;

Easy maintenance (one database, as opposed to 20 clients with 4 years worth of databases)
Easy backups (since all is in one database)
Easier cross-querying (summing the data over multiple years)
Easier to understand (KISS applies to almost everything, everywhere)

The only disadvantage is that the accountant won't understand why you put the data in the "same books". That's the reason why they're not involved when creating a technical storage-facility, only when describing the data - they may explain what they need, but can hardly explain how it should be stored.

Bastard Programmer from Hell Suspicious | :suss:

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

Re: should i Make new database after Financial year

PIEBALDconsult13-Jul-12 3:51

PIEBALDconsult

13-Jul-12 3:51

No, but you could have tables where you summarize various periods for future comparisons and such.

Generate Excel From SQL

vvashishta11-Jul-12 19:48

vvashishta

11-Jul-12 19:48

I want to generate Excel Worksheet through a SQL Query fired on the table directly export data to an Excel Sheet.

- Happy Coding -
Vishal Vashishta

Re: Generate Excel From SQL

PIEBALDconsult11-Jul-12 19:54

PIEBALDconsult

11-Jul-12 19:54

No, you really don't. Excel is the devil's workshop.

I prefer to generate XML, it's more flexible. It can also be converted to CSV which Excel can read.

Re: Generate Excel From SQL

Eddy Vluggen11-Jul-12 23:43

Eddy Vluggen

11-Jul-12 23:43

vvashishta wrote:
I want to generate Excel Worksheet through a SQL Query fired on the table directly export data to an Excel Sheet.

..and?

Bastard Programmer from Hell Suspicious | :suss:

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

SQL CE license question...

Jun Du11-Jul-12 16:41

Jun Du

11-Jul-12 16:41

Do I need a license to deploy SQL CE to my CE devices for commercial use? I heard it's free but am not sure about it.

Best,
Jun

Re: SQL CE license question...

Richard MacCutchan11-Jul-12 23:32

Richard MacCutchan

11-Jul-12 23:32

Why not check with Microsoft, it's their product.

speaking as ...

Re: SQL CE license question...

Eddy Vluggen11-Jul-12 23:33

Eddy Vluggen

11-Jul-12 23:33

It is free for commercial use;

MSDN[^] wrote:
SQL Server Compact 4.0 is freely redistributable under a redistribution license agreement and application developers redistributing SQL Server Compact 4.0 can optionally register at the SQL Server Compact redistribution site. Registering will help the developers in getting information about SQL Server Compact critical security patches and hot fixes that can be further applied to the client installations.

Bastard Programmer from Hell Suspicious | :suss:

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

HELP SQL WILDCARDS PROB

EjojAnrodac11-Jul-12 7:31

EjojAnrodac

11-Jul-12 7:31

Display the last name of all employees who have an 'i' and an 'n' in their last name.

IS THIS STILL AN SQL WILDCARDS WITH A COMBINATION OF AN AND? SIGH..PLS. HELP.. Cry | :((

Re: HELP SQL WILDCARDS PROB

Luc Pattyn11-Jul-12 7:38

Luc Pattyn

11-Jul-12 7:38

YES

Luc Pattyn [My Articles] Nil Volentibus Arduum

Message Closed

11-Jul-12 7:41

EjojAnrodac

11-Jul-12 7:41

Message Closed

Re: HELP SQL WILDCARDS PROB

Luc Pattyn11-Jul-12 7:45

Luc Pattyn

11-Jul-12 7:45

NO

However I could help you when you show what you tried and explained how the results differ from what you want. It isn't my homework.

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

Re: HELP SQL WILDCARDS PROB

jschell11-Jul-12 8:57

jschell

11-Jul-12 8:57

EjojAnrodac wrote:
PLS. HELP..

Steps
1. Learn basics of SQL
2. Learn how AND works in WHERE clauses
3. Learn how wildcards work in LIKE expressions.
4. Use 1-3 to determine the answer.

Re: HELP SQL WILDCARDS PROB

Corporal Agarn11-Jul-12 9:26

Corporal Agarn

11-Jul-12 9:26

Which SQL language are you using? SQL, T-SQL, PL-SQL?

Re: HELP SQL WILDCARDS PROB

R. Giskard Reventlov11-Jul-12 9:45

R. Giskard Reventlov

11-Jul-12 9:45

Let me put you put of your misery: SQL Wildcards[^].

Note the article is very general: you will still have to work out how to apply the information therein.

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum

me, me, me

Generate Excel From SQL Server

vvashishta11-Jul-12 3:36

vvashishta

11-Jul-12 3:36

I want to get data of a table in to an Excel direct from a SQL Query.

Can anyone help?

- Happy Coding -
Vishal Vashishta

Re: Generate Excel From SQL Server

gonzalezmail1980h11-Jul-12 4:57

gonzalezmail1980h

11-Jul-12 4:57

Hello,

A quickly lookup in google.com, I´ve obtained this information:

SQL

INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\testing.xls;',
'SELECT Name, Date FROM [Sheet1$]')
SELECT [Name], GETDATE() FROM msdb.dbo.sysjobs
GO

If you need more informtion, you can use this link:
http://www.mssqltips.com/sqlservertip/1202/export-data-from-sql-server-to-excel/[^]

Regards,
David G. Big Grin | :-D

Trigger for execute exe When inserted a receode to table

hiran12310-Jul-12 23:09

hiran123

10-Jul-12 23:09

....

modified 12-Jul-12 4:32am.

Re: Trigger for execute exe When inserted a receode to table

Mycroft Holmes11-Jul-12 1:07

Mycroft Holmes

11-Jul-12 1:07

Why!
What a horrendous design, and it comes back to why would someone saddle themselves with such a nightmare!

You need to do as the error suggested, add a notifyicon to your service that will live in the tray, this is the path to a UI, services do not have a UI!

Never underestimate the power of human stupidity
RAH

Re: Trigger for execute exe When inserted a receode to table

hiran12311-Jul-12 16:38

hiran123

11-Jul-12 16:38

If this structure is now suitable please suggest me something different. I need to fire a alarm when the data row inserted to the particular sql table.

Re: Trigger for execute exe When inserted a receode to table

Mycroft Holmes11-Jul-12 17:57

Mycroft Holmes

11-Jul-12 17:57

Where is the alarm going to be consumed, on the server!

Why not have a trigger spit send an email via sql mail or write an app that send a text message. Most orgs either lock down the table so only authorised people have access or use email alerts.

Never underestimate the power of human stupidity
RAH

Parameter Sniffing

Mycroft Holmes10-Jul-12 15:11

Mycroft Holmes

10-Jul-12 15:11

This is not a question!

I got caught by the parameter sniffing[^] issue the other day, it was a classic, I had built a proc that takes in 2 parameters, applies then against a bunch of tables and inserts the results into a table variable to return a summary of the current periods processing status.

It worked perfectly during development, ran like a dream (<10sec) during the first round of UAT. Then it spat the dummy and I was getting a timeout from the service, the procedure ran perfectly from SSMS but from the client it just refused to returned a result.

3 hours later having exhausted all probabilities the little bulb clicked, USE LOCAL VARIABLES. I was applying the parameters multiple times to different tables, by changing to a pair of local variables this fixed the problem, classic case of parameter sniffing.

Never underestimate the power of human stupidity
RAH

Oracle SQL Developer

vanikanc10-Jul-12 9:42

vanikanc

10-Jul-12 9:42

Hi,

I am having an issue with the selection list, which does not allow a selection of more than 1000 rows.

Like if I am trying to select more than 1000 rows, maybe the customer numbers, it does not allow more than 1000 rows. It comes back with this error message,
SQL Error: ORA-01795: maximum number of expressions in a list is 1000 .

I tried increasing the SQL array fetch size, and also increase the fetch size on the property window of SQL Developer but with no luck.

any help is much appreciate.

I need to update 4 million rows.

Thanks!!!

Re: Oracle SQL Developer

Michael Potter10-Jul-12 11:56

Michael Potter

10-Jul-12 11:56

I don't think it is related to the row count.

Google the error message and you will find numerous descriptions and workarounds.

Re: Oracle SQL Developer

David Mujica11-Jul-12 2:39

David Mujica

11-Jul-12 2:39

I bet you are building your query like this ...

SQL

select xx from myTable where ID in (val1,val2,val3)

The problem is that Oracle has a limit of 1000 values in their "in" clause. For example you can not have val1,val2,...val1001, Oracle will throw an error.

You need to restructure your "where" clause.

A possible solution would be to create a temp table and insert those selected values into the table, then do a join to the temp table.

Somthing just doesn't sound right if you are selecting 4 million rows, but you haven't give much information on the problem. Maybe more info will lead to a better solution.

Good luck. Thumbs Up | :thumbsup:

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