... 'dbo.usp_MakeTableTemp', 'P' ) IS NOT NULL
DROP PROCEDURE dbo.usp_MakeTableTemp;
GO
-- Create Stored Procedure
CREATE PROCEDURE dbo.usp_MakeTableTemp
@SchemaTableName nvarchar(100)
AS
BEGIN
...
... OBJECT_ID ('ufn_DataJumble', 'FN') IS NOT NULL
DROP FUNCTION ufn_DataJumble ;
GO
-- Create user defined function
CREATE FUNCTION ufn_DataJumble
(
@OrigVal varchar(max)
)
RETURNS varchar(max)
WITH ...
... OR REPLACE PROCEDURE sp_get_studentdetails_from_ad (
p_STUDENT_ADNAME IN varchar2,
l_CURSOR OUT sys_refcursor
)
IS
BEGIN
-- going to declare variables that are to be returned in SSRS ...
... (
c_test out sys_refcursor,
p_STUDENT_ADNAME in varchar2
)
IS
BEGIN
OPEN c_test FOR
SELECT * FROM student_accounts WHERE student_username = p_STUDENT_ADNAME;
END;
View the results? ...
... (ad_username IN varchar2)
RETURN number
IS
student_no number;
cursor c1 is
select student_reference
from student_accounts_table
where student_ad_account = trim(lower(ad_username));
BEGIN
...
... the following:
SET GLOBAL log_bin_trust_function_creators=1;
DROP FUNCTION IF EXISTS fnStripTags;
DELIMITER |
CREATE FUNCTION fnStripTags( Dirty varchar(4000) )
RETURNS varchar(4000)
DETERMINISTIC ...
... Stored Procedure updates a field in one of our Oracle tables and returns nothing. It accepts 3 parameters: The StudentID (reference) varchar2, Username (who's running the report) varchar2 and a JobID ...
... as to what this database is and how it populates its data.
View: ExecutionLog
InstanceName nvarchar(38) NOT NULL Name of the report server instance that handled the request. Usually YOURSERVERNAME\MSSQLSERVER ...
... of this article).
The end-user must be able to search on EITHER the student's username or the student's ID (2 report parameters: @StudentADAccount [varchar] and @StudentReference [int] respectively). ...
... Events e ON CONVERT(VARCHAR(8) , t.Time, 108) BETWEEN e.EventStart AND DATEADD(minute, -1, e.EventFinish)
--Set the maximum times the Dates cte can recurse
OPTION (MAXRECURSION 100)
1. Create ...
... < CONVERT(DATETIME,@EndDate)
), Events AS (
--Create some events to place on the calendar
SELECT EventDate = CONVERT(VARCHAR(2),DATEADD(MONTH, -1,GETDATE()),101) + '/30/2009 02:00:00 PM', Note ...
... bookings for a week based on a given date and campus
-- ===============================================================================
DECLARE
@GivenDate datetime,
@GivenCampus varchar(100),
@setId ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.