Forum Replies Created
Viewing 15 posts - 8,731 through 8,745 (of 13,460 total)
-
RE: MS SQL Server Monitor
i took the question about "ports" and "monitor" to be:
how do i tell SQL Server which specific port to listen to...
so if i wanted to make SQL server listen to...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Documenting Database Code
j take a look at this thread from a week or so ago; there is a script contribution that I enhanced and fixed slightly;
http://www.sqlservercentral.com/Forums/Topic981671-149-1.aspx#bm981831
it produces well formatted, informative html document.
I've...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Changing from INSERT INTO...SELECT (with a UNION) to SELECT INTO
good point Reobert...getting back on topic....
your procedure...does it have defaults on any of the parameters? I would bet that is why it eats cpu cycles...
parameter sniffing.
an execution plan gets ...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: sp_executesql won't return the expected result. Any help please?
drew.allen (9/16/2010)
Jason Tontz (9/15/2010)
Because I get an error :Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'TOP'.
That's because you have your TOP clause in the middle...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: insert special char to column
you'll need to change the definition of the column from varchar to nvarchar.
the issue can be seen in this example...special charcters get converted to question marks if a varchar field...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: sp_executesql won't return the expected result. Any help please?
pretty much the same:
DECLARE @sql NVARCHAR(100),
@Params NVARCHAR(100),
@data VARCHAR(100),
@TopCount varchar(3)
SET @sql = N'SELECT @data = TOP ' + @TopCount + ' CAST([Salary] AS VARCHAR(100)) FROM [dbo.JobDescriptions] WHERE [JobName] = ''CEO'''
SET @Params...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: how to create/send HTML email in SQL and confirm READ without asking?
you'll have to create something in code or in CLR;
the ability to READ emails ( the read receipt IS an email)
was removed when sp_send_dbmail was introduced;
so there is no...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Can we execute multiple Alter statements in an IF else block for One tbale
sure, you can do it two ways;
the BEGIN...END block can contain more than one command, and the ALTER TABLe command can take a comma delimited lit of columsn tadd:
IF EXISTS(SELECT...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Update Trigger Loop?
CB the UPDATE function is really misleading; it doesn't tell you if something changed or not(which is what you intuitively assume based on the name)
it returns true or false if...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Write a SELECT statement that answers the question
Craig Farrell (9/14/2010)
But but Lowell, If Iz answerz I kin haz internets cookie! Right? Prize iz internetz cookie?ok Craig, YOU get an internet cookie:
for varunkum:
No cookie for you!
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Write a SELECT statement that answers the question
we do not do homework.
if you have a specific question, let us know, but the literal copy and paste, without any input on what you tried, what you think,...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: How to handle errors in DDL trigger
ok, any operation which changes the definition of the audit table should be rolled back anyway, should it not? changing THAT specific table is NOT a legitimate change, as it...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Query doubt
to use the alias of your calculation, you have to wrap it up as a sub query; otherwise you would have to use the full calculation inline
this is what you...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Case Statement Help
you error is really minor; a case can only have ONE "ELSE" statement:
CASE
WHEN Code Between 1 and 24
THEN Hours
WHEN Code Between 26...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: How to handle errors in DDL trigger
it seems to me that the only error that could be raised that would crash the trigger would be the renaming of the table the trigger uses, right?
why not add...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Viewing 15 posts - 8,731 through 8,745 (of 13,460 total)