Hi every one
I want to generate a RSS Feed from SQL Server 2005.
The scenario is that when a record is entered in the database, the database fire a trigger which generate rss feed for the new record entered in the data base
Thanx in advance
Take care
Bye
Hi All,
Can any tell me how to generate the Script file in SQL 2005.
If i execute that script in another server all should be created automatically including the Database with the same name.
How to do this..
Ganesh
Is it possible to have a DateTime field in a row automatically generated when a row is created?
ie:
INSERT INTO [TableName] ([DateTimeStamp], [UserId], [Title], [Explanation]) VALUES (DateTime.Now(), @UserId, @Title, @Explanation)
or something like that?
Anyone know an easy way to generate the SQL Scripts to gererate the
tables/sp's/triggers/indexes/fk's, ect? I know Sql Server 2000 lets you
generate the db script, but I don't know how to do this with 2005
Using the scripting wizard in SQL Server 2005 database engine, I have been able to script all my DDL out to a flat file which is great; however, when I scripts for instance all views I would like to have the script in alphabetical order by view name, is there a value I can set to accomplish this?
Thanks
Hi there,
I have setup merge replication which successfully synchronizes with a group of desktop users using SQL Compact Edition.
However now I have setup Article Filters and when I attempt to regenerate the snapshot I get the following error:
Invalid column name 'rowguid'.
Failed to generate merge replication stored procedures for article 'AssignedCriteria'.
When I look at publication properties at the Articles page.. All my tables have the rowguid uniqueidentifier successfully added to tables and selected as a compulsory published column, apart from the table above "AssignedCriteria".. Even when I attempt to select this column in the article properties page and press ok, when I come back it is deselected again. ( The Rowguid column is however physically added to the table)
I have scripted the publication SQL and then totally reinstalled from scratch, including the database but for some reason it doesn't like this table. I remove the article filters, but still this "rowguid" is never "selected" in article properties.
We are using Uniqueidentifiers in other columns as well for historical reasons, but this doesn't appear to be a problem in other tables..
DDL For this problematic table is as follows
CREATE TABLE [dbo].[AssignedCriteria](
[AssignedCriteria] [uniqueidentifier] NOT NULL,
[CriteriaName] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TargetScore] [numeric](5, 0) NULL,
[HRPlan] [uniqueidentifier] NULL,
[ActualScore] [numeric](18, 0) NULL,
[Criteria] [uniqueidentifier] NULL,
[Employee] [uniqueidentifier] NULL,
[IsActive] [bit] NULL,
[addDate] [datetime] NULL,
[totalscore] [numeric](5, 0) NULL,
[isCalc] [bit] NULL,
[Weight] [decimal](18, 2) NULL,
[ProfileDetail] [uniqueidentifier] NULL,
[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL CONSTRAINT [MSmerge_df_rowguid_7FF25DF903B6415FBFF24AC954BC88E4] DEFAULT (newsequentialid()),
CONSTRAINT [PK_AssignedCriteria] PRIMARY KEY CLUSTERED
(
[AssignedCriteria] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
Thanks.
I need to have an automated process to read data from DB2/AS400 and feed it to SQL Server 2000. Has anyone done this before? Any suggestions how it may be done? I know my company doesn't want to spend a lot to do this.
Thanks for your time.
Hi
I would like to be able to feed the List of tables to the Transfer SQL Server Object Task dynamically.
I have got a foreachloop container which it feeds the table names into a variable @table_name (string).
Transfer SQL Server Object Task is with in foreachloop container
I did add an expression into the property of Transfer SQL Server Object Task and assign the tablelist property to @table_name
I would be grateful if you can give me any hint.
Thanks
S
Hi: I have SQL Server 2005 Express edition and I am trying to generate a script that someone can take and import into the full version of SQL Server. Using the Generate Scripts Option, I have been able to generate scripts for the various SQL statements that I created - but cannot get it so that the data is included. I'm new to this and would appreciate any help. I have a populated database that I would also like to transfer to the new server.Any help greatly appreciated.Roger Swetnam
View 2 Replies View RelatedHi,
Not sure if this is the right board as it could be in the XML one aswell...
I'm fairly ok with ASP2.0 and used it to build a database driven website: www.trailandtrack.co.uk however, I want to create an RSS feed of the trails that are on the site.
The trails are all in a MSSQL2000 database, and are all keyed on a unique ID which is used to retreive the trail info from the database (using querystrings)
I want to create an automatic RSS feed that gets updated automatically from the database whenever new trails are added. Giving the Title as the Trail Name, Link But using the standard URL: http://www.trailandtrack.co.uk/usertrail.aspx?trailid=123 (if you go this this page you'll see the feidl placeholders)
Only thing is Ive not got a clue how to go about creating an RSS feed to do this, can anyone help?? (I can do a manual one fine, no probs, but automatically - it's a bit out of my debth)
Thanks
Hi everyone
I have been tasked on importing an xml feed into a sql server 2005 database. Now I am a network guy so I am completely clueless here.
Could anyone help?
http://www.iafrica.com/content_feeds/business/worldatsix.xml
Need to bring that into a database table (not created yet)
Any help would be appreciated
Thanks
Hello Friends,
I would like to know what Data Feed means while working as an Administrator on Ms SQL Server 2000?
Also what do you mean by integrating feed of data?
I would appreciate it if anyone could help me out with this queries...
Also I was wondering which would be best book to refer while learning about ms sql server 2000.
Is it possible to create an RSS file from directly MS SQL 2005? I'd like to create a task to produce a file daily and place it on a web server.
Ryan
Ryan Everhart
The New AT&T
Hello,I have an XML data feed that I would like to use to create tables inSQL Server. The xml data feed consists of a large amount ofinformation that changes on a regualar basis. Is there a way toautomatically create SQL Server tables using the data feed?ThanksBilly
View 7 Replies View RelatedHi,
if I have one table to transfer I can use the following to amend the tableslist
Imports System.Collections.Specialized
Public Sub Main()
Dim application As Microsoft.SqlServer.Dts.Runtime.Application = New Application()
Dim packagename As Object = Dts.Connections("Tables").AcquireConnection(Nothing)
Dim package As Microsoft.SqlServer.Dts.Runtime.Package = application.LoadPackage(packagename.ToString(), Nothing)
Dim th As TaskHost
th = package.Executables("TablesToMove")
Dim sc As StringCollection = New StringCollection()
sc.Add(Dts.Variables("Tables1").Value.ToString())
th.Properties("TablesList").SetValue(th, sc)
application.SaveToXml(packagename, package, Nothing)
Dts.TaskResult = Dts.Results.Success
End Sub
now if I have a list of tables (as an SSIS object time ) how can amend this script to table the objetc rather than feeding each table
Thanks
I have two matrices aligned on one line (side by side). When I preview the report in BIS, the output shows the two matrices on the same line.
When I run the report from report manager, the output shows the two matrices with a line feed (the second matrix is on line 2). All of the rest of the report is aligned properly until I put two matrices next to each other. Then it seems to randomly throw in a line feed. The page width for the report layout seems to be more than enough to accomodate the matrices.
Why is this happening?
we have data base in ms access and reports in crystal reports 5 recently we converted our data base to sql sever 7
and reports to crystal reports 8. when i opend directly in cystal reports and given data base connecting through oledb
i am getting reports but from the application it is in vb6 the report window is poping up and latter a error msg saying un able to open sql server
when i checked up the connection it is ok help me
anil
I am trying to generate a hex value automatically at time of insert. The column used for the hex # is an identity column. I am getting an error that the trigger fails because the field doesn't accept nulls. My guess is that the identity column is not populated yet.
Below is the table and trigger.
CREATE TABLE [dbo].[scancode](
[scancode_id] [int] IDENTITY(1,1) NOT NULL,
[scancode] [varchar](50) NOT NULL,
[parent_object] [varchar](150) NOT NULL,
[parent_object_id] [int] NOT NULL,
[Created] [datetime] NOT NULL,
[code].....
we can generate drop-down list on the tables by writing sql query at "Access". I was wondering whether or not the same thing can be done for SQL Server?
View 4 Replies View RelatedHi,
I use SQL Server 2005 Dev Edition and am not new to making databases (then again, I've had enough experience and my dad does the same thing).
I am (unfortunately) a university student and for my dissertation I am going to produce a SQL Server database with a strong emphasis on data mining.
Obviously, for the data mining to be useful at all I need to produce loads and loads of test data.
Fair enough, and there are applications which do this, such as EMS Data Gen, but can anyone recommend me any other data gen utilities? EMS Data Gen has poor handling of unique attributes, and as I am doing a car manufacturer this will give me problems when I come to the registration number attribute.
Also, why are utilities for SQL Server (and Oracle at that) so expensive? This makes it out of my reach and makes it difficult to build a truly good database that will net me good marks, and demotivates me. :(
Lastly, please feel free to recommend to me any utilities for SQL Server - such as performance monitors, backup utilities. Anything. But if they are priced utilities, they have to be sensibly priced (<£100), because I cannot yet afford to pay >£1k on such utiltiies.
Thanks
Generating different types of letter (PDF formats) from SQL server?
View 3 Replies View Relatedhow can persist schema for a sql server table into an xml file from .net application?
thanks
Hi,
I want to insert line feed. I have used char(10) and char(13) function. But I could not insert line feed. Ex: set error1= 'error description' + char(10)+ 'Employee'
Output must be: error description Employee
Any suggestions are welcome.
Hello there,
I'm working with Analysis sevices 2005 developer edition. Looking through the documentation i becomes apperent that the NN algorithm takes 255 input attributes by default. This can be changed to any integer value, OK....
My problem is that I want to feed the network with 40000 input variables. In order to do so, I will have to do a select:
SELECT fld1, fld2, ...... fld39999, fld40000
FROM tblSometable
However, this is not possible, as the books online describes it is only possible to return 4096 columns from a select statement.
Question : How do I populate a NN in AS2005, with nmore than 4096 inputs ?!
Hello,
I am displaying a complex formula in a column header tool tip. The formula is generated in a stored procedure. (I do not enter the tool tip text directly in the column header expression.)
Within the stored procedure, how do I generate a string that contains a carriage return/line feed?
Thanks,
BCB
I have recently returned to developing a website using Visual Web Developer Express 2008. I want to store information in a database. I have SQL Server 2005 Express edition installed on my pc.
When I try to Add New Item -> SQL Database from VWD2008 by right clicking in the App-Data folder and completing the dialogue I get the following error message:
Generating user instances in SQL Server is disabled. Use sp_configure ‘user instances enabled' to generate user instances.
I have SQL Server Management Studio installed but do not seem to be able to resolve this issue.
My operating system is windows XP Home SP2.
Some guidance on solving this would be appreciated.
Many thanks
Roger L
I am trying to generate dates for a roster dynamically in a stored procedure. If my start date is '01/01/2015', end date is '12/31/2015', I should generate dates from '01/01/2015' adding 7 days.
The output comes like this:
01/01/2015
01/08/2015
01/15/2015
.
.
.
until end date
I do it through loop but just posting it here to know, if there is any other efficient way using CTEs or some sort of queries which can avoid loop in SP.
Use sp_configure 'user instances enabled' to generate user instances.
I get the above error when I attempt to add an SQL Database item into my VS (C#) project. I do not understand what needs to be done to correct the problem.
Any help is appreciated.
Thank You,
Klaus
Hi there, I hope you can help us.
We're using this statement to import some values into a database:
SQLStatement = "INSERT MyTable (ID, VALUE) VALUES ('" & IDString & "', '" & VALUEString & "')"
The problem is that the strings might contain carriage returns/line feeds, i.e.
VALUEString = "Line 1." & vbCrLf & "Line 2."
It only imports up until the first vbCrLf. We have tried replacing vbCrLf with "", but this doesn't work either. What is the correct format for inserting a value that contains new line characters?
Thanks for your time,
Lasse.
Does anyone know where to start if I want an exported copy of homeappliances, cars, cell phones etc.I just need to populate my database and I want to get some data feedfrom all the different types of manufactures.I think there are services out there. But I have not seen one.I want a CSV file that has all the make/models for lets say: TVs
View 1 Replies View RelatedI have two SQL Server stored procedures, PROC1 and PROC2. PROC1 hasabout 50 input parameters. PROC2 is the main procedure that does somedata modifications and afterwards calls PROC1 using an EXECUTEstatement.The input parameter values for PROC1 are stored in a table in mydatabase. What I like to do is passing those values to PROC1 using aSELECT statement. Currently, all 50 parameters are read and stored ina variable, and afterwards they are passed to PROC1 using:EXEC spPROC1 @var1, @var2, @var3, ... , @var50Since it is a lot of code declaring and assigning 50 variables, I waswondering if there is a possibility to run a statement like:EXEC spPROC1 (SELECT * FROM myTable WHERE id = 2)Any help on this is greatly appreciated!
View 1 Replies View RelatedGreetings,
I need some help determining the best way to accomplish my task. The workflow starts by generating a list of unique ID's from a local table. Then take that list of unique ID's and query an Oracle table for all matching records.
My thought was to first use an Execute SQL task with the following SQL:
select projectid from projectlist group by projectid
with Result Set configured as follows:
Result Name = projectid
Variable Name = varProjectIDList
Then in the Data Flow Task add a DataReader Source to pull the matching data. Here's where I'm getting hung up. I'd like to pass the result set from the Execute SQL task. I tried the following SQL but it doesn't work.
select * from masterlist where projectid = @[User::varProjectIDList]
I'm open to any suggestion on the best way to take my unique list and use it as input for a query against my Oracle DB.
Thank you for your ideas.
Rob
I am trying to print mailing labels and suppress optional address lines to eliminate white space while maintaining label alignment. This is what I am trying but it does not work.
I create a function that determines the length of a field (i.e. street) and increments a counter if the length is zero. It also takes a second parameter that detremines whether to reset the counter. I then use the function in the visibility each row of the label table. Example iif(Code.LineLen(Fields!Street.Value)=0,True,False). I place this on the visibility of each row except the last as that is City,State,Zip and is required. On this last row the expession I use is
=Fields!city.Value & ", " & Fields!state.Value & " " & Fields!zip.Value & iif(Code.LineCount<5,StrDup(5-Code.LineCount,vbCRLF),""). What this is intended to do is print a carraige return and line feed for every row that did not print. Instead no line feeds occur. I have verified that the Code.LineCount is indeed calculating correctly (I printed the value). I've removed the conditional to make sure it has no issues but again nothing. For clarification the code block I am using is this.
Public LineCount as Integer=0
Function LineLen(byval LineIn as string,byval IsFirst as boolean) as Integer
if IsFirst=True then
LineCount=1
end if
If len(LineIn)>0 then
LineCount=LineCount+1
end if
LineLen=Len(LineIn)
end Function
So if anyone either knows why the line feeds do not occur or a better way to handle this please let me know. Thanks.