Forum Widgets
Latest Discussions
Question about decimal numbers in SQL Server Management Studio
Hello, everyone, I am new using SSMS, I created a data base. I used the "import flat file option" to import a csv file, in preview data I uncheck the use rich data type detection, in the modify colum section I see that temp and atemp are float, hum is nvarchar(50) I can see the decimal numbers in a text editor and preview data in SSMS. The file has some colums have decimal numbers, this is part of the table in SSMS preview data: After I import the file, I run select * from bike_share_yr_0 , the temp and atem are not decimal numbers I tried using ChatGPT to see if there are something I can change in the configuartions of SSMS, but nothing worked. Other option is doing some calculations like: UPDATEbike_share_yr_0 SET atemp = atemp / 10000; This work fine for few colums, but what happend if a have a lot of files an every colum have decimales like atemp. Is possible to fix and see in SSMS the decimal numbers like in preview data? What can I do to fix that? Thank you for helping
SQL Server
Hi everyone, so its my first time downloading SSMS and SQL Server. I have download the SSMS, but when I tried download SQL Server it always error. I have tried to re-install, deleted all SQL Server reference, and follow this guide https://www.sqlcoffee.com/Tips0026.htm My last error saying Can you help me to figure and fix the error? I have attached the detail and summary txt in the drive link https://drive.google.com/drive/folders/1GSCok73nLQUaplbfDulumgGJlI2mN0f9?usp=sharing
SSRS subscription
Hi all, I hv a question about SSRS subscription under mssql 2022 STD, I saw when i subscript to a report, it will create a job under SSMS jobs. I would like to manage the report subscription not run on the specified date store in some table in the database. Is it possible to run another job to use sp_update_job to disable the job when date is find in the table, and enable the job when the date is not find in the table. Because the SSRS's job contain a remarks that "modify this job will make database incompatible", im not sure is it work. thanks in advance.
Assistance Required for Downloading SQL Server 2014 ESU Patch for Standalone Installation
Hi Microsoft Support Team, I am reaching out for assistance regarding an issue I am encountering while trying to download the SQL Server 2014 Extended Security Updates (ESU) patch for a standalone installation. Despite several attempts, I am unable to download the necessary patch from the Microsoft Update Catalog or any other available resources. Here are the details of the issue: Product: SQL Server 2014 Problem: Unable to download the ESU patch for standalone installation. Steps Taken: I have searched for the appropriate SQL Server 2014 ESU patch in the Microsoft Update Catalog, but I was unable to locate the correct patch for manual download. This patch is critical to maintain the security of our systems, and I would appreciate your assistance in either providing the download link or helping resolve this issue so I can successfully install the necessary security updates. Could you please guide me on the correct procedure or provide an alternative download method for the SQL Server 2014 ESU patch? If there are any eligibility requirements for accessing this patch, kindly let me know how to verify or fulfill those requirements. Thank you for your prompt attention to this matter. I look forward to your guidance and resolution.SQL Server 2022 Error -2068052377
Hi everyone, so its my first time downloading SSMS and SQL Server. I have download the SSMS, but when I tried download SQL Server it always error. I have tried to re-install, deleted all SQL Server reference, and follow this guide https://www.sqlcoffee.com/Tips0026.html My last error saying Can you help me to figure and fix the error? I have attached the detail and summary txt in the drive link https://drive.google.com/drive/folders/1GSCok73nLQUaplbfDulumgGJlI2mN0f9?usp=sharing
Single pane of glass to look at all of my SQL Servers
I just got back from SQL Pass Summit 2024 and I was told that I could ARC enable all of my SQL Servers so I would have a single pane of glass to view and scan logs, configurations, view best practices etc. Unfortunately, when I got home, I realized that since we have SQL Servers on Azure VMs we can't use Azure ARC to manage them. Unsupported configurations Azure Arc-enabled SQL Server doesn't currently support the following configurations: ... Multiple instances of SQL Server installed on the same host operating system with the same instance name. SQL Server in Azure Virtual Machines. An Always On availability group where one or more replicas is on a failover cluster instance. Since all our Azure VMs have the SQL Agent installed how can we unify our management experience in Azure?
SQL Server Management Studio fails to recognize the table
Hi, ALL, 'm C/C++ developer who is trying to write some application that will talk to SQL Server. I have the server running and I have MS installed. In the MS I opened a tab for a new query and issue: CREATE TABLE "abcattbl"(abt_os tinyint, abt_tnam nchar(129) NOT NULL, abt_tid integer, abt_ownr nchar(129) NOT NULL, abd_fhgt smallint, abd_fwgt smallint, abd_fitl char(1), abd_funl integer, abd_fstr integer, abd_fchr smallint, abd_fptc smallint, abd_ffce char(18), abh_fhgt smallint, abh_fwgt smallint, abh_fitl char(1), abh_funl integer, abh_fstr integer, abh_fchr smallint, abh_fptc smallint, abh_ffce char(18), abl_fhgt smallint, abl_fwgt smallint, abl_fitl char(1), abl_funl integer, abl_fstr integer, abl_fchr smallint, abl_fptc smallint, abl_ffce char(18), abt_cmnt nchar(254) ); CREATE UNIQUE INDEX abcatt_x ON abcattbl( abt_os ASC, abt_tnam ASC, abt_ownr ASC ) WITH (IGNORE_DUP_KEY = ON); I executed those and got "Completed successfully" I refresh the table list and I see the table named abcattbl in the list. Next I opened another tab and tried to issue following: /****** Script for SelectTopNRows command from SSMS ******/ IF NOT EXISTS(SELECT * FROM abcattbl WHERE abt_tnam='abcatcol' AND abt_ownr='dbo') INSERT INTO "abcattbl" VALUES( 0, 'abcatcol', (SELECT object_id FROM sys.objects o, sys.schemas s WHERE s.schema_id = o.schema_id AND o.name = 'abcatcol' AND s.name = 'dbo'), '', 8, 400, 'N', 0, 0, 34, 0, 'MS Sans Serif', 8, 400, 'N', 0, 0, 34, 0, 'MS Sans Serif', 8, 400, 'N', 0, 0, 34, 0, 'MS Sans Serif', '' ); And I got "Invalid object name: abcattbl" and the table name is highlighted with the red squiggly, So on one hand the table is created successfully, but trying to use it gives an error? How to override this? My system for development is dated - I;m on Win8,1 with SQL Server 2012 and SQL Server MS 11.0. I have another problems with C++ code I'm wriiting, but its different and needs another thread... Thank you,
