Topics
Started by
Posts
Last post
I'm currently getting and assigning an error description from msdb.dbo.sysdtssteplog to a local var…
1 replies
I am trying to create a view that contains virtual data. For instance: An employee can create X num…
5 replies
Hi, Am using a sample stored procedure to handle transactions. Whenever any error , it should disp…
4 replies
Predict output for ROUND function This is the QotD in SQL Server Central only. I did not understand…
1 replies
Greetings all. I am using OPENROWSET to insert a sheet from an Excel file into a staging table as …
1 replies
Hi I have Table "Operations" ,This table as four columns in it.. 1. Date -its datetime 2. Equipmen…
1 replies
The normal systax for dateadd is: SELECT dateadd(yyyy, 2, getdate()) I would like to call the funct…
16 replies
Hi , I have a Rules table like; RuleNo level Attribute Operation value R1 1 FirstName li…
5 replies
Hi All, Here is the situation: I have table with the data For eg: ID LineNo Text 100 1 aaa 100 3 bb…
2 replies
I'm not sure if this is possible in SQL 2000 but I'm trying to store the Error Message in a local v…
7 replies
Hi, i have 2 tables, Patient and Patient_Supplemental: Patient: Acct_no State Visit_Date PT_ID…
2 replies
I am trying to get a YYWW format from getdate(). I was able to do it like this SELECT YYWW = C…
6 replies
Hi I have a table CREATE TABLE [dbo].[Test]( [GroupID] [varchar](50) NULL, [Rank] [bit] NULL, [R…
10 replies
front end :- Visual Basic 6.0 Back End :- Sql server 2005 express edition i have created a trigger …
7 replies
I've got this request come through and I have no idea how to get a list of user-defined statistics …
7 replies
Viewing 15 topics - 1,096 through 1,110 (of 17,082 total)
You must be logged in to create new topics.