Even though I am removing and trying to drop table, I get error, ALTER TABLE [dbo].[Table1] DROP CONSTRAINT [FK_Table1_Table2] GO DROP TABLE [dbo].[Table1] GO
Just wondering if someone could explain how Multiple Active Result Set (MARS) works in SQL Server as it is not very clear on the MSDN site. (A) On a MARS conn
I got some non-clustered indexes (unique) with uniqueidentifier (GUID) as column. The index gets a lot of fragmentation all the time. How should I solve this
I'm trying to pivot a table around it's many columns to get to 3 columns (pivot, column name, value) so for example: name | age | gender ------+-------+--
I am trying to access SQL DB that is located on my computer from an application that is located on a server (has IIS7). I set the ConnectionString in the WebCon
I am using the sqlsrv ms drivers for php, which work fine (tested with normal queries). I have also tested it with running a stored procedure to update a table
I am trying hard to get the 12 months names in Arabic , I tried a lot but nothing work. any help ?
Here I have 2 tables, Employee and Department, and the data as follows. Employee: Empid Empname Deptid salary ----------------------------------------- 1
Is it possible in Microsoft SQL Server generate random int value from Min to Max (3-9 example, 15-99 e.t.c) I know, I can generate from 0 to Max, but how to inc
I am publishing a project application and I think having a connectionstring with this format cn.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=C
I can't seem to find an answer to this anywhere --- I want to convert a datetime in SQL to the excel serial number. I'm essentially looking for the DATEVALUE f
In my .NET (C#) win application, I import an Excel file that contains multiple columns of varying numbers. So, I store the data in my datatable in code and I ne
Error Message: The SELECT permissions was denied on the object 'quote', database 'oneview', schema 'dbo'. I am relatively new to SQL and the developer I am le
I have a huge dataset in SQL server, I want to Connect the SQL server with python, then use pyspark to run the query. I've seen the JDBC driver but I don't fin
I used SQL Server 2019 express version on my laptop butI uninstalled. Now I am trying to install SQL Server 2019 Developer edition but I get an error: Exit code
I would like to access a Azure SQL database. It is accessible on port 1433. However, the firewall is blocking this request. Therefore, I wold like to tunnel my
We have a MVC application running with SQL Server database. We are using windows authentication, and when we want to give user access to our site we add them i
I inherited some old stored procedures today, and came across several examples that followed this general pattern, where @Test is some INT value: IF @Test IS N
I use SQL Server 2016 Management Studio. After I connect to the server and click on "new query", a message appears: The Visual Studio cache is out of date
To download and install Microsoft SQL Server 2008 R2, I followed these steps from http://www.microsoft.com/en-in/download/details.aspx?id=22985: Download and i