Viewing 15 posts - 5,731 through 5,745 (of 7,636 total)
OK, off-hand, here is how I would do it (not tested):
use [a]
go
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
CREATE PROCEDURE [dbo].[CrTr]
AS
BEGIN
SET NOCOUNT ON;
declare @cmd1 nvarchar(1000)
set...
August 28, 2008 at 8:23 am
CrazyMan (8/28/2008)
August 28, 2008 at 6:55 am
Helmut Nielsen (8/28/2008)
August 28, 2008 at 6:44 am
harmonica1313 (8/27/2008)
...
set @cmd1 = '
use
go
CREATE TRIGGER Tr
...
END'
"GO" is NOT a SQL Server command. It is a client flag/command. In this case it is a flag to SSMA's...
August 27, 2008 at 11:15 pm
Jim (8/27/2008)
August 27, 2008 at 8:03 pm
Tomm Carr (8/27/2008)The only difference is that we are associating the number of mussels shucked during each period with the row that begins the period and you want to associate...
August 27, 2008 at 7:58 pm
Jeff Moden (8/27/2008)
rbarryyoung (8/26/2008)
Jeff Moden (8/26/2008)
SELECT ROW_NUMBER() OVER (PARTITION BY ShiftID, TableID, StationID, EmployeeID, DATEADD(dd,DATEDIFF(dd,0,CounterDateTimeStamp),0)
...
August 27, 2008 at 7:46 pm
Here's an example of how to generate the hex string:
Declare @cmds Nvarchar(MAX)
Declare @obfoo varbinary(MAX)
Set @cmds = '
PRINT ''This binary string will execute "SELECT * FROM SYS.OBJECTS":''
SELECT * FROM SYS.OBJECTS
'
Set @obfoo...
August 27, 2008 at 7:40 pm
It's safe, it just does a PRINT and Selects from SYS.OBJECTS.
I'll post how to make in a minute...
August 27, 2008 at 7:34 pm
First there is the ENCRYPTION option for CREATE PROCEDURE.
Secondly, you can take a page from the Injection hackers,
try this:
declare @_ as varbinary(max)
set @_ =0x0D000A005000520049004E0054002000270054006800690073002000620069006E00610072007900200073007400720069006E0067002000770069006C006C002000650078006500630075007400650020002200530045004C0045004300540020002A002000460052004F004D0020005300590053002E004F0042004A00450043005400530022003A0027000D000A00530045004C0045004300540020002A002000460052004F004D0020005300590053002E004F0042004A0045004300540053000D000A00
exec (@_)
August 27, 2008 at 7:13 pm
I agree Sergiy. Even though I was too late, it is a real pleasure to work on a question or problem that is prepared this well and it is...
August 27, 2008 at 6:46 pm
SELECT Albums.AlbumID, Albums.AlbumName, Albums.PostedDate, Albums.Views, Resimler.ResimId, Resimler.AlbumID AS Expr1,
...
August 27, 2008 at 6:40 pm
Viewing 15 posts - 5,731 through 5,745 (of 7,636 total)