Viewing 15 posts - 841 through 855 (of 2,894 total)
"Commonly" in SQL 2005 it's done by editing content of the Noise-word files.
You should find these files in $SQL_Server_Install_Path\Microsoft SQL Server\MSSQL.1\MSSQL\FTDATAI'm not sure if you read this one yet:
http://msdn.microsoft.com/en-us/library/ms142551(v=sql.90).aspx
It's...
November 28, 2012 at 4:10 pm
CELKO (11/28/2012)
Is any RDBMS around which is fully ANSI SQL standards compliant?
I have heard that there is one, used somewhere in Sweden, but it's not widely used, cannot even...
November 28, 2012 at 5:43 am
Looks like I will never get the answer I am looking for from JC...
Is any RDBMS around which doesn't support "!=" while supporting all other ANSI SQL standards?
May be I...
November 27, 2012 at 3:49 pm
CELKO (11/27/2012)
I don't remember punch cards but I do remember 8 inch floppy disks, if you had a 386 as a desktop you were lucky, and servers ran on...
November 27, 2012 at 11:33 am
Roy Ernest (11/27/2012)
That does not work. It gives permission error on the table in the other schema. It works with "Execute as Owner"
What user do you use to execute GRANT...
November 27, 2012 at 11:25 am
...
your current trigger would affect all records being inserted at this time if even one record had the matching criteria.
...
or not affect any records being inserted at this time at...
November 27, 2012 at 11:23 am
briancampbellmcad (11/27/2012)
The trigger is reliably setting [Transfered] = 'True' if the condition of the INSERTED Transaction type is 'Transfer'...
It does, but only if you insert one record at the time....
November 27, 2012 at 11:19 am
grant exec on [schema].[procname] to [rolename]
go
November 27, 2012 at 11:04 am
CELKO (11/27/2012)
what other alternative we can take here instead of "!= "
<> this has always been the ANSI/ISO Standard and it is univerally supported in every SQL I know
There...
November 27, 2012 at 11:01 am
Do you use fully qualified objects names in your procedure for all objects from all schemas including dbo?
If yes, "grant exec on [procname] to [rolename]" should work...
If no, then...
November 27, 2012 at 10:58 am
...
CREATE TRIGGER [dbo].[trTagTransfered]
ON [dbo].[tblTransactions]
AFTER INSERT
AS
BEGIN
IF (SELECT Transaction_Type FROM INSERTED) = 'Transfer'
UPDATE tblTransactions
SET [Transfered] = 'True'
WHERE tblTransactions.OriginalTransactionNumber in (SELECT OriginalTransactionNumber FROM INSERTED)
END
Your trigger will fire on any insert to tblTransactions.
Will it...
November 27, 2012 at 10:51 am
boobalanmca07 (11/27/2012)
without remove alter statement , how to solve the problem.because two sql statement in one stored procedure,
It's a very bad idea of making such stored procedure!
You should not mix...
November 27, 2012 at 7:53 am
Instead of including the code here, OP just duplicated the post:
http://www.sqlservercentral.com/Forums/Topic1389161-149-1.aspx
November 27, 2012 at 7:46 am
Could you please post your stored procedure code?
Without seeing what you can see it's hard to provide relevant help. Please read an article from the link at the bottom of...
November 27, 2012 at 6:24 am
Sony Francis @EY (11/26/2012)
... I dont knw the table structure....
If you don't know the table structure, how are you going to write a query against it?
You can easily review...
November 27, 2012 at 3:20 am
Viewing 15 posts - 841 through 855 (of 2,894 total)