| |
| |
| |
|
Comments:
<0> Hi
<1> greetings
<0> I have a question about reg expression
<1> I am trying to implement a clickstream data warehouse in MS SQL. I have a table with IP addresses and their requests to the server. Was wondering if anyone can help me (or point in the right direction) identify a Session given a sucession of requests from the same IP address (and also first and last request).
<2> - I want to believe.
<3> is it possible to copy a database on the same sql server, or do I need to backup en restore the db to do that ?
<4> MS SQL?
<3> yes
<4> You might be able to do an DTS export of the entire database.
<4> Or as you said, backup, restore.
<3> stupid m$
<3> how do I clear all data in a table ?
<3> nevermind
<3> I have a table and some items in a column are by some strange way set to <NULL>, now I want to update them manually so they arecorrect. but I get a message : Key column information is insufficient or incorrect. Too many rows were affected by update.
<3> allthough I already update +-30 records right before these
<3> ??
<3> what can get the biggest ? numeric or int ? (it needs do be able to enable IDENTITY in ms sql server)
<3> and how big is big ?
<4> Google can tell you all of that.
<3> can't you ?
<4> I dont know on top of my head no.
<3> int : Integer data from -2^31 through 2^31 - 1
<3> numeric : Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1
<3> what does fixed precision mean
<3> and 2^31 is already 200000000000000000000 or something ? right ?
<4> 2147483648
<3> what is best to use for a ID ?
<4> I use Int for ID.
<4> Works for me.
<4> Depends a little on how many rows you are expecting.
<4> But 2147483648 is pretty much.
<4> And if this is MS SQL, you could use BigInt...
<4> But would use more space.
<3> yes that is a lot :)
<4> 2.147.483.648
<3> is that on length 4 or what does that mean ?
<4> oh, yea
<4> That the highest value.
<5> ONE MILLION ROWS
<4> ZOMG
<5> http://www.urbandictionary.com/zoom.php?imageid=46380
<3> zomg ???
<3> what is the z for ?
<6> howdy. i dont really if this is possible or not. with the order by clause ,can u specify more then one field? ie order by status,name?
<6> or something close?
<5> exactly that, order by a,b,c
<6> u know.. i love it when things are that easy :)
<6> thank u
<1> greetings
<4> Yo
<1> i'am trying to retrieve the earliest date from a column with "select min (date) from table" but i'm getting only the second earliest date (01/03/05) the earliest is (28/02/05). any thoughts about why is this happening?
<4> You could go another way.
<4> select top 1 date from table sort by date
<4> I am not sure why min() would give you the second earliest... Perhaps its confusing the m/d/y part?
<4> Since it can be in 5000 different ways, grrr.
<1> blackwand: thanks.. ill give it a try
<1> have the same answer.. :s
<4> uhu
<4> Might be that it interprets the date wrong.
<4> I dunno, really.
<1> sorry for the h***le.. it is interpreting it wrong...
<1> is interpreting as yy/mm/dd
<1> grrr
<4> Hehe
<4> Yea, it ****s.
<1> isnt there a way to specify how it interprets? or change the server way of interpreting?
<4> I believe its the server global settings.
<4> Regional settings.
<1> sorry i didnt say, but u ***umed right (i think) im using MS SQL
<4> ;)
Return to
#sql
or
Go to some related
logs:
#kl
#vb
1 baar aja aja aja
#worldchat
#chat-world
Query (SELECT * FROM .item_db)
#chat-world
muffdrive
zico on dalnet
cute pushi
|
|