Citability Codeathon - DC - April 9 - 11 2010 - Database Discussion Boards

Nvarchar stores unicode characters which means you don't have the problem with different codepages in different countries. But it also uses twice the space.
If you need to store characters from several alphabets in the same field you really will like nvarchar.

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

multi language benefit, but space cost...got it, thanks!

Heres another one, SQL Server CE ONLY supports nvarchar, nchar etc so if you need to use CE then you know the requirement. Also does not support stored procedures Dead | X|

I am currently bleeding from this particular bite me!

Never underestimate the power of human stupidity
RAH

VARCHAR is a variable length string of ASCII characters while NVARCHAR is a variable length string of UNICODE characters.Since NVARCHAR can handle unicode characters, so it allows to use multiple languages in the database.

Each ASCII character takes one Byte of space while each UNICODE character takes two Bytes of space. It means NVARCHAR takes twice as much space to store to allow for the extended character set required by some other languages.

modified 27-May-14 4:40am.

hi all,

i have developed an application in vb.net with Mssql Express 2008 which has about 600 store procedures and 200 tables. All are working fine.

now i want to install me app to my client (end user) and want to hidden my database from any one other than me.i know how to encrypt a sp.

my problem is how i encrypt 600 SPs. if i do it one by one it will be a very big job.

kindly suggest me suitable solution.

Thanks

rmshah
Developer

If you know how to encrypt a proc then write a script to encrypt each proc in your database, it is a simple loop process.

Get a list of procs from the system information_schema views!

Never underestimate the power of human stupidity
RAH

Thanks for reply,

Kindly suggestexample codes.

Thanks

rmshah
Developer

Please join Microsoft and the League of Technical Voters at a 2-day codeathon event! We are hosting this event at the Microsoft Chevy Chase office in the DC area during the weekend of April 09 through 11 (please see attached flyer). The focus of this event is on making government documents more accessible and citable; we have provided more information on citability below. You can learn more about the event at http://dccodeathon.com and register at: http://dccodeathon.eventbrite.com.

Event Details
Programmers and designers will gather to work all weekend to create live demos to showcase Citability. Access Please sign up to attend at http://dccodeathon.eventbrite.com so we can reserve your seat!

Date: April 9 – 11, 2010
Time: April 9, 7:00PM – April 11, 6:00PM EST
Location: Microsoft Office
5404 Wisconsin Ave, Suite 700
Chevy Chase, MD 20814
(301) 771-8000

What to Expect
Come and see some of our exciting new projects – here is a peek at some of what you can expect:
• View new video annotation tools so people can cite a specific part of a video and can also tag those citations with different levels of access to annotate.
• Demonstration of how to archive, version and cite live changing datasets while using a minimum amount of storage space.
• See how archive servers can be cloned to other organizations where they can separately add their own annotations.
• Explore how our archive server can help divergent agencies share data more easily.
• Proposed integration of existing citation standards like Dublin Core, URN:LEX, and microformats.

Participant Preparation
We encourage participants to work on some relevant projects prior to the codeathon and showcase them at the event itself. Please visit our online wiki at http://dccodeathon.pbworks.com/Project ahead of time, choose a project and start designing. When it's Codeathon weekend, you will only have time left for coding! On Sunday you can showcase your applications to representatives from government agencies and media in attendance. Please feel free to add your own project here! Some of the relevant technical skills for participants would include:

1. ASP.NET, HTTP/REST, JavaScript, micro formats
2. Windows Azure (PHP and other OSS technologies on Azure a plus)
3. SharePoint 2010/2007
4. Open source technologies, e.g. PHP, Python, R-on-R

Background & Overview on Citability
Citability is an important step to promote informed participation by the public and increase governmental transparency and accountability. In keeping with the tenets of the January 21, 2009 Presidential memo on Open Government and transparency, the objective of Citability.org is to web enable publicly available government documents and make them citable at a paragraph level, allowing citizens to cite governmental documents on a useful, unique level.

Citations can be as simple as linking to a specific paragraph in a policy by a blogger or as complex as a group of attorneys and judges debating a regulation. Imagine the level of community participation an advocacy organization could create by having an authoritative source for budget line items! Or the support a nonprofit could receive by pointing to specific budgetary links to available funding sources for its cause or perhaps justify to its constituency why their donations would help more.

Most Government officials we have spoken to are extremely supportive of the concept of Citability. The importance of citations to show accuracy & authority is well understood. Often, the concern is about cost! The League of Technical Voters and Microsoft are therefore thrilled to support this event to create free and open source code to demonstrate that Citability does not have to be expensive to be feasible.

Event sponsored by Microsoft and the League of Technical Voters.

You should probably post this in the Get-Togethers[^] forum. It certainly has little or nothing to do with databases.

Chris Meech
I am Canadian. [heard in a local bar]

In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]

I have a field in an access database called day and is declared as DATE/TIME

I want to find through SQL all records with dates between 01/03/2010 and 15/03/2010

When i sent the sql command

'Select * from journal1 where day between 01/03/2010 and 15/03/2010'

it does not work.

Even if i try 'Select * from journal1 where date(day) between 01/03/2010 and 15/03/2010' it doesn't work.
I am almost sure that the problem is because the day includes also a time portion in it, but if i put date(day) shouldn't this be working ?

Thanks.

Use # to delimit date:

Select * from journal1 where day between #01/03/2010# and #15/03/2010#

However, I am not sure how to tell Access if it is mm/dd/yyyy or dd/mm/yyyy. If you can use a parameterized query command, this will be easier.

If the column name is "day" you will most likely need brackets as in [day].

Well using # worked, but actually it expects the date to be completely reversed.

So if i use 'select * from journal1 where day>#15/03/2010#' it doesn't get any results, but if i use 'select * from journal1 where day>#2010/03/15#' it is working.

Is it possible to change this ?

Thanks.

Hi,

I have a nchar type in my sql with this kind of value '02 12', it stands for February 2012, is there a way that i can convert this value to DateTime data type in sql server.

i was tring these, but none of them are working:
*. select convert(DateTime, '02 12')
*. select cast('02 12' as DateTime)

any help will be greatly appreciated.

Not a chance, datetime requires a minimum of d/m/y. I would pad it out with something to end up with valid date information. Pick and arbitrary day, 1 or 15 and concat the string then use a date mast to convert it. Look ad convert/cast it will give you the mask types.

Never underestimate the power of human stupidity
RAH

You will have to convert your string in a valid datestring first. This should work:

declare @d as nchar(5)

set @d = '02 12'

select Cast('20'+ Right(@d, 2) + Left(@d,2) + '01' as datetime)

Wout Louwers

Hi guys,
I have a problem when synchronizing web publication.
I begin by giving you an insight into my soft installed:
sql-server 2005
7even-windows so IIS7.5
I created a publication MaPublication.I made a right click on publication-> Release Local> MaPublication then I chose to configure synchronization Web.Then, next-> sql server mobile-> created a new directory select default website ->next->in Alias: SQLCE-> 2 messages appear successively OK OK-> next-> clients connect anonymously-> next-> OHH now when I click on the Edit tab to change a user account error message appears:
The program can not open the required dialog box because no location has been found.Close this message and try again
What is the problem? Is it a problem IIS??
Thank you for your contribution
Note: the MSDN help don't help me anymore so another propositions

modified on Tuesday, March 16, 2010 1:03 PM

Hi Friends,
How to get a web page view source using sql stored procedure and then view source should be saved as a record in a table. Kindly please help me?

Thanks & Regards
Senthil Kumar.T.S

Getting the HTML source should be the job of your server side code and not the stored procedure.

Web page source is unassociated from SQL server unless you've got one really funky setup. Please elaborate on what you mean.

Hi Members
How to insert data in BFILE Data Type and retrieve data from BFILE Data Type?
Please help me

See here[^].

Me, I'm dishonest. And a dishonest man you can always trust to be dishonest.
Honestly. It's the honest ones you want to watch out for...

thanks for response

But how can i retrieve data through command.Please help me

Do a search on the internet. There is tons and tons of information available.

By looking at the examples, I believe you will need to use a streamwriter.
Go through this article here[^].

Me, I'm dishonest. And a dishonest man you can always trust to be dishonest.
Honestly. It's the honest ones you want to watch out for...

ok i search on net but i havn't found any running example.It may be my fault to understand.But before i ask question i always use google after that i ask question in forum.

Now you give me link.There is only i found create table and insert data into table through JAVA CODE.But i need simple use command in oracle(SQL*Plus).
Can you give me small example

Please help me