sql command with to criteria?
99695
What do you mean?\nMaybe "SQL command with two criteria?"?\n\nIn this case if you mean the condition "WHERE" you joint each condition with "AND".\nExample:"SELECT * FROM table WHERE field0 = 'value0' AND field1 = 'value1';"
180876
no idea how in your language, but....\n\nin SQL server there is an execute() function that will execute the script, maybe there is one in your language:\n\ndeclare @SQL varchar(2000)\ndeclare @mytable varchar(20)\nset @mytable = "TheTable" \nset @SQL = "Select column from " + @mytable \nexecute (@SQL)\n\nis equivalent to: \nSELECT column from TheTable\n\nthis is sometimes refered to as dynamic SQL since it is not known until runtime
1184103
select fld*10+sld*20+tld*30 from table where (fld*10+sld*20+tld*30)=230
930099
I'll give you an idea of the first one so you can learn how to do this yourself.\n\n1. Find the names who directly supervised by Franklin Wong\nselect * from SomeTable where SupervisedBy='Franklin Wong'\n\nThe rest are no different they are all select statements.\nutilising <, >, =, or, and to develope the sql query
272795
Please clearify your question.  This doesn't make much sense.\n\nSounds like you'll need to use a SELECT..CASE or an IF..THEN.
1100890
you should use an sql connection object from the component toolbar n make a connected architecture.. and then drag n drop an sql command object . in that object's property set type = stored procedure and then proceed. it's as simple as that in visual studio..\nin query builder u'll get the type as : create procedure <> as.... GO.\nthen in ur code for d form write:\nSqlCommand cmd = new SqlCommand (<proc.name>, <connection name>);\ncmd.CommandType=CommandType.StoredProcedure;\ncmd.Parameters.Add( new SqlParameter("@<pname>",<type>,value,<col name>));\ncmd.ExecuteNonQuery();\nhope thiswill work for u?
1018112
trying adding a distinct clause.  Select (distinct) from...  what's your query.
1106469
Use the 'Query Analyzer' in Acess to select each field from each table then go to SQL view to copy and paste the SQL code you need.
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--------------------------
1011647
My coldfusion is pretty rusty (php guy now) but the first question that comes to mind is, rather than use 2 seperate queries, why not use one?\n\nTry SELECT * .... etc\n\nWHERE order_ID = (SELECT MAX(order_ID) FROM Orders)\nORDER BY ... etc.\n\nThis is called a subquery or correlated subquery.  Most SQL databases support the idea.
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.
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.
1062183
We're going to call your row "numbers" and your table "table" for this example.  The SQL code would look like this:\n\nSELECT SUM(numbers)\n   FROM table;\n\nThere you go.
621012
sql stands for sequentia query language\n\nif you want to delete some row from a table\n\ndelete * from tablename where <columnname> = 1\n\nor if its character\ndelete * from tablename where <columnname> = 'dd'\n\nif u want to delete entire table\ncommand will be\n\ndelete * from <table name>
404062
(m)\n\ngoto the following link for logic sql commands\n\nhttp://docs.hp.com/cgi-bin/doc3k/B3060190208.12319/75
10408
for this u can do one thing thatu will go database menu and click show sql query and add where\n 'Field name ' = today or now as per as ur requrement.
396944
Access 97 supports only limited SQL queries. Most of these can be generated with the query designer functionality in Access, but if you want to access the database using more advance SQL commands, try writing a VB program to do it and use an OLEDB jet connection. Then you get whatever functionatily you want on it.\nGood luck!