how to write sql scripts?
359358
The easy way to write a SQL script is to go into Access, create a query, and then view the SQL source behind it.
173834
Look up good books like C J Date, SQL For Smarties by Joe Celko or a site like\nhttp://www.learndatamodeling.com/
744551
**********************************************\nIn short MS SQL is a language used to manipulate databases via codes SQL meaning Structured (or Simple) Query Language\n\nMs Access is a WYSIWYG (what you see is what you get) Program to create databases\n**********************************************\n\nNOT SO SIMPLE...\n\nThe fundamental difference is that MSSQL is client/server RDBMS and Access is file-based. MSSQL has a server side component (databse engine) that always need to be running before you can connect to any databses and you need to get a client component (GUI e.g. SQL Enterprise Manager, query analyser, etc) in order to connect to the server component. Access is actually a Jet engine database and you use MS Access as the GUI. MS Access offers you excellent GUI tools to manipulate the data in the .mdb Jet database file. However, you can connect to access from other GUIs e.g. VB6 IDE. You can research on file based vs server based databases.\n\nBoth are SQL databases, which is by the way a language itself. The SQL standard describes a common language for manipulating and defining data in compliant database management systems. Thats how you can write a VB6 app for example which uses an access backend, and not need to have MS Access installed in order to access the data in the .mdb file.\n\njust google something like mssql vs access and sift through the results.\n\nhttp://www.cypressinland.com/access_vs_sql.htm\n\nThis is a good comparison (MSDE is scaled down SQL Server):\nhttp://msdn2.microsoft.com/en-us/library/aa140017(office.10).aspx
542676
SQL is used to look at and update data. The primary commands are SELECT, UPDATE, INSERT, DELETE. As programming topics go, basic SQL is as easy to master as anything.
361351
You can do this with ASP>net and SQl connection object.\nYou can also use Jav and JDBC
241790
C# is commonly used with SQL Server. Using this you simply need to add a reference at the top of your code:\nusing System.Data.SqlClient;\n\nThen use a SqlConnection, SqlCommand, and maybe a SqlDataReader. Set the connection up to reference your DB then create an SQL statement and execute the command. Then the DataReader will allow you to see each part.\nGood Luck!
96164
I suggest you use a DTS package, making a DTS (Data Transfermation Package), a function of the SQL Server, will\ngreatly simplify the task of getting data from Excel to SQL server. they can be saved and setup to run on a schedule or just used once. Great feature :)
117633
I'm only answering this because I haven't seen anyone else.  I'm not an Oracle DBA, but I have extensive experience in SyBase.\n\n1) Look through your doc for a thing called sqlloader - this is the thing Oracle provides to do the job.  Basically, unloading a table using sqlloader takes the data in your table and writes it in a format that sqlloader can rewrite.\n\n2) If you are really good at PL/SQL, you can write you own unload/reload process (this is what I have to do to move data from one RDBMS to another, like from Oracle to Sybase).  Write a program that generates as output the SQL Insert statements needed to load your data.  In other words, it writes on Insert statement for every row that already exists.
506681
write it yourself or find an open source solution.\nno one is going to research this, or write it for you.
664122
SQL Plus has its own system to put query in file.\nyou type 'ed' at SQL Plus prompt and notepad editor edits your querry.\nYou can save as query by selecting save as "All Files" then giving the file extention to .sql\nhope this will solve your problem.
54440
hi , you dont need cursor \ntry this:\n\n-----------------------------------------------\n\nCREATE PROCEDURE test_sp\n\n@username1char(10),\n@username2char(10)\n\nAS\n\nDECLARE \n\n@UserTempTableTABLE ([ID] char(10),\n [USERNAME] char(10),\n [NAME] char(10),\n [ADDRESS] char(10))\n\nINSERT INTO @UserTempTable\nSELECT[ID],\n[USERNAME],\n[NAME] ,\n[ADDRESS]\nFROM    Table1\nWHERE[USERNAME] = @username1\n\nINSERT INTO @UserTempTable\nSELECT[ID],\n[USERNAME],\n[NAME] ,\n[ADDRESS]\nFROM    Table2\nWHERE[USERNAME] = @username2\n\n\nSELECT [ID],\n[USERNAME],\n[NAME] ,\n[ADDRESS]\nFROM@UserTempTable\nGO\n\n-----------------------------------------------
521569
Construct your SQL statement from inside the SP and use EXEC command to run it. Suppose you have parameters @ColumnName, @TableName and @number, the SP is like this:\n\n-- declare the sql variable to hold the sql statement\nDECLARE @Sql Varchar(50)\n\n-- construct the sql command using your parameters\nSET @Sql = 'SELECT ' +@ColumnName +'+' +CAST(@Number As Varchar) +' FROM ' +@TableName\n\n-- execute the sql\nEXEC (@Sql)
511517
Does this help:\n\nhttp://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm\n\nhttp://www.quest-pipelines.com/newsletter-v7/0406_C.htm
1011783
Select {columns}\nfrom {tables}\nwhere {conditions}\n\nIt is the structure of a language meant to grapple with tables and columns instead of files and fields.
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?
588044
what about it \n\nmake the database  then make the interface ..
25643
I've included some helpful links listing SQL commands.  Note that some may depend on what specific database you're using (Access, MySQL, PostgreSQL), so you should check the reference for that product.