MS SQL Server 2005

71K

Solutions

25

Articles & Videos

23K

Contributors

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Refine results

When I execute the following stored procedure in SQL Server 2008, I get the error

Msg 102, Level 15, State 1, Procedure proc_CSL_AutoDetStop, Line 7
Incorrect syntax near '='.

Do you know how …

210 views
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

I am trying to update the table. where I have following columns:
folioNo,pgPos,PgName,

folioNo is the order
pgPos is either right or left (if folioNo is odd then put L (left) if even put R(right…

526 views

Hello

I have a stored procedure in sql server 2012 which I pass in a comma separated value, loop it and update a table...all good.

but now I have 2 lists to handle now which they need to be pair…

1212 views

When doing a query on a table with multiple indexes how can i know which one SQL is using?

215 views

How would i use OPENDATASOURCE to insert the records from a table in one database table to an identically named table in another Sql server instance on another server?

813 views

I have a database in SQL Server 2008 that is reporting it is 1.5GB when the actual size is a fraction of that.

EXEC sp_spaceused reports that the database is 1533.07MB

EXEC sp_msforeachtable '…

413 views

Hello,

i am trying to insert

      INSERT INTO  [CORRCE] (  [Year_Ref] ,  [Ref]  ,[Date] ,[SentTo] )      
     
      
         VALUES
       ('22' , '556' , '21 September 2016' , ' hotel 's b'a')

Any sugg…

214 views

Hi Everyone,

Any assistance would be greatly appreciated. BIG THANKS!!!

Delete items that are no longer available in the database:
1) I would like a query to compare the 'Item Number' column fr…

1635 views

I need to get the next and a previous instructor for the session, I got the code working with one little thing The instructor have to distinct.

(CODE)

525 views

I am having an issue where SQL Server does not see a Foxpro DBF file when I attempt to import using SSIS. I see all other files except WOYTRN01.dbf. I am able to update with the following statements b…

1113 views
 Java Android Coding Bundle

Whether you're an Apple user or Android addict, learning to code for the Android platform is an extremely valuable, in-demand skill. It all starts with Java, the language behind the apps and games that make Android the top platform it is today.

I have table 'users'  and field 'dob'
dob is an navarchar field and has the following type of values:   Aug  1 1968 12:00AM

I need to run a query to format such values as if they are dates, so it …

421 views

I want to create a stored procedure to then schedule with SQL agent. Never created one before. Help plugging in the select statements below into the stored procedure template will be greatly appreciat…

431 views

Currently still using SQL Server 2005.
I have a table that has one row for each clock in or clock out like the attached file (hoursworked.xlsx) Notice the first employee worked two shifts per day.

529 views

Experts,

I'm looking for input on ideas to keep in mind when planning and creating a MEDICAID data warehouse. This data will be used to help identify WASTE, FRAUD AND ABUSE.

Has anyone worked on…

322 views

Table 1
PrimaryOrderID, AlternativeOrderID
123                             234
455                             238
233                             231
533                             345

Table…

227 views

Hi,

I like to test the connection to SQL Server. My Web Site is running under AD account Domain\userA.

my connection string is connectionString="Data Source=server\instance;Initial Catalog=Datab…

720 views

Hello,

I am trying to convert a datatype of an column in sql table to money .But it fails due to some data which cannot be converted to money.How can  I check in the table which data is causing the…

1117 views

I want to run the following statements from a command line and schedule it. How would I accomplish this?

(CODE)

216 views

Getting error message when running a job when scheduling a job using a linked Server.  It fails when it runs the following statements below. Screenshots are attached. Both scripts run fine in a query …

1230 views
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Hi,

How do I change all highlighted to D: drive in SQL with one query.

628 views

Hello experts, I have a 2005 MSSQL server with a databse with a lot of free space in it.
Before any warnings about how bad it is to shrink databases, I know, and the client dimissed all my warnings.…

423 views

Hello,
I would like to cast Breite1, Laenge, Staerke AS double that this query will work right.
In my sql they have the typ: varchar.

Sql_Search_String.Format("SELECT * FROM Angebot_Anfrage WHERE…

1128 views

Hello EE, I have a column field in a table called "Instruction Text"

inside, users are puting text and a date such as :

DATE JOB FOR OCTOBER 20 BlaBlaBla
Date job for November 18 BlaBlaBla

430 views

Hi Experts,

In my project, I have a finger print scanner. When the students scan their finger, I insert the record in SQL Server. It is inserting duplicate records exactly at same time.


This i…

1533 views

I am currently using this statement to query a linked Server: (CODE) and it works fine.

I want to add a WHERE clause to filter by date using the RECDATE field. I try (CODE)

but it is not working…

122 views
Show more content
201506-LO-Top-001

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. MS SQL Server
    (156,011)
  2. MS SQL Server 2008
    (48,405)
  3. Query Syntax
    (47,076)
  4. Databases
    (53,323)
  5. .NET Programming
    (131,248)
  6. ASP.NET
    (122,806)
  7. SSRS
    (8,613)
  8. Windows Server 2003
    (128,374)
  9. DB Reporting Tools
    (7,991)
  10. Visual Basic.NET
    (91,581)