Viewing 15 posts - 7,471 through 7,485 (of 13,469 total)
the example converts string to datetime...then if you want a specific format, you've got to convert it back again:
--Results
/*
2007-07-30
*/
Select convert(varchar(10),convert(datetime, N'30-07-2007', 105) ,120)
June 3, 2011 at 11:06 am
i would swear at one of the SQL Pass sessions, they mentioned that the SSMS 2005 GUI would not save multiple plans, and that they fixed in in 2008 and...
June 3, 2011 at 10:58 am
yep...you've got to try to get away from cursor/loop line by line thinking.
does this work like you expect?
INSERT INTO #names([Name])
...
June 3, 2011 at 10:24 am
can you put the code on a web page, wether an intra- or internet?
that'd be simplest...single source, accessible from each desktop, web page could provide results and error...
June 3, 2011 at 8:07 am
just the obvious:
sql server management studio replacement
what's wrong with the Microsoft tools again?
June 3, 2011 at 6:47 am
obvious choice would be to simply install the SSMS Client tools.
Another option would be an application like LinqPad, which has most of the things you'd look for in an app:...
June 3, 2011 at 6:32 am
duplicate post.
Please don't crosspost. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1119355-146-1.aspx
June 3, 2011 at 6:28 am
EM as in SQL 2000 Enterprise Manager?
can you explain a little better what you want? are you looking for a GUI application to access SQL 2008? like SQL Server Management...
June 3, 2011 at 6:25 am
it's still the same issue.
the Print statement thing works because it contains no objects that resolve to database.schema.table.
The first thing the database engine does is map ALL objects in a...
June 2, 2011 at 3:03 pm
the problem is the engine validates all objects mentioned in a script...regardless of if-then-else logic ; so if it doesn't exist at the moment it validates all objects in...
June 2, 2011 at 2:00 pm
Tara-1044200 (6/2/2011)
June 2, 2011 at 12:40 pm
I'm assuming you used my example as a partial model?
my knee jerk reaction was to use EXECUTE AS SELF to avoid permissions issues, and that seems to mask some of...
June 2, 2011 at 9:16 am
Ramdas Baghel (6/2/2011)
please try DDL Triggers if you having SQL Server 2005 or Higher
that won't work...scripting is a DML operation, where it goes out and selects the details for a...
June 2, 2011 at 4:25 am
patla4u (6/1/2011)
Table:1 CS(customer)CS_customer_id,
CS_customer_code
CS_customer_br
Table 2 CD(costomer desciption)
CD_customer_id
CD_customer_code
no explanation whatsoever? another repeat of a schema?
if you cannot explain what you want, we cannot explain how to do it. please see my...
June 1, 2011 at 2:56 pm
wouldn't do any good.
you need to help us help you.
go back to the beginning...we know table1 has a three column PK.
another table has two out of three columns of that...
June 1, 2011 at 2:43 pm
Viewing 15 posts - 7,471 through 7,485 (of 13,469 total)