Viewing 15 posts - 631 through 645 (of 3,221 total)
Test either of these to chose the one you realy want.
SELECT USER_NAME();
GO
SELECT SUSER_SNAME();
Here is an example of its use:
CREATE TABLE #Orders(
[UPC] [varchar](50) NOT NULL,
[SuggestedPrice] [money] NULL,
[Addedby] [Varchar] (45))
CREATE PROC...
February 19, 2012 at 6:21 am
vj6396 (2/18/2012)
Thanks..http://www.sqlservercentral.com/articles/T-SQL/71550 had exactly what I needed. I hadn't quite understood the "multiple objects" when I saw the post earlier..
Regards
There may be others with the same thought. ...
February 19, 2012 at 5:27 am
If I am reading your posting correctly (and there is a good chance that I am not) in the Product table, you have designated the Product_ID (PK). Where I take...
February 18, 2012 at 2:44 pm
When going to "Recent Posts", this shows up:
http://www.sqlservercentral.com/scripts/CROSS+JOIN/87362/
Note that it is a SCRIPT so why oh why is it appearing in "Recent Posts" - another foul up something like what...
February 18, 2012 at 2:08 pm
This might give you an idea of how to do what you want to do.
http://www.sqlservercentral.com/articles/T-SQL/71550/
It is an excellent discussion by Jeff Moden with sample code to do what I think...
February 18, 2012 at 11:06 am
SQL Kiwi (2/17/2012)
Cliff Jones (2/17/2012)
Interesting but I don't think I want my developers to discover the FORCESEEK hint.
This is completely the wrong approach, in my opinion. I prefer to...
February 17, 2012 at 9:31 pm
The subject of these self driving or assisted driving cars got me to search the web. Try viewing these
Nevada Becomes First State To Regulate Self-Driving Cars ...
February 17, 2012 at 4:17 pm
Looking for something like this:
DECLARE @HireDate DATETIME
DECLARE @CurrentDate DATETIME
SET @HireDate = '01-06-2012'
SET @CurrentDate = GETDATE()
SELECT DATEPART(wk, @CurrentDate) - DATEPART(wk,@HireDate) AS 'Weeks Worked'
--Result:
Weeks Worked
6
February 17, 2012 at 2:51 pm
Jeff Moden (2/17/2012)
Evil Kraig F (2/17/2012)
GSquared (2/17/2012)
bitbucket-25253 (2/17/2012)
February 17, 2012 at 2:08 pm
Revenant (2/17/2012)
GSquared (2/17/2012)
bitbucket-25253 (2/17/2012)
February 17, 2012 at 11:48 am
Getting away from cold weather and all, I can remember back to 1950 when an uncle of mine gave me his old, old beetle so it must have been say...
February 17, 2012 at 10:59 am
Koen Verbeeck (2/16/2012)
Revenant (2/16/2012)
Grant Fritchey (2/16/2012)
Stefan Krzywicki (2/16/2012)
Brandie Tarvin (2/16/2012)
February 16, 2012 at 2:36 pm
Just shows that you must read the comments posted on any published article.
February 16, 2012 at 8:39 am
Look at this "Spackle" article by Jeff Moden, I think it might do what you want to do.
February 16, 2012 at 8:09 am
zeeshandar (2/16/2012)
Let me explain what I am trying to do in Steps:
I have:
- Sql server 2005 at my hosting
- Sql server 2000 at my office computer
I want to download complete...
February 16, 2012 at 5:59 am
Viewing 15 posts - 631 through 645 (of 3,221 total)