Viewing 15 posts - 121 through 135 (of 162 total)
Dear L Xu,
You need to take take care of the following:
1. Make sure that the field in SQL server which are supposed to store data in Russian language are nchar/nvarchar/ntext...
March 13, 2008 at 11:24 am
Thanks for the information. It would be nice if you share more details like you used it in what scenario.
March 11, 2008 at 10:13 am
You can make a function and use it in your insert statement as below. This way you will avaoid the update statement.
CREATE function [DateOnly](@DateTime DateTime)
-- Returns the DateTime minus the...
March 5, 2008 at 10:28 am
SELECT U.uid,U.name,U.mail,R.name
FROM users U
INNER JOIN users_roles Ur
ON U.uid=Ur.uid
INNER JOIN role R
ON Ur.rid=R.rid
WHERE R.rid=2;
But this query does not display any records.
The above query should not display any records. Simply because there...
February 24, 2008 at 9:56 pm
February 20, 2008 at 11:41 am
Dear raghunandansharma12 ,
Here is the solution of the problem that you stated :
How can i store differnt subject with one classId where cls_id is Auto-gentrated(identity)
What you need to do is...
February 4, 2008 at 3:23 am
Hi Pete,
I am pleased to know that it is working for you. Testing and debugging a piece of programming script to make it work exactly as you want is different...
January 31, 2008 at 10:50 am
First of all, replace the "[" and "]" with "(" and ")" and also remove the "." after "]"
If the rest of the things are good it will solve the...
January 25, 2008 at 4:35 am
Caught the bug, You did a visibly small mistake with the begins and ends while modifying the code
which botched up the whole thing.
Every “begin” should have its “end” in...
January 24, 2008 at 12:14 pm
Oh another bug! Let me catch it this weekend!:)
January 22, 2008 at 11:30 am
Hi Scott,
Your inputs are very useful for the requirements like you mentioned.
But in the present case
I need a result table containing all 100 columns from MyNames but only the unique...
January 22, 2008 at 8:18 am
Hi Mark,
The same result can be achieved by:
SELECT Name, Factor1, Factor2 FROM
(SELECT Name, Factor1, Factor2, ROW_NUMBER() OVER(PARTITION BY Name ORDER BY Factor1) as rn
FROM MyNames) A
WHERE rn=1
Do you see...
January 21, 2008 at 11:41 am
A really nice one from Mark showing the use of CTE (Common Table Expressions) and ROW_NUMBER() two of the many new features of SQL Server 2005.
Check the below link...
January 21, 2008 at 8:37 am
You can use the functions CalcTimeBetweenTwoDates & CalcTimeSinceCreated in any SQL statement, stored procedure or UDF
For example
select dbo.CalcTimeBetweenTwoDates(date_created, date_modified) from [Your Table]
will give the duration between the two fields.
select...
January 19, 2008 at 12:29 pm
Viewing 15 posts - 121 through 135 (of 162 total)