|
Great, thank you very much....
|
|
|
|
|
Hello
I need some good free e-Books or any Web Site Links for learn Stored Procedure....
N.Rajakumar B.E.,
Application Developer,
www.newdreamz.tk
|
|
|
|
|
|
U can even have a look at this KB article
http://www.dotnetspider.com/kb/Article1131.aspx[^]
All the best
"Aim to go where U have never been B4 and Strive to achieve it"
http://groups.yahoo.com/subscribe/dotnetforfreshres
http://himabinduvejella.blogspot.com
|
|
|
|
|
Hi all,
I have VS 2005 Professional, which comes with SQL Server 2005 Developer Edition. I'm in a crossroad thinking whether to install it or not.
Does ASP.net application requires SQL Server installed? Not that I'm developing asp.net, but I may need to in the future. I mainly do offline apps (Win32 /w C++).
Thanks.
|
|
|
|
|
It's not madatory that u only need Sql server
U many use Oracle .But any one database is must to store data in the back end
Sqlserver is the preferable one
"Aim to go where U have never been B4 and Strive to achieve it"
http://groups.yahoo.com/subscribe/dotnetforfreshres
http://himabinduvejella.blogspot.com
|
|
|
|
|
Hey,
Thanks for your reply. What I wanted to know is, do I really need to install SQL Server? I don't develop server-side apps, I mainly do client-side apps using Win32 /w C++.
|
|
|
|
|
SQL server is a powerful and robust data store. It is not required for development. ASP.Net apps can use any data store or none at all depending upon the application (just like Forms based apps).
Note: If you want to make a career in software development - learn to use a SQL database.
|
|
|
|
|
The SQL Server 2005 Developer Edition I'm going to install on my workstation is only for testing purpose, correct? When actually deploying the apps on a server machine, another copy of SQL Server 2005 should be installed there? Right?
|
|
|
|
|
Yes.
Note: My production enviroment has the SQL Server and IIS on seperate boxes. This gives more RAM room for each application.
|
|
|
|
|
Michael Potter wrote: Note: My production enviroment has the SQL Server and IIS on seperate boxes. This gives more RAM room for each application.
Wait a minute, so you're saying that the SQL Server and IIS don't need to be installed on my workstation machine? They could be on a remote server computer?
|
|
|
|
|
Yes, SQL Server can be anywhere on the network you want. You can even expose one directly to the Internet and access it from across the globe on the public internet (not recommended).
If you intend to develop ASP.Net applications, VS runs some kind of IIS based system when you are testing on the local box. This is a requirement unless you want to make your development really difficult.
SQL, on the other hand, is no more difficult to handle remotely as it is locally. The only thing that changes is the connection string. See http://www.connectionstrings.com/[^]
-- modified at 10:55 Wednesday 22nd March, 2006
|
|
|
|
|
Hey Michael, thank you for your reply.
|
|
|
|
|
If u are not storing naything inside database and using specifically client side applications then u don't really need to install it
U may have some other options for storage
"Aim to go where U have never been B4 and Strive to achieve it"
http://groups.yahoo.com/subscribe/dotnetforfreshers
http://himabinduvejella.blogspot.com
|
|
|
|
|
In case anyone is interested, a new Sql Intellisense addin for VS 2003/2005 was just released:
SqlAssist, www.roundpolygons.com[^]
Many features beyond just fast intellisense...
~Steve
|
|
|
|
|
Hi Steeve,
Thanks a lot 
"Aim to go where U have never been B4 and Strive to achieve it"
http://groups.yahoo.com/subscribe/dotnetforfreshres
http://himabinduvejella.blogspot.com
|
|
|
|
|
hi all
I have declare following variable in a function
DECLARE @strTemp VARCHAR(100)
SET @strTemp=(SELECT AiLine From Table1 WHERE id=1)
Now can I get the true Length of the '@strTemp' Value?
can any body please help me..
Thanks in advace.
|
|
|
|
|
DECLARE @strTemp varchar(100)
DECLARE @Length int
SELECT @strTemp = AiLine, @Length = DATALENGTH(AiLine) FROM Table1 WHERE id=1
|
|
|
|
|
that's worked..thanks....
|
|
|
|
|
Hi All,
Can anyone answer me this question.
Is there any restriction in the number of rows returned by a select command? Meaning that assume that I have over 1 million records in my table and I do a select from this table. Does my SQL Server 2000 restrict me by showing only first 1 lakh records or 2 lakh records etc etc. Does SQL has the capability of showing any number of rows returned by the SELECT command.
Thanks
|
|
|
|
|
hi,
you can use Top key word for that..
ex:-
SELECT TOP 1000 PDateFrom FROM dbo.Period WHERE FareAutoNum=@FareAutoNum
|
|
|
|
|
|
Subramaniam s.V. wrote: Does SQL has the capability of showing any number of rows returned by the SELECT command.
Yes, the limitation is on the client, can the client display that many records.
Beyond that why would you want to over whelm your use with 1 Million records? There is no way they could use that much information at once. It’s just better to break it down. Just my two cents.
-- modified at 6:42 Wednesday 22nd March, 2006
|
|
|
|
|
 I have Command but when it run "Incorrect syntax near the keyword 'FETCH'."
I want @sFunctionID = FETCH NEXT FROM GetaLl_FunctionID
but it error
Can U hepl me !
thanks !!!
DECLARE GetaLl_FunctionID CURSOR FOR SELECT FunctionID FROM SYS_Functions
OPEN GetaLl_FunctionID
--------------------------------------------------
Declare @i int
Declare @sFunctionID char(50)
SET @sFunctionID = (FETCH NEXT FROM GetaLl_FunctionID)
SET @i = 0
while @i < (SELECT COUNT(FunctionID) FROM SYS_Functions)
BEGIN
INSERT [dbo].[SYS_Funcs_FuncGroups]
(
[FunctionID],
[FunctionGroupID]
)
VALUES
(
@sFunctionID,
'GroupAdmin'
)
END
ClOSE GetaLl_FunctionID
AnhTin
-- modified at 21:56 Tuesday 21st March, 2006
|
|
|
|
|
FETCH NEXT FROM GetaLl_FunctionID INTO @sFunctionID
Christian Graus - Microsoft MVP - C++
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
