Re: Know the Database version - Database Discussion Boards

First Prev Next

Re: How to mapp three tables

Paul Conrad1-Aug-08 9:34

Paul Conrad

1-Aug-08 9:34

What have you come up with so far?

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Know the Database version

Sritanu _ Ghosh31-Jul-08 21:41

Sritanu _ Ghosh

31-Jul-08 21:41

Hi,I am new comer of sql server2005.How can I know the database version through query.Pls help me

Re: Know the Database version

Vimalsoft(Pty) Ltd31-Jul-08 23:05

Vimalsoft(Pty) Ltd

31-Jul-08 23:05

SELECT @@VERSION

Next time i will not give you an Answer, you must First Google before you post here on the Forum.

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

Re: Know the Database version

Sritanu _ Ghosh1-Aug-08 0:46

Sritanu _ Ghosh

1-Aug-08 0:46

I know this query.By this I know the version of sql server.Can I know the version of master database or user create database version.

Re: Know the Database version

Vimalsoft(Pty) Ltd1-Aug-08 1:54

Vimalsoft(Pty) Ltd

1-Aug-08 1:54

hi I dont Understand what you want.

Forum: SQL and Database discussions 
Subject: Re: Know the Database version 
Sender: Sritanu _ Ghosh 
Date: Friday, August 1, 2008 2:46 PM

Does a Database have a Version ?

Am not sure what you want. ok

Re: Know the Database version

Syed Mehroz Alam1-Aug-08 3:31

Syed Mehroz Alam

1-Aug-08 3:31

Vuyiswa Maseko wrote:
Does a Database have a Version ?

I think he wanted to ask the compatibility level(SQL 7.0/2000/2005 etc).

Here's the GUI process:
In the management studio, right click on the db -> select Properties -> click on Options -> the Compatibility Level is displayed along with the collation and recovery model.

But I dont know how to retrieve it using T-SQL.

Syed Mehroz Alam.

My Articles

Re: Know the Database version

Vimalsoft(Pty) Ltd1-Aug-08 3:35

Vimalsoft(Pty) Ltd

1-Aug-08 3:35

i was Suprised , lets hear if this solves his Problem. Smile | :)

Thanks

Re: Know the Database version

leoinfo1-Aug-08 6:46

leoinfo

1-Aug-08 6:46

Is this what you are looking for ?

SELECT name, compatibility_level FROM sys.databases

Please... SAVE my time by rating the posts that you read!

There are 10 kinds of people in the world: those who understand binary and those who don't.

initcap problem

jhyn31-Jul-08 16:01

jhyn

31-Jul-08 16:01

Please help...

Is there a way when I use initcap to make any letters displayed after an apostrophe be lowercase?

thanks in advance!

Triggers

ROC_Jnr31-Jul-08 10:03

ROC_Jnr

31-Jul-08 10:03

Please i need help...
Can somebody explain me how can i implement an insertion trigger that inserts in another table.
Like i have one table wich i want to insert a new record but when i insert a record in the first table the same record must be inserted in an another table for security...
By the way im using sql server 2000 in this project.
Thanks

Sorry about the english, i speack portuguese Smile | :)

....

Just learning

Re: Triggers

Wendelius31-Jul-08 10:17

Wendelius

31-Jul-08 10:17

Hi,

You would need something like this:

CREATE TRIGGER Duplicate ON TableName
AFTER INSERT AS
	INSERT INTO AnotherTable (Column1, Column2...) SELECT Column1, Column2... FROM inserted
END

Mika

Re: Triggers

nelsonpaixao1-Aug-08 13:49

nelsonpaixao

1-Aug-08 13:49

Oi,

Eu já fiz algumas bases de dados e nunca precisei á data, de usar triggers (em sql).
Mas queres inserir dados ao mesmo tempo em duas tabelas? Porque não fazes isso com uma store procedure normal, achas que não dá para isso?!
O que tens na ideia? talvez te possa ajudar. Cool | :cool:

[Message Deleted]

naveenxyz31-Jul-08 10:02

naveenxyz

31-Jul-08 10:02

[Message Deleted]

Re: sql query

Kschuler31-Jul-08 10:14

Kschuler

31-Jul-08 10:14

We need to know what the data looks like in your file and exactly what you want when you are done with your query. It sounds like you do not have much experience with SQL so I'd suggest taking a look at some of these sites to get some basic knowledge:
SQL Tutorial[^]
SQL.org[^]
Another Tutorial[^]
Google list[^]

Another IN clause Question

MaxRelaxman31-Jul-08 5:14

MaxRelaxman

31-Jul-08 5:14

I'm having some issues with a Query I'm trying to use to fine similar records in a master table. There are several child tables that will be searched in a similar way. Basically, if there are more than two matches in the sub query I want to display those records.
Can anyone point me in the right direction to get this query to work? I understand why I can't use more than one field in my subquery but I can't think of another way to do this.

SELECT *
FROM   UC
WHERE uc_key IN (SELECT mo_Key, COUNT(mo_key) as KeyCount 
		 FROM MO  
		 WHERE (mo_MoKey = @Key1 AND mo_Value = @Value1) OR (mo_MoKey = @Key2 AND mo_Value = @Value2) <- there will be a variable number of these that get generated programatically
                    AND KeyCount > 2)

(note, the table names have been mangled to protect the innocent)

Thanks, any ideas are appreciated.

Re: Another IN clause Question

PIEBALDconsult31-Jul-08 6:44

PIEBALDconsult

31-Jul-08 6:44

You probably still want a JOIN; avoid using IN for anything other than literal lists.

Re: Another IN clause Question

MaxRelaxman31-Jul-08 10:52

MaxRelaxman

31-Jul-08 10:52

Using a JOIN will improve speed?

Re: Another IN clause Question

PIEBALDconsult31-Jul-08 10:54

PIEBALDconsult

31-Jul-08 10:54

It has in my experience. And much more flexible.

Re: Another IN clause Question

MaxRelaxman31-Jul-08 10:56

MaxRelaxman

31-Jul-08 10:56

I'll have to experiment in that direction then. This is a nasty complicated app and I'll need all the little speed boosts I can get.

Thanks!

Re: Another IN clause Question

PIEBALDconsult31-Jul-08 11:06

PIEBALDconsult

31-Jul-08 11:06

I can imagine. Your first task should be to eliminate the subqueries; they don't benefit from indices.

I had to change some of my JOINs the other day because the statements seemed to just sit there, now they zip along.

Re: Another IN clause Question

Wendelius31-Jul-08 6:48

Wendelius

31-Jul-08 6:48

Hi,

Didn't test this so there may be typos but try something like this:

SELECT *
FROM   UC
WHERE uc_key IN (SELECT mo_Key
		FROM MO  		 
		WHERE 	(mo_MoKey = @Key1 AND mo_Value = @Value1) 
		OR	(mo_MoKey = @Key2 AND mo_Value = @Value2) 
		GROUP BY mo_Key
		HAVING COUNT(*) > 2);

Hope this helps,

Mika

Re: Another IN clause Question

MaxRelaxman31-Jul-08 10:54

MaxRelaxman

31-Jul-08 10:54

Excellent, thank you for your help!

One thousand internet dollars are coming your way, just put your ethernet cable into the trash can can to catch it all.

Query using multiple columns in IN Clause

CodalcoholicNBrainy31-Jul-08 1:17

CodalcoholicNBrainy

31-Jul-08 1:17

Hi Everyone,

I am having one table which contains 5 columns. These five columns together contitute the primary key. I am having one more table which contains data for these primary key. I need to write a query which will bring the data from the second table for those primary keys which are available in first table. D'Oh! | :doh:

CodeManiac
xxxxxxxxxx
xxxxxxxxxx

Re: Query using multiple columns in IN Clause

Syed Mehroz Alam31-Jul-08 1:23

Syed Mehroz Alam

31-Jul-08 1:23

If I understand you correctly, you just need a simple inner join.

Select ...
From YourPrimaryTable
InnerJoin YourDetailTable
  on YourPrimaryTable.Column1 = YourDetailTable.Column1
  and YourPrimaryTable.Column2 = YourDetailTable.Column2
  ...

Hope that helps.

Syed Mehroz Alam

My Articles

Re: Query using multiple columns in IN Clause

CodalcoholicNBrainy31-Jul-08 1:40

CodalcoholicNBrainy

31-Jul-08 1:40

Thanks for your reply. Big Grin | :-D

Can we do the same thing without taking join. I mean can we use IN clause for multiple columns?

CodeManiac
xxxxxxxxxx
xxxxxxxxxx

Last Visit: 31-Dec-99 18:00 Last Update: 28-Apr-24 14:10

Refresh

ᐊ Prev 1...1101 1102 1103 110411051106 1107 1108 1109 1110 Next ᐅ

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