siva 20997 (3/6/2012)

---

#aTabale should be dataTable

my find and repalce gave that problem

here is the corrected code

CREATE TABLE #a (id INT PRIMARY KEY, name VARCHAR(20), igroup INT)

INSERT #a VALUES (1,...

Here how you can do it with calendar table:

-- just small calendar table which has week_day's for 2012

-- YOU WILL BE BETTER USING A PROPER ONE!

select cdate, datepart(weekday,cdate) week_day_no, DATENAME(weekday,cdate)...

oops, can see your try now...

Comments removed.

Gianluca Sartori (3/6/2012)

---

In my experience, DB2 on z/OS is often used without indexes and has "logical views" to...

Also, back to the question: UNIQUE NOT NULL vs PRIMARY KEY

PRIMARY KEY term has the clear definition -it's contstraint

But "UNIQUE NOT NULL" what do you exactly refer to?...

If so, may be legacy DB2 database has some unique idexes?

Much better now!

So, what else we can add:

1. they differ in purpose:

We are using PK for referential integrity (when paired with FK)

While UNIQUE NOT NUL index(key) we use...

Exactly right! Have you tried to google for the title you gave to the post?...

If you use sp_executesql with parameters, there are no risks of SQL Injection and dynamic SQL is safe to...

Just an idea:

CREATE TABLE [dbo].[MyTable](

[id] [int] IDENTITY(1,1) NOT NULL,

[realvalue] [varchar](50) NULL,

[firstChar] AS (left([realvalue],(1))),

CONSTRAINT [PK_MyTable] PRIMARY KEY CLUSTERED ([id] ASC)

)

GO

CREATE TABLE dbo.SpecialCharSort (SpecialChar char(1), sortOrder int)

insert dbo.SpecialCharSort

values ('!',...

guerillaunit (3/5/2012)

---

I wanted to know if it was possible to subdivide the statements into separate scripts. But it sounds like it's not possible with the GO statement since it...

Please provide setup of data for each of the rule you've listed, so we can see exactly what your rules are.

You don't need to set a variable @location for thing you are want to do.

Create a UserLocation table which will hold all locations per user:

-- just an example, you want...

Stefan Krzywicki (3/5/2012)

---

I want to store currency symbols in a table. I checked the official unicode page[/url] for the unicode character codes for currency symbols. For example, the Euro symbol...

Cadavre (3/5/2012)

---

I have no idea what you want me to send you. What "standard sql tutorial"...