Topics
Started by
Posts
Last post
Hi, I have a varchar(8000) field. I have to update it periodically appending it. But the stri…
2 replies
Hi all, I am having a table in which an entry is made when the user logs in to the application and …
2 replies
Is it possible? I have one table with 35 columns. I want to write a select statement which should d…
5 replies
Hi, I am trying to execute the following: SELECT * FROM [LinkedSeverName].master.sys.sysaltfiles B…
4 replies
HI all, I am current getting this error: OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked serve…
1 replies
I am building dynamic SQL that will query a remote database. The dynamic SQL gets the linked serve…
8 replies
I have a query that I use to load data into an auditing table used for disaster recovery. when the …
3 replies
I'm getting the following message when I execute a BULK INSERT statement: BULK INSERT dbName..FCALL…
1 replies
As it stands, the current stored procedure looks a lot like this: SELECT C.AnswerText, COUNT(C.…
15 replies
Hi I am having two database (Test1,Test2) In TEST1.dbo.Employee table ID is PK. How to refer this I…
2 replies
Hi, With "FOR XML AUTO", SQL 2005 returns XML with random generated column name (like XML_F2412216-…
4 replies
I have a table with 5 date fields CREATE TABLE [dbo].[ADate]( [MINDATE] [datetime] NULL, [FPeriod…
2 replies
I have a question on using a join condition when updating a table. I guess it is pretty straightfor…
11 replies
I have a query that works in the Microsoft SQL Server Management Studio, but not as a database quer…
1 replies
With T-SQL, can one use the results of a stored procedure within an expression inside a SELECT stat…
3 replies
Viewing 15 topics - 9,871 through 9,885 (of 12,234 total)
You must be logged in to create new topics.