A query, in SQL, is a command used to request data or update information from a database table or combination of tables. Users can write and execute queries to retrieve, delete or update information in a database. Usually, a query response returns data from different tables within the data...
20,305 questions with SQL Server-related tags Sort by:Updated UpdatedCreatedAnswers 0 answers Improving SP performance using Non Clustered Index. Hi Team, I need to improve performance of a SP which is in a Database in SQL Server. 1.One of the Select query uses a Table, which is having...
2 answers SSIS Package Fails in Validation (Excel Destination) Hi, I have been frustratingly trying to deal with a very odd problem. I created a package to handle the filling of an Excel file from a SQL query. I spent a couple days debugging, making sure it worked through manual execu...
1 answerOne of the answers was accepted by the question author. Breakdown text into multiple records Greetings... I'm working on a SQL Server query where I have to breakdown text stored in Comments column which is of datatype varchar(max) into multiple records. For instance, if there are...
With this information, I can construct an SQL query to count the number of active customers from the UK.", "plan": "- Execute an SQL query using the 'execute_sql' command to count the number of active customers from the United Kingdom.\n- The query will count rows where 'country' ...
SQL Query question Hello: I have 2 tables where it doesn't have standard\common columns and don't have the same columns. There is no relationship between Table Cust_Tab" and "Table_Schema_Info. Attached sample data file. Any pointer is appreciated....
customers.customer_id\n-- sales.salesperson_id can be joined with salespeople.salesperson_id\n-- product_suppliers.product_id can be joined with products.product_id\n\n### SQL\nGiven the database schema, here is the SQL query that answers `What is our total revenue by product in the ...
(nvarchar(max), b.text)) * 2 else a.statement_end_offset end - a.statement_start_offset)/2) AS Query_Text, dbname=Upper(db_name(b.dbid)), b.objectid AS 'Object_ID' FROM sys.dm_exec_query_stats a CROSS APPLY sys.dm_exec_sql_text(a.sql_handle) AS b ORDER BY [Avg_CPU_...
Build user-oriented software and let your customers be data driven with Active Query Builder! Get Started Why? Business usersrequire information to make decisionson the spot with no extra assistance. How? We know how totransform user questions into SQL queriesin a friendly and safe graphical UI...
With a well-configured trace, you can monitor both read and write access in all databases for selected users or for applications (such as Enterprise Manager and Query Analyzer), while limiting tracing so it captures only the info you want and excludes normal application activity. ...