|
in my table i want to store the date only , but the problem is when i insert date only it automatically stores  it with the time 12.00.00 AM,
how can i store only the date ?
|
|
|
|
|
You can't store the date on it's own as any form of date type. Nor should you need to. If you really want to do this, you could store the date in a varchar field.
|
|
|
|
|
Pete O'Hanlon wrote: If you really want to do this, you could store the date in a varchar field.
You didn't write today's Daily WTF entry[^], did you?
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
Mike Dimmick wrote: You didn't write today's Daily WTF entry[^], did you?
 No - it's the main reason I advised him that there was no valid reason to do it. A date's a date's a date. Mind you, if he did store the date, it would (of course) had to be in UTC format.
|
|
|
|
|
If you really really need to do this then you can store it as an integer by converting dates as follows:
cast(convert(char(10),getdate(),112)as int)
Storing it as an integer will only take 4 bytes rather than the 10 bytes a char or varchar would take.
The beauty of this is that you can do comparisons between integer dates without having to cast the data first.
Regards
Guy
You always pass failure on the way to success.
|
|
|
|
|
Hi,
Using SQLSERVER 2000 I've written a stored procedure in which a piece of code is as shown below
Declare @tbl table (cardno varchar(20))
Insert @tbl
select cardno from carddata
select * from @tbl
Here @tbl is an array
When I execute the above code @tbl is getting populated with a list of cardnos.
Now I want to insert all the cardnos in @tabl into another table
Is there any method to do this, How to read an array in SQLSERVER 2000
Thanks and regards
|
|
|
|
|
Member 3057887 wrote: Here @tbl is an array
Actually, it is called SQL Table variable[^]. Not array.
Member 3057887 wrote: Now I want to insert all the cardnos in @tabl into another table
You can treat it like table. Try the following code.
Insert @tabl <br />
select * from @tbl
|
|
|
|
|
A very happy new year to all my friends
i m facing problem in SQL server 2000 , when i try to access it from client machine using Qurey Analyzer, it give error msg
"SQL server does not exist or Access denied"
BUT client can be access by the server.
These are the setting on client and server.
Server:-Windows2003server,SQL server 2000
Client:-Windows2000server,SQL server 2000.
Server is pinging from client using IP address.
Client is pinging from server using IP address.
At client, In SQL Server Netverk Utility AND SQL Server Client Netverk Utility Enable protocols are TCP/IP,Named Pipes.
At Server, In SQL Server Netverk Utility AND SQL Server Client Netverk Utility Enable protocols are TCP/IP,Named Pipes.
At server side database can be access using Qurey Analyzer and New SQL server Registrating is made from client database using IP address.
plzz help me how can i connect my client machine to server.
Thanks in advance
bye
|
|
|
|
|
Have you tried using like that "ServerName\SQLInstanceName"??
|
|
|
|
|
Yes , BUT still its not working
|
|
|
|
|
Hi guys i need ur help in query...,
If any one knows plz hep mw with query,
See i have 2 tables like this:
Table1:
Key Id name
1 100 Mag
2 101 Kum
Table2:
Id M1 M2
100 50 50
101 60 55
Now i want to that table1 "kum" Id want to 100 & "Mag" Id want to 101..,
So i want to do update the records using key in table1...,
While updating the table1 id and name..,
The changes have to update in Table2 records also (Id,m1,m2)...,
In this case if i update it will affect the both record in same table itself...,
so i need proper updation, How to do that?
Thanks & Regards,
Mageshh,
please don't forget to vote on the post
modified on Wednesday, January 02, 2008 7:21:51 AM
|
|
|
|
|
Hi all,
my table contains some records and a column is autonumbered.
I have to fetch records in a particular sequence for example (2,8,4,3,9)
SELECT * FROM myTable WHERE ID IN(2,8,4,3,9)
But sql server orders the records by the ID field(2,3,4,8,9). How to prevent this?
Thank You.
|
|
|
|
|
By default it will order by Primary key.....
If U Get Errors U Will Learn
If U Don't Get Errors U Have Learnt
|
|
|
|
|
vimal_yet wrote: By default it will order by Primary key.....
While SQL Server will generally order by the primary key, this cannot be relied on. If it sees an optimisation that results in a different sequence it will use that. However, you can override the final output by using the ORDER BY clause.
|
|
|
|
|
Member 4121511 wrote: But sql server orders the records by the ID field(2,3,4,8,9). How to prevent this?
You can use the ORDER BY clause to specify an order. However, it doesn't accept arbitrary orders, just orders things based on the column (or columns) you specify.
You could, however, provide a complex CASE clause in the SELECT statement that results in an increasing sequence of numbers that can be ordered in the way you want.
|
|
|
|
|
If you want to sort the output by 2,8,4,3,9 then you could use something like:
select * from MyTable
where ID in (2,8,4,3,9)
order by charindex(','+convert(varchar,ID)+',', ',2,8,4,3,9,')Regards
Andy
|
|
|
|
|
can i , with the help of sql queries , ascertain the next record ?
select next name from tablename
the above query does not exists in the real life .
Does such sort of query exist in sql server 2000?
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
Sonia Gupta wrote: the above query does not exists in the real life
Fetch next exists only in cursors.
Sonia Gupta wrote: Does such sort of query exist in sql server 2000?
Nope. Use your Primary Key to navigate between your records.
SG
Cause is effect concealed. Effect is cause revealed.
|
|
|
|
|
Next from what?
Records are not really ordered when they are stored in SQL server...
|
|
|
|
|
Hi,
i Want to know what are the important things i mean like (stored procedures ,triggers etc) i need to know while doing a project and which are also important for interviews
please do reply
sindhu tiwari
its me sid
|
|
|
|
|
U should know to write queries with joins and u also need to know abt exception handling other than Sp,Triggers....
If U Get Errors U Will Learn
If U Don't Get Errors U Have Learnt
|
|
|
|
|
will u plz suggest me some websites for this ....actually i know how to use joins triggers sp's and other things but i am not confident what i need is a perfect definations for all these
thank u for reply
Happy new Year
Regards
Sindhu tiwari (software developer MIS)
its me sid
|
|
|
|
|
|
vimal
a simple thing which i forgot ...help me out plz
i am having a table a datagrid view so i am displaying the data in that datagrid view now i want to update the table thru the datagrid view
so how to do this ...
if u know this then plz do let me know
regards
sindhu tiwari
its me sid
|
|
|
|
|
For this u need to code in front end languages like Dot net....
If U Get Errors U Will Learn
If U Don't Get Errors U Have Learnt
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
