If have a field in a table, say it is named tbl_test. This tbl_test has a field latest_Update which is a date.
I want to do an if statement in another sql query something like this. Meaning tha...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23137837.html
I have a table with 3 fields that are key's (say a, b and c)
I have another table (table2) where I have the same keys, but it contains only a subsete of the fields.
what I want to do i s to up...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23165380.html
I would like to change db owner on a DB that i restored. I ran the following and it doesn't work.. Any ideas? Owner is currently called odbc and i would like to replace it with dbo
EXEC sp_ch...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23297648.html
Hi folks,
I have a database table named tblsales.
I want to create a stored procedure that will take two input parameters.These are @Year and @week.
When I enter these two parameters then stored...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23311311.html
Zones:
MS SQL ServerDate Answered: 04/10/2008 Rating: 7.0 Views: 0
How do I get a secondary COUNT in an SQL query?
I have a table called ITEMS as shown below. I have an SQL query with a GROUP BY giving me a report, but I need more detail in the report.
What SQL...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23445796.html
Zones:
SQL SyntaxDate Answered: 05/31/2008 Rating: 9.6 Views: 4
How do I write an SQL-query that generates these results:
OrderID UserID UserName
--------- ----------- --------------
010101 ASMITH Anthony Smith
010200 (null) (null)
from ...
http://www.experts-exchange.com/Database/Miscellaneous/Q_10019262.html
Zones:
DatabasesDate Answered: 08/06/1997 Rating: 6.6 Views: 5
Hi Guys,
Inside a PL/SQL procedure I am doing lot (couple od millions)of inserts. Is there a way to speed up this inserts??. Here is the sample PL/SQL block
...procedure
declare cursor (some quer...
http://www.experts-exchange.com/Database/Oracle/Q_10038946.html
Zones:
OracleDate Answered: 02/12/1998 Rating: 5.6 Views: 0
How to connect VB5 with SQL server 6.5 and proceed with the process without aNY PROBS?If any of u could explain clearly.
It is urgent please.
http://www.experts-exchange.com/Database/Miscellaneous/Q_10043942.html
Zones:
DatabasesDate Answered: 05/01/1998 Rating: 6.6 Views: 0
I have a SQL Server problem.
I am using a TTable connected to a TDatabase all on a data module.
When connected to a paradox database table with the following structure,
the code works.
TABLE STR...
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_10053740.html
I would like to set up a web site, which is very similiar to discussion groups. in a given moment, there could be maximum 100 users connected to my server. When they login to the server or do some ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10055368.html
Zones:
MS SQL ServerDate Answered: 06/22/1998 Rating: 6.2 Views: 0
