how to create stored procedure in sql server for entry level?
412903
Prabhu,\nPlease refer the MS Books Online. It has got all the answers to the questions you ask for.\nThanks,\nAnand
294743
These sites are great learning resources.\n\n\nhttp://www.softwaretrainingtutorials.com/ms-transact-sql.php
368518
This is one of many ways to do it. This is the most straight forward and assumes you know sql syntax & that you know your connection string:\n\nDim cn as New System.Data.SqlClient.SqlConnection()\nDim cmd as New System.Data.SqlCommand()\n\nTry\n     'set your sql connection string here\n     cn.ConnectionString = ""\n     cn.Open()\n     cmd.CommandText = "delete from [MyTable] where [MyRowID] = 123"\n     cmd.ExecuteNonQuery()     \nFinally\n     If cn <> Nothing AndAlso cn.ConnectionState = System.Data.ConnectionState.Opened Then\n        cn.Close()\n        cn.Dispose()\n     End If\nEnd
768463
You get database libraries for the 'C' language. For eg. SQL server has such a library, you can find some examples also. You can use standard API like ODBC, JDBC also.
479077
CREATE DATABASE [Database Name];\n\nWithout knowing the scope of your question, that is all there is to it.
1132417
Skip calling the stored proc and use a cursor to grab the rows directly and insert them into the second table.\n\nExample cursor:\n--------------------------\nDECLARE @col1_value VARCHAR(100)\nDECLARE @col2_value VARCHAR(100)\n\nDECLARE cc CURSOR FOR\nSELECT col1, col2\nFROM table1\n\nOPEN cc\n\nFETCH NEXT FROM cc INTO @col1_value, @col2_value\n\nWHILE @@FETCH_STATUS=0\nBEGIN\n\nINSERT INTO table2 (column1, column2)\nVALUES @col1_value, @col2_value\n\nEND\n\nCLOSE cc\nDEALLOCATE cc\n--------------------------
271292
Yes.\n\nhttp://www.microsoft.com/sql/prodinfo/sysreqs/default.mspx
1159711
Use sql servers enterprise manager
641087
Use Select Into option to migrate the data. You will need one select into statement for each of the tables.\n\nSELECT * INTO db1.dbo.table_name FROM db2.dbo.table_name\n\nHere dbo refers to database owner and db1 & db2 are the databases.
161373
You can get a free version of SQL Server 2005 (the "Express" edition) at the link below.\n\nIt will run fine on Windows XP.
227104
Microsoft Access might be a nice choice to start.  If you decide to go to something else, the database file itself can be easily converted to another database program, and it is compatible with SQL and ODBC
346060
just try going to this link\n\nhttp://www.w3schools.com/sql/sql_intro.asp\n\nmight help
520840
It would be helpful to know what version of SQL you want.\n\nFor Transact-SQL (Microsoft): http://msdn.microsoft.com\n\nFor MySQL: http://forums.mysql.com/\n\nFor PL/SQL (Oracle): http://education.oracle.com/
1115367
You can download SQL Server Express from Microsoft. It is a very good database server and works very well with the other .Net Express programs. There is a great wealth of information available on how to use it. Best of all, it is completely free to download, use and distribute.
168991
I am assuming you are the one asking the questions.  I have found that the biggest failing database developers have is not using the resources available for code samples. \n\nQ:  Where would you turn for help with creating a stored procedure or a select statement that was erroring out?
950543
there are lot of tools u can use to createa database it depends on the purpose as to why u want to create and what are u looking to do after that etcc....
241948
wrox publishing has a book called Begining ASP Databases, you would want the newer .NET version now:\nhttp://search.barnesandnoble.com/BookSearch/isbnInquiry.asp?z=y&isbn=076454375X&itm=1\nI learned with that and a book on SQL server specifically:\nhttp://search.barnesandnoble.com/BookSearch/isbnInquiry.asp?z=y&isbn=1861002319&itm=6\n\nIts a lot of fun, good luck!