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: 9
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
Is there a system table in Microsoft SQL Server 6.5 which lists all the Reserved Words? I am writing an app which will allow the user to define the column names of a view. I want to check to make...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10057634.html
Zones:
MS SQL ServerDate Answered: 06/12/1998 Rating: 7.6 Views: 0
Okay, I know this must have been asked a 1000 times on this page. But here it is anyway.
I have multiple processes that will be accessing the same MS SQL table. Their first access will be to see w...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10059586.html
Zones:
MS SQL ServerDate Answered: 06/25/1998 Rating: 7.8 Views: 0
I have a multi-table database (aren't they all) which requires several outer join statements and we are piecing it together by the key columns. Can someone give me an example of a SQL statement wh...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10064576.html
Zones:
MS SQL ServerDate Answered: 08/09/1998 Rating: 6.6 Views: 0
I have form level recordset variable. And I am using an SQL statement in a routine and using Set Testset = test_Db.OpenRecordset(Sql, dbOpenDynaset, 0, 1). But the problem is when I tried to update...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10067324.html
Zones:
MS SQL ServerDate Answered: 08/05/1998 Rating: 4.4 Views: 0
