Comments by CHill60 (Top 200 by date)

c.execute("INSERT INTO student VALUES(?,?,?,?,?)", my_data,)

A local temporary table created in a stored procedure is dropped automatically when the stored procedure is finished. The table can be referenced by any nested stored procedures executed by the stored procedure that created the table. The table can't be referenced by the process that called the stored procedure that created the table.

SELECT * FROM ...

acctnum(c1)    note (c2)   srno
12             abc          1
               efd          2
               xyz          3
15             pqr          4...etc

acctnum(c1)    note (c2)   srno
12             abc          1
12             efd          2
12             xyz          3
15             pqr          4...etc

WHERE @IDNO = idcard OR @IDNO = unicard

0 is SYAWLA
1 is KOOL
2 is on
3 is the
4 is THGIRB
5 is EDIS
6 is of
7 is !EFIL

upper(convert(char(3), datename(month, [OrderDate])))

AND p.wire= t.wire

A few simple rules when posting your question.
1. Be courteous. Everyone here helps because they enjoy helping, not because it's their job.
2. Have you searched or Googled for a solution?
3. Be specific! eg "How do I change the dialog colour?" instead of "My code doesn't work. Help?"
4. Tag your question appropriately.
5. If you have a school or university assignment, assume that your teacher or lecturer is also reading these forums.
6. Do not remove or empty a message if others have replied.
Your question may be edited or retagged by others. Anything inappropriate will be removed.

If TypeOf (cTrl) Is ComboBox Then ...

;with Q1 as

WHERE ColumnName IS NOT NULL

WITH with1 AS (***),
with2 AS (***)
SELECT * from with1
UNION
SELECT * from with2;

...
Driver.Get etc
Dim i As Integer
For i = 1 To 10
     Driver.Actions.MoveByOffset(5,1).Perform
Next<pre>I.e. only move the mouse by 1 point but do it 10 times in a loop so it's the equivalent of <pre>Driver.Actions.MoveByOffset(5,10).Perform

declare @languages table(langID int identity(1,1), langName nvarchar(50));
insert into @languages(langName) values
('english'),('french'),('german');

declare @formtext table(itemID int, formtext nvarchar(50), langID int)
insert into @formtext (itemID, formtext, langID) values
(1, 'forename', 1),
(1, 'prénom',2),
(1, 'vorname',3),
(2, 'surname', 1),
(2, 'nom de famille',2),
(2, 'nachname',3);

declare @userLang nvarchar(50) = 'french';
declare @phraseRequired nvarchar(50) = 'forename'

select @phraseRequired, t1.formtext
from @formtext t1
join @languages t2 on t1.langID = t2.langID and t2.langName = @userLang
join @formtext t3 on t1.itemID = t3.itemID and t3.formtext = @phraseRequired