Viewing 15 posts - 17,056 through 17,070 (of 18,926 total)
I'm no expert on this topic, but reading from the books online, I can't see anything about the recovery model..
Check this topic in the books online : CREATE DATABASE
Maybe that'll...
June 9, 2005 at 2:55 pm
Now you're forcing me to post......
GO
Create proc dbo.MyProc @menu_lvl2_id as int, @menu_lvl2_item as varchar(50)
AS
SET NOCOUNT ON
UPDATE on_line_tutorial_menu_level2
SET menu_lvl2_item = @menu_lvl2_item
WHERE menu_lvl2_id = @menu_lvl2_id
SET NOCOUNT OFF
GO
EXEC dbo.MyProc 2, 'test'
Select * from...
June 9, 2005 at 2:52 pm
strange... what happens if you create a dummy db just now?
June 9, 2005 at 2:34 pm
It's quite easy to do, but I'm not sure of what you want to do.
Can you post the table definition, some sample data and what you want the select statement...
June 9, 2005 at 2:32 pm
Please do not cross post, we monitor all the boards.
Finish this thread HERE
June 9, 2005 at 2:27 pm
"We pretty much ran out of ideas on this tool so to kill time decided to convert it to C#"
hehe... wish I had this luxury
June 9, 2005 at 2:01 pm
Text field or varchar() field???
UPDATE on_line_tutorial_menu_level2
SET menu_lvl2_item = 'Bob''s Hobbies'
WHERE ...
June 9, 2005 at 1:57 pm
It's not true...
I didn't comment this post today : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=7&messageid=189223
June 9, 2005 at 1:56 pm
I've built up a documentation tool that does the basic stuff you're doing with your software. The neat thing about it is that I'm able to check both on...
June 9, 2005 at 1:47 pm
Would work nicely... but the same problem remains : untill we know why he wants to do this, we're simply guessing solutions.
June 9, 2005 at 1:44 pm
Can you post the code of the sp??
Also you might have to take a look at parameter sniffing, and today's article : Real World Query Plans
June 9, 2005 at 1:33 pm
Because you didn't know... you assumed.
Now you know
.
June 9, 2005 at 1:30 pm
Viewing 15 posts - 17,056 through 17,070 (of 18,926 total)