Viewing 15 posts - 706 through 720 (of 761 total)
SQL is simply a query language. It would give you all the results depending on the query you ask. So, it is upto you to ask the right query. If...
April 16, 2012 at 6:31 am
The Update Syntax seems fine.
Have you tested the Select Query??....If the Select Query works fine then I think that $desiredProduct, $desiredYear and $desiredMonth would not be the ones causing problems...
April 16, 2012 at 6:18 am
Considering the urgency of the requirement and the vagueness of the question, the following link seems to be an apt solution:
April 16, 2012 at 5:57 am
ColdCoffee (4/16/2012)
Setting up the sample data
DECLARE @Tab TABLE
(
ID INT
,Tym TIME
,Axn INT
)
INSERT @Tab
SELECT 1 ,'10:00', 1...
April 16, 2012 at 5:45 am
Does Case matter in SQL Server?
Anyways, you can rename the column as follows:
sp_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN'
April 16, 2012 at 5:34 am
Grass (4/15/2012)
I tried using before but didn't work.can u tell me how to use the distinct to replace SET statement.what fields needs to be distinct?thanks.
Try these for Distinct:
SET @Project_ID =...
April 16, 2012 at 5:14 am
Windows Explorer....Can you see it at the location where you saved it?
April 16, 2012 at 5:11 am
capn.hector (4/14/2012)
vinu512 (4/13/2012)
April 15, 2012 at 10:24 pm
PaulB-TheOneAndOnly (4/14/2012)
sukato7 (4/14/2012)
How can I set PK columns to allow null or blank?
You cannot do it.
A Primary Key is a Referential Integrity constraint that exclusively allows unique values and does...
April 15, 2012 at 10:09 pm
Grass (4/14/2012)
April 15, 2012 at 10:08 pm
+1 on dat Fitz.
Forgot to add the part about Clustered Index Views.
April 14, 2012 at 6:00 am
Views are virtual parts of one or more Physical tables. Following is a good article about Views:
Although Views are present in a Database they do not consume...
April 14, 2012 at 5:06 am
Divya Agrawal (4/14/2012)
RexHelios (4/13/2012)
I have the following table...
DECLARE @EmploymentHistory TABLE (
CompanyName VARCHAR (100), EmployeeName VARCHAR (100),
EmploymentBeginDate DateTime, EmploymentEndDate DateTime)
INSERT @EmploymentHistory (CompanyName, EmployeeName, EmploymentBeginDate, EmploymentEndDate)
SELECT 'Jack and Jill Company',...
April 14, 2012 at 4:37 am
Viewing 15 posts - 706 through 720 (of 761 total)