|
|
| how to update from 2005 Express to 2008 Express |
| I have SQLServer Express 2005 on my machine, with 3 or 4 databases that need
to be ported, and I want to migrate to SQLServer Express 2008. What would be
the best way to do this?
I would think: 1) m... on 19-Nov-09 |
| |
|
| Transact SQL / SQL with Parameters Newbie Question |
| I run a website written in ASP (VBScript). I have been trying to teach myself using SQL
with parameters so I can head off some SQL injection attacks (that so far I have been
successful in stopping). ... on 18-Nov-09 |
| |
|
| update table question |
| MSSQL 2005
I have this script that updates items in a table A if the codeID are equal
in table B. However, I also need to add any records to table A if there is a
record in table B that does not cur... on 18-Nov-09 |
| |
|
| SQL2005 Mail Help |
| SQL 2005 SP3 on Windows 2003 SP2 Server
Using the DB Maint Plan Wizard I setup a operator to send status reports to
my email account the Select Report Options screen is where you choose the
Email rep... on 17-Nov-09 |
| |
|
| how to create my select statement |
| I have a table (tbl_work) which contains these fields
Work_id (Primary Key)
Opportunity_id (Foreign Key)
Work_description
Work_type_code
Work_dt
State_id
I want to create a view with this result:
W... on 16-Nov-09 |
| |
|
| Running a script |
| How do I run a script that will make tables in sql server? Do I run it from
my browser? Or maybe go into Sql Server Management and go to query, and
paste it in there and run it?
Sign me - Clueless
... on 16-Nov-09 |
| |
|
| Tempoary Variables in Stored Procedures |
| Hi all,
I am trying to create a procedure that contains a temp variable that I can
use further in the procedure, so that I can use the result from the first
query in the second query:
SET ANSI_NULL... on 13-Nov-09 |
| |
|
|
|