sql-server-2008-r2 Questions
3
Solved
In the MSDN is clearly said that:
The date argument cannot be incremented to a value outside the range of its data type. In the following statements, the number value that is added to the date v...
Evasive asked 22/2, 2012 at 19:31
4
If you create temp tables using "insert into" in SQL Server it uses the first insert to determine whether a column accepts null value or not. if the first insert has null value the column become nu...
Savonarola asked 7/3, 2013 at 6:34
2
After installing Visual Studio 2008 and SQL Server 2008 on Windows 7, I get the following error when connecting to a server with SQL Management Studio:
Unable to cast COM object of type 'System....
Reeher asked 31/10, 2009 at 13:0
6
How can I get the AVG of a column ignoring NULL and zero values?
I have three columns to get their average, I try to use the following script:
SELECT distinct
AVG(cast(ISNULL(a.SecurityW,0) as b...
Baggage asked 2/7, 2013 at 11:57
5
Solved
I have a routine in our .NET web application that allows a user on our platform to clear their account (i.e. delete all their data). This routine runs in a stored procedure and essentially loops th...
Dildo asked 27/2, 2013 at 14:24
5
I am working in a database where I load data in a raw table by a data loader. But today the data loader got stuck for unknown reasons. Then I stopped the data loader from windows task manager. But ...
Hydroxyl asked 24/11, 2011 at 14:35
7
I have a situation in my SQL Server 2008.
I need to change a column type, but the indexes are preventing the changes. But because of the database is on several clients, I don't know how many index...
Jacquelynnjacquenetta asked 5/7, 2013 at 12:17
3
Solved
Is a statement in SQL Server ACID?
What I mean by that
Given a single T-SQL statement, not wrapped in a BEGIN TRANSACTION / COMMIT TRANSACTION, are the actions of that statement:
Atomic: either...
Clutch asked 30/1, 2014 at 22:26
5
Solved
I have a query with the following result:
query:
SELECT Tasks.TaskId, Comments.Comment, comments.timespent
FROM comments
INNER JOIN tasks ON comments.entityid = tasks.taskid
WHERE ( comments.en...
Isotone asked 27/1, 2014 at 17:36
6
Solved
I would like to alter the table if the table has the column with same data type and number exists
Original tTable structure is
TableName
ColumnName NVARCHAR(100)
Code for altering column if C...
Rashida asked 31/12, 2013 at 15:3
5
Solved
I have a bunch of dates in varchar like this:
20080107
20090101
20100405
...
How do I convert them to a date format like this:
2008-01-07
2009-01-01
2010-04-05
I've tried using this:
SELECT ...
Slating asked 9/3, 2013 at 23:56
5
Solved
How can i get to know the tables used in a view in SQL Server? Is there a script or a tool that could let me know the tables used in a view and can also list down the fields?
Hope this clears the ...
Bamboo asked 29/11, 2011 at 9:13
10
Solved
I've been working on this for about a day and a half now, and searched numberous blogs and help articles on the Web. I found several questions on SO related to this error, but I didn't think they q...
Lollygag asked 15/6, 2011 at 13:54
11
Countless times during the day I am copying and pasting records from SQL Server Management Studio to Excel.
My problem is that a DateTime value such as 8/23/2013 4:51:02 PM does not display corre...
Thyratron asked 3/9, 2013 at 17:24
3
Solved
We're maintaining (and occasionally debugging) a large in-house system. The system has 20+ databases, and a number of servers interfacing to other systems, processing data, etc. Not all is in-house...
Kratzer asked 17/2, 2012 at 11:25
3
I used to install SQL Server Management Studio 2014 it was ok, but after I reset my laptop and install it again the SQL Server it doesn't work at all.
It can't not find Server Name
In SQL Server...
Cytoplasm asked 26/9, 2016 at 16:23
2
I created three certificate by using openssl
Root CA certificate
Server certificate
Client certificate
Server side configuration :
I installed server.cer(peronal folder) and RootCA(trust root...
Pissarro asked 10/8, 2016 at 8:37
15
Solved
I have MS SQL 2008 R2, 500 databases.
What is the most efficient, easiest and 'modern' way to query all databases sizes.
The output should have columns:
DatabaseName
DataFilesSize
LogFilesSize
...
Draftsman asked 10/5, 2011 at 5:0
6
Solved
I am using SQL Server 2008 R2, I have a script to update the DB, that script is approx
50 MB in size and contains some about 800,000 lines.
Error:
TITLE: Microsoft SQL Server Management Studio...
Verbality asked 3/7, 2012 at 8:47
1
When I attempt to deploy DACPACs via SqlPackage.exe,
I encounter the error below :
An unexpected failure occurred: Object reference not set to an instance of an object..
Unhandled Exception: Syste...
Barham asked 11/7, 2016 at 14:7
3
Solved
I have an SQL table in which I store large string values that must be unique.
In order to ensure the uniqueness, I have a unique index on a column in which I store a string representation of the MD...
Odiliaodille asked 4/2, 2016 at 11:59
5
Solved
I have a table with hierarchical data in it, the structure goes like this:
ID ParentId
---- ----------
1 NULL
2 1
3 2
4 2
5 3
6 5
If I pass the node Id I would like to get the top most node Id/d...
Tuberose asked 2/7, 2014 at 5:35
11
I am working with SQL Server 2008 R2. I am unable to connect to my database remotely. I got the following error.
A network-related or instance-specific error occurred while establishing a connec...
Dreadful asked 27/9, 2012 at 10:13
5
Solved
I am using SQL Server 2008 R2. I need to list out all the stored procedures that a database user (MYUSER) has execute permission.
Also, I need to list out which are the stored procedures that the...
Loupgarou asked 31/10, 2012 at 6:22
7
Solved
I have an SSIS package thats unzips and loads a text file. It has been working great from the debugger, and from the various servers its been uploaded to on its way to our production environment.
M...
Honk asked 1/2, 2013 at 18:45
© 2022 - 2024 — McMap. All rights reserved.