Database

FirstPrevNext

Procedure ArielR22-Mar-06 0:06 ArielR 22-Mar-06 0:06  How can I do to make a procedure that return the number of rows of any table.? ... @var int OUTPUT as.... Re: Procedure J4amieC22-Mar-06 0:12 J4amieC 22-Mar-06 0:12  Execute the following SQL Statement using ExecuteScalar SELECT COUNT(*) FROM MyTableName Re: Procedure HimaBindu Vejella22-Mar-06 0:39 HimaBindu Vejella 22-Mar-06 0:39  Run this procedure in Query Analyser CREATE PROC Usp_RowCount AS<br /> SELECT count(*) FROM fc_Employee<br /> Go "Aim to go where U have never been B4 and Strive to achieve it" http://groups.yahoo.com/subscribe/dotnetforfreshres http://himabinduvejella.blogspot.com Re: Procedure ArielR22-Mar-06 3:17 ArielR 22-Mar-06 3:17  Great, thank you very much.... Links for Stored Procedure Rajkamal_dfine22-Mar-06 0:02 Rajkamal_dfine 22-Mar-06 0:02  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 Re: Links for Stored Procedure HimaBindu Vejella22-Mar-06 0:47 HimaBindu Vejella 22-Mar-06 0:47  Stored Proc is a set of precompiled code already executed at database side It improves the performance of the applciation Nice article for beginners http://www.sqlservercentral.com/columnists/sburke/introductiontostoredprocedures.asp[^] One more link http://www.sqlservercentral.com/columnists/rmarda/nestingstoredprocedures.asp[^] "Aim to go where U have never been B4 and Strive to achieve it" http://groups.yahoo.com/subscribe/dotnetforfreshres http://himabinduvejella.blogspot.com Re: Links for Stored Procedure HimaBindu Vejella22-Mar-06 0:56 HimaBindu Vejella 22-Mar-06 0:56  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 What do you need SQL Server for? Link260021-Mar-06 23:19 Link2600 21-Mar-06 23:19  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. Re: What do you need SQL Server for? HimaBindu Vejella22-Mar-06 0:49 HimaBindu Vejella 22-Mar-06 0:49  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 Re: What do you need SQL Server for? Link260022-Mar-06 2:51 Link2600 22-Mar-06 2:51  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++. Re: What do you need SQL Server for? Michael Potter22-Mar-06 2:59 Michael Potter 22-Mar-06 2:59  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. Re: What do you need SQL Server for? Link260022-Mar-06 3:48 Link2600 22-Mar-06 3:48  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? Re: What do you need SQL Server for? Michael Potter22-Mar-06 4:10 Michael Potter 22-Mar-06 4:10  Yes. Note: My production enviroment has the SQL Server and IIS on seperate boxes. This gives more RAM room for each application. Re: What do you need SQL Server for? Link260022-Mar-06 4:15 Link2600 22-Mar-06 4:15  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? Re: What do you need SQL Server for? Michael Potter22-Mar-06 4:50 Michael Potter 22-Mar-06 4:50  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 Re: What do you need SQL Server for? Link260022-Mar-06 5:11 Link2600 22-Mar-06 5:11  Hey Michael, thank you for your reply. Re: What do you need SQL Server for? HimaBindu Vejella23-Mar-06 1:07 HimaBindu Vejella 23-Mar-06 1:07  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 Sql Intellisense Steve Schaneville21-Mar-06 19:53 Steve Schaneville 21-Mar-06 19:53  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 Re: Sql Intellisense HimaBindu Vejella21-Mar-06 20:00 HimaBindu Vejella 21-Mar-06 20:00  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 How to get size of Varchar variable? pubududilena21-Mar-06 19:39 pubududilena 21-Mar-06 19:39  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. Re: How to get size of Varchar variable? Scott Serl22-Mar-06 6:53 Scott Serl 22-Mar-06 6:53  DECLARE @strTemp varchar(100) DECLARE @Length int SELECT @strTemp = AiLine, @Length = DATALENGTH(AiLine) FROM Table1 WHERE id=1 Re: How to get size of Varchar variable? pubududilena17-Apr-06 17:36 pubududilena 17-Apr-06 17:36  that's worked..thanks.... SELECT Query Subramaniam s.V.21-Mar-06 19:33 Subramaniam s.V. 21-Mar-06 19:33  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 Re: SELECT Query pubududilena21-Mar-06 19:46 pubududilena 21-Mar-06 19:46  hi, you can use Top key word for that.. ex:- SELECT TOP 1000 PDateFrom FROM dbo.Period WHERE FareAutoNum=@FareAutoNum Re: SELECT Query HimaBindu Vejella21-Mar-06 19:57 HimaBindu Vejella 21-Mar-06 19:57  I think there is no restriction like that SQL has the capability of showing any number of rows returned by the SELECT command. U can check this link to get maximum capacity for sqlserver http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp[^] "Aim to go where U have never been B4 and Strive to achieve it" http://groups.yahoo.com/subscribe/dotnetforfreshres http://himabinduvejella.blogspot.com

Last Visit: 31-Dec-99 18:00     Last Update: 5-Jun-24 7:35 Refresh ᐊ Prev1...1935193619371938193919401941194219431944 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.