Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
MS SQL Server
Articles & Videos
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
I have a table in SQL Server with a number of fields, i have created a composite PK of LoanNumber, BorrowerName, LenderNumber; I need to compare a new data set that contains these and other fields to …
I am working with a Microsoft Access Database. There is a table which contains a column called 'City'. This column contains the City, State and Zip in a comma delimited format. I would like to writ…
After copying a database and security information to a new server, I'm trying to map a user ('UserX') to a database in SQL. However, when attempting to save, I get an error message: User, group, or r…
I need to delete duplicate data
i.e. if i have 2 rows exactly the same, delete one of the rows
I have a table called Tbl_Data
It has these columns
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 …
How do I resolve the following error using SQL Server 2008?
dtCreated has a data type of datetime and has a value such as "2009-08-03 00:00:00.000"
Msg 1023, Level 15, State 1, Procedure proc_CS…
I hope you can deduce what i am asking from the excel spreadsheet
it has 3 tables listed and the desired results. I don't know how to write this query.
the problem area is the gallons table.
Question about Sql users. I have a sql user that is added in the security section of the actual database. I have the same user located in the instance level of security. I deleted the user at the i…
I have the following substring issue..and not working for me
So the DiscussionTypeNumber has a prefix of 3 characters that needs to be removed to join to the c.nid value.
sql server 2008 r2
I have an id_column that is varchar(50)
I have this query where I'm trying to pullout data in sequence piece by piece. into a text file.
I am trying to update the table. where I have following columns:
folioNo is the order
pgPos is either right or left (if folioNo is odd then put L (left) if even put R(right…
I have deployed a SSIS package on my sql server 2012 integration service. its in my production environment and to execute the package I do not see the option of right clicking on the package and execu…
We have SQL Server 2012 and a database has few tables that have different Collation then Temp db.
Is there any way that collation changes can be down without or minimum downtime? Data in the t…
Hi Experts, We have upgraded SQL Server 2014 Alwayson and we are getting issues on cluster sudden failures. the cluster fail-over happening suddenly and getting resolved automatically after sometime. …
from time to time our TEST DB will reported to have data lost from users/tester, e.g. they enter the data yesterday or hours ago and it gone.
I found out sth like if the tempdb has conte…
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…
Lets say I have one table. with n number of columns.
I would like to create a new table that made a new row for each column name and the value of that row would be the value from that column
Yes, I have twelve files embedded. And, yes, once again I'm having trouble with very simple T-SQL syntax.
A lot of the files that I have attached are for background purposes. What I'm h…
See attachments for tables
Problem: How to query to show bonus when sales exceed tier level for each year
Don't know what happened with my computer. I had issues with Visual Studio and SQL Server. I reinstalled VIsual Studio and that resolved that issue. I repaired SQL Server but i'm still having and i…
I am installing SCCM2012 on Windows 2012 server, during the installation when I have to define the SQL server name and DB name, if I choose our SQL server which is running SQL 2014 on a separa…
ACT! system requirements state it is certifies for 2008 & 2012, it also mentions "other versions". Can anyone confirm if ACT! v16.2 runs without problems on SQL 2014?
I want to create a stored procedure with the following script below. Reason being I want schedule this procedure as a job. How can I do this?
Perplexed by SQL Server date styles (http://msdn.microsoft.com
The purpose of this article is to demonstrate how to retrieve data from an Excel sheet and put it in a table in a SQL Server database. Introduction Anyone who's ever used a computer for a sig…
Zürich, Kanton Zürich, Switzerland
21,776 points this week
10,782 points this week
Pawan Kumar Khowal
Railway Road Gurgaon, Haryana, India
8,500 points this week
8,000 points this week
7,000 points this week