|
Try this
select DateCol from TableName where DateCol between '01/01/2007' and '01/01/2008'
|
|
|
|
|
How many primary key(s) can be set in SQL Server.
Actually i set primary key in 16 columns. Am i right if not please explain
Are Unquie keys and Candidate keys same. And how many Candidated keys we can have in a table
modified on Saturday, December 29, 2007 2:17:10 AM
|
|
|
|
|
Only one primary key per table. You can have as many foreign keys as you want.
Last modified: 22hrs 5mins after originally posted --
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Actually only one primary key per table, which can be composed of multiple columns.
|
|
|
|
|
I meant to write table instead of column 
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
i would like to create a column primary key and it's first three character id dll for example and 6 auto increment number so please help me
my email address is : adel.atef@gmail.com
thanks u in advance for that matter
|
|
|
|
|
there is no Aphalnumeric Primarykey with auto increment upto my knowledge.
u can manually do like as follows
SELECT MAX(CAST(SUBSTRING(id,CHARINDEX('-',id)+1,50) AS INT)) + 1 FROM TBL_Table WHERE ID LIKE 'DEF%' [this can be like ..."id like 'ABC%' to get highest value in ABC Sequence]
If U Get Errors U Will Learn
If U Don't Get Errors U Have Learnt
|
|
|
|
|
How about using a computed column?
CREATE TABLE dbo.FOOBAR<br />
( FOOBAR_ID bigint NOT NULL IDENTITY (100000, 1)<br />
, AN_FOOBAR_ID AS 'DLL' + CAST(FOOBAR_ID AS varchar(97))<br />
, FNAME varchar(100) NOT NULL<br />
, LNAME varchar(100) NOT NULL )<br />
GO<br />
<br />
INSERT INTO dbo.FOOBAR(FNAME, LNAME) VALUES('John', 'Doe')<br />
INSERT INTO dbo.FOOBAR(FNAME, LNAME) VALUES('Jane', 'Doe')<br />
GO<br />
<br />
SELECT * FROM dbo.FOOBAR<br />
SELECT * FROM dbo.FOOBAR WHERE AN_FOOBAR_ID = 'DLL100001'
|
|
|
|
|
Hi friends,
I have below salesreport table, how can I get results of max sales of sales persons in one query?
salesperson sales orderId
Michele 120 120121
Guido 230 120122
Michele 300 120123
Michele 250 120124
Franco 100 120125
Guido 500 120126
Franco 400 120127
the query result must be;
salesperson sales
Michele 300
Guido 500
Franco 400
|
|
|
|
|
select salesperson, max(sales) from salesreporttable group by salesperson
 Did you use to work in sales?
|
|
|
|
|
Chris Meech wrote: Did you use to work in sales?
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Please do not post on multiple forums.
I also answered your question on the C# forum.
If I had looked at this forum first I would not have posted on the C# forum - so you wasted about 30 minutes of my time(well it was a pretty tough question ).
Guy
You always pass failure on the way to success.
|
|
|
|
|
|
Hi All,
Can we create Database of Music Files using SQL Server 2000.
If yes please give an example, Or else what is the other option.
Thnx
Nitin Jenwal
|
|
|
|
|
Nitin.Jen wrote: Can we create Database of Music Files using SQL Server 2000.
Yes.
Nitin.Jen wrote: If yes please give an example
It depends what you ultimately want to do with the music files.
At its most basic:
CREATE TABLE MusicFiles
(
MusicFileId int IDENTITY(1,1) PRIMARY KEY,
FileName nvarchar(1024)
)
However, I suspect you want more than that. If you would like to give more details we can help you more.
|
|
|
|
|
Yes..U R right Sir..I want to create Asp.Net Page which plays music..just like raaga.com or dishant.com.
I want to make DB of Mp3 file.If you could give me the example of how the table will be and how to pass query to select and play that file in front end of Asp.Net page
Thnx
Nitin Jenwal
|
|
|
|
|
It depends on whether or not you want to store the file in the database itself, or use a path to the file. Without knowing this, there's not a lot anybody else can do for you, but I would suggest that at least part of your table should be a friendly name for the file that will be played. If you store the file on disk, then you should really consider storing it with a unique name (such as a GUID) so that it doesn't conflict with another file of the same name.
|
|
|
|
|
Wat is meaning of IDENTITY(1,1)....??
Nitin Jenwal
|
|
|
|
|
Nitin.Jen wrote: Wat is meaning of IDENTITY(1,1)....??
Seriously?
I put "IDENTITY(1,1)" into google and I got back this as my first hit![^]
|
|
|
|
|
U can insert any extension in the DB .you need to use the data type as image
If U Get Errors U Will Learn
If U Don't Get Errors U Have Learnt
|
|
|
|
|
Nitin.Jen wrote: Can we create Database of Music Files using SQL Server 2000.
Yes. It is pretty easy.
Nitin.Jen wrote: please give an example
Nope.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi,
How can i insert data saved in Excel file on Clientside into database on Serverside.
thanks,
|
|
|
|
|
In Enterprise Manager select:
Tools, Data Transformation Services, Import Data...
The wizard will guide you through the import.
Regards
Guy
You always pass failure on the way to success.
|
|
|
|
|
Thanks for your reply!
But my meaning is how to implement it in program based on B/S arch.
|
|
|
|
|
You could create a DTS package to read the excel file into a table.
The package could then be run from a job or stored procedure each time data from the spreadsheet needed to be imported.
Eric.W wrote: B/S arch
Can you explain to me what this is please?
Regards
Guy
You always pass failure on the way to success.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
