Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: TechnoSpike
- Order by date
-
Problem in Filling DataSets with SQL Procedures
Hi! I'm having trouble trying to fill a DataSet with the results of a procedure I wrote. The procedure has 1 parameters and is composed of a select query (select id,text from Users where id=id_passed_by_param). My problem regards using this procedure to fill a DataSet. I was trying to do this...- TechnoSpike
- Thread
- Replies: 1
- Forum: C# (C sharp): Microsoft
-
Problem with TOP and User Functions
Hum....sorry, doesn't work either....when I use this: CREATE FUNCTION ListTopRegionsN (@reg_id int, @num int) RETURNS @table table ([TerritoryID] [nvarchar] (20), [TerritoryDescription] [nchar] (50)) AS begin if exists (select 1 from Region where RegionID = @reg_id) begin insert into...- TechnoSpike
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Problem with TOP and User Functions
Hi! I'm trying to create an User Defined function that gives me the top rows of a table. I must be able to define wich is the top number of rows to be returned. I assume I could do this: CREATE FUNCTION ListTopRegions (@reg_id int, @num int) RETURNS @table table ([TerritoryID] [nvarchar] (20)...- TechnoSpike
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
