Topics
Started by
Posts
Last post
I've seen in BOL under the section regarding Stored Procedures, specifically declaring OUTPUT param…
2 replies
Hi, Say I have the following field in a table (1 field there is a comma in the field 'Name') Name S…
11 replies
I have a project that I am afraid may require a cursor. I was wondering has anyone had a problem li…
5 replies
Hey guys, good day 🙂 I was working on something, but could not pull off this thing.. I have done it…
12 replies
Hi, I'm trying to create a Thread View for a messaging system. I have 1 Table called mt_messages th…
5 replies
So I two tables that I am working with here: "Students" and "Schedule". What I am trying to do is s…
3 replies
Why do we use the SP - sp_refreshview ? The view is updated as the table is updated.
6 replies
Hello, I want to run a select command, on the basis of LIKE clause. In WHERE condition, I want to i…
4 replies
I want to get the rowid internally generated at table level in sql server. Because I need to perfor…
40 replies
I have a storedproc ALTER PROCEDURE [dbo].[ABCD] AS BEGIN UPDATE dbo.XXX SET Has_Errors = 1…
4 replies
Hi all, I need a little help here. I have a table with duplicate agentcodes and agentnames. I need…
4 replies
This is my stored procedure: declare @t1 table ( eForm53_GUID uniqueidentifier, b datetime, full…
10 replies
Dear, i have an table TblROHS_OcsData, CREATE TABLE [dbo].[TblROHS_OcsData]( [ProdDate] [dateti…
3 replies
CREATE TABLE [dbo].[Asic] ( [ID] [int] IDENTITY(1,1) NOT NULL, [NAme] [nvarchar](50) COLLATE SQL_…
4 replies
(And yes, I have ad hoc query enabled.) I'm trying to export some data into an excel spreadsheet. T…
12 replies
Viewing 15 topics - 2,911 through 2,925 (of 12,234 total)
You must be logged in to create new topics.