| |
| |
| |
|
Comments:
<0> Hi! .. so anyone using sql 2005 to connect to sql 2000 via IP address?
<1> why would you need to do that?
<1> I should think you'd set up trusted connections
<0> cos my customers hoster is sql 2000 and my machine is upgraded to 2005 .
<1> uh-huh
<1> http://msdn2.microsoft.com/en-us/library/ms191260.aspx <== this might help you
<2> anybody here use sql server express? I'm trying to get a remote connection but I just can't get it to listen on port 1433
<3> hi, is there a query i can use to get the names of all the tables within a specific database?
<3> all the user defined tables.
<4> it depends on the DBMS yo have
<4> all of them differ by metadata location and schemata
<3> sql server
<3> 05
<4> XFMX-JUSTICE: select name from sysobjects where type='U'
<4> U = user tabel
<4> table even
<3> imap: that gives you table names of all user tables within a specific database?
<4> yes
<4> not specific, but current of your session
<3> hmm maybe im asking the question wrong.
<3> suppose i create a database named "test"
<3> and create 10 tables in there
<4> yes
<4> thats what you need
<3> what i need is the name of the 10 tables within database test
<4> but first you must do use test
<4> or having it default for your username
<3> ahh of course
<3> thanks for that
<4> bookmark this: http://www.databasejournal.com/features/mssql/article.php/3587906
<3> cheers!
<4> ;)
<4> March 1, 2006.. System Tables and Catalog Views By: Muthusamy Anantha Kumar aka The MAK
<5> helo
<5> i have a field in database with full name and i want to split that field to first name and last name
<5> anybody know how i can do that?
<4> uhm
<5> hi is that possible to split the field with full name
<5> i need to tranfer the data into new table
<5> also, anybody has created a database dictonary from sql server?
<5> what is the tool that we can use?
<4> what is between first name and last name?
<4> space?
<5> yes
<5> space only
<4> but space may be in lastname as well, right?
<4> somethins like John Jr. Brown
<5> well, the list of data that I have only has firstname space lastname
<5> nothing has middle name
<4> so the lastname is always 1 word only?
<4> ok
<5> yes for my data
<5> so the first word should be fistname and the last word should be last name
<6> www.w3schools.com/sql should be able to help you in that.
<4> jolmi
<4> here is an example
<4> select
<4> rtrim(ltrim(left(@string,PATINDEX('% %',@string)))) AS firstname,
<4> rtrim(ltrim(SUBSTRING(@string,PATINDEX('% %',@string)+1,len(@string)))) AS lastname
<4> from mytable
<4> replace all @string with your fieldname
<4> jolmi did it work?
<7> is there any way to combine to select statements and have the results back in 2 different fields a lot like a union except i dont want them in the same field
<7> like i need to do a select blah as blah from table where .. and select blah as blah2 from table where ... in the same query but not have them returned in the same field
<8> what wrong w/ a union?
<7> it returns everything in the same column i need each one returned in their on column
<7> what i need to do is select a bunch of items from the same field using different where clauses and return each of the items that match each where clause to its own column
<7> select distinct [c-ip] as blah from hits where contains([r-host], 'blah.com') union select distinct [c-ip] as blah2 from hits where contains([r-host], 'blah2.com')
<7> i wanna do that where it returns the first one with its name and the second one with its name but instead it puts them into the same column do you see what i mean?
<8> why not just union with some identifier
<8> select 'for blah.com', ... from ...
<8> union
<8> select 'for blah2.com', ... from ...
<7> wont that still return them in the same column
<8> yes, but you caan distinguish them
<9> somebody can tell me the best website for study sql command?
<10> what mssql?
<10> if it is mssql pressing F1 is ok
<11> weirdo` www.sql.org
<12> anyone?
<12> how do you prevent duplicate rows?
<12> UNIQUE prevents duplicate columns only, am i correct?
<13> hi all
<13> can anyone tell me what function in sql server SP i can use to round 1.2222 to 1.21 ? I am using Round(@Test,2) which produces this: 1.2100 - i want to get rid of the trailing zeroes... anyone know?
<14> Format() ?
<14> ##.## perhaps
<13> CAST(ROUND(REF_CustomerHeader.UnbilledBalance,2,1) AS DECIMAL(5,2)) AS UnbilledBalance <-- actually
<13> ugly but with the money datatype it appears that is required
<7> there any way not to show a data field in a chart in reporting services if the value is 0
Return to
#sql
or
Go to some related
logs:
mceggdrop
#allnitecafe
#india
noty boy
#php
#india
PARTH IS A NAUGHTY BOY
#allnitecafe
#chat-world
#allnitecafe
|
|