Hello experts,
I want all the fields in a table and so I write :
Declare cursor_A cursor
for select * from table_A
open cursor_A
Fetch cursor_A
Now instead of showing the result on ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10328317.html
Hey!
I want to wrap this three steps in one transaction:
1. Insert values
2. Get the id of inserted row (last id)
3. Insert values
In code-behind getting the last id: SELECT IDENT_CURREN...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21728729.html
Hi experts
I have two tables. One has a list of email addresses (tblEmailDistinct, 3000 records) and the other (tblPersonDetails 3800) has name, address and email address details. tblPersonDetai...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23027580.html
Hello, I'm fairly new to Transact SQL using Microsoft SQL Server 2005. I have a select statement for a search in the users table. I'm setting the default values to '' so that if the user doesn't ...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23039914.html
Why would the first code snippet return 20 records (the correct number of records) but when I run the second code snippet on the same tables (the data in these tables is not changing from one run t...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23051021.html
this is a part of a time recording system.
I have a table which holds the allocated time for each day since 1.1.2007 (T440_SollZeit)
the following query returns a Value (%) of the allocated time ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23084358.html
MSSQL 2005:
A table holds some datafields declared as float.
When I display the data in the Enterprise Manager, the field value is e.g. 4.2.
When I start a query in the query analizer e.g. 'SEL...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2309...
Hi experts
I need to disable 3000 accounts. I have been sent a spreadsheet of users including a unique reference field for each. I would like to paste these unique numbers into a sproc, use them...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23094798.html
I have a Transact-SQL stored procedure, I have written, which returns results that include a datetime field. I am trying to use the DATEPART() function to parse out the field, so that the date tha...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23108558.html
Is there a more effective way to write this trigger in SQL Serer 2000. Very simply I want to effect the value of one (or more) of the columns that are on the same table. The problem I am having w...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23120002.html
