logo
down
shadow

SQL-SERVER QUESTIONS

FreeTDS working, but ODBC cannot connect
FreeTDS working, but ODBC cannot connect
it fixes the issue I am trying to run connect to a MSSQL server from an Ubuntu 12.04 webserver with FreeTDS and unixODBC. , The issue was this line in odbc.ini
TAG : sql-server
Date : December 01 2020, 04:55 PM , By : VYoung
How to change datetime format of varchar datatype column
How to change datetime format of varchar datatype column
To fix the issue you can do You can use Try_Convert() in concert with IsNull()To be clear. The result is still a string
TAG : sql-server
Date : November 29 2020, 01:01 AM , By : pantalo
Trigger on extended properties? SQL SERVER
Trigger on extended properties? SQL SERVER
Does that help Does SQL Server allow triggers on extended properties, table level or column level? , You can use a DDL trigger for this.
TAG : sql-server
Date : November 26 2020, 01:01 AM , By : Jimmy Sun
Database Schema guidance for an app store
Database Schema guidance for an app store
it helps some times Apple and Google are not releasing a public documentation of their backend architecture for their respective app stores. Although there are a few examples of actual data model for this scenario easily found using Google, for insta
TAG : sql-server
Date : November 26 2020, 01:01 AM , By : Hola
sql trigger to update based on specific column is updated and if value is equal to 'x'
sql trigger to update based on specific column is updated and if value is equal to 'x'
This might help you Basically I have a nvarchar column names MyTargetColumn, I want the trigger to do an update but only if that column is effected and the column's new value = 'x'
TAG : sql-server
Date : November 26 2020, 01:01 AM , By : Christian Bunch
How to descope a local variable in t-sql
How to descope a local variable in t-sql
This might help you If the variables represent the same thing, just declare them outside the IF statement and "re-use" them.
TAG : sql-server
Date : November 25 2020, 07:27 PM , By : GuruCharan Singh
SQL Server Compact stored procedure with multiple values in 1 input
SQL Server Compact stored procedure with multiple values in 1 input
Does that help I'm using SQL Server Compact edition with the following stored procedure: , To split CSV to rows use this code
TAG : sql-server
Date : November 24 2020, 01:01 AM , By : user2957668
How to validate the ICCID number of a SIM card in TSQL?
How to validate the ICCID number of a SIM card in TSQL?
may help you . I have been wondering if there is the possibility of validating that big number that is the unique code for every SIM card on the planet, the ICCID. , I Found it!
TAG : sql-server
Date : November 24 2020, 01:01 AM , By : user2957500
how to calculate all previous datas sum of a sql column on a date range report
how to calculate all previous datas sum of a sql column on a date range report
wish of those help I have a crystal report with debit credit columns using a sql command. This report contains a date to date filtering parameters. So the problem is if i filter the report to date range i need all the previous data sum using a sql co
TAG : sql-server
Date : November 22 2020, 03:03 PM , By : Chris Swaine
How to create view listing all friendship for "friend1,friend2" table in T-SQL and prevent inserting duplicate
How to create view listing all friendship for "friend1,friend2" table in T-SQL and prevent inserting duplicate
wish of those help I have table defined as follows: , Seems like this would work, I have not tested it thoroughly:
TAG : sql-server
Date : November 22 2020, 03:03 PM , By : user2956847
Sum of multiple column in SQL Server
Sum of multiple column in SQL Server
I wish did fix the issue.
TAG : sql-server
Date : November 22 2020, 10:56 AM , By : Gildas
Check month and day lies between two dates
Check month and day lies between two dates
Hope that helps I have two fields which stores month and day separately. I have a requirement where I need to check the month and day fields(in the format MM/DD) should lie between two dates. For example, if I have month and day fields stored as (02/
TAG : sql-server
Date : November 22 2020, 10:54 AM , By : user2956372
How would I configure Effort Testing Tool to mock Entity Framework's DbContext withOut the actual SQL Server Database up
How would I configure Effort Testing Tool to mock Entity Framework's DbContext withOut the actual SQL Server Database up
wish of those help You only need that connection string because Effort needs to know where the EDMX file is.The EDMX file contains all information required for creating an inmemory store with an identical schema you have in your database. You have to
TAG : sql-server
Date : November 22 2020, 10:54 AM , By : user2956253
While looping through a function, Error: Maximum stored procedure, function, trigger, or view nesting level exceeded (li
While looping through a function, Error: Maximum stored procedure, function, trigger, or view nesting level exceeded (li
I wish did fix the issue. Im going to assume that the purpose of this exercise is to split the values out of the columns so that you can then normalise your data. regarding the actual error read @Amir's answer regarding helping you with solving your
TAG : sql-server
Date : November 22 2020, 10:48 AM , By : user2955926
Collapsing records with adjacent start and end dates
Collapsing records with adjacent start and end dates
I wish this helpful for you Since your ranges are continuous, the problem essentially becomes a gaps-and-islands one. © Andriy M to Steve Ford for the table:
TAG : sql-server
Date : November 22 2020, 10:38 AM , By : user2955357
SQL Server Management Studio 2008 - Timeout Expired error
SQL Server Management Studio 2008 - Timeout Expired error
wish of those help After some more research I found out why the issue occurs in the most common scenarios, which are when you develop an interface in .NET and you need to specify a default time-out time for the session which you use to communicate wi
TAG : sql-server
Date : November 22 2020, 10:33 AM , By : Brad Jones
Insert date from VB to SQL Server
Insert date from VB to SQL Server
help you fix your problem I am trying to insert a date with time and minute into my SQL Server which has a column of type date. , This is one of the many reasons to use a parameterized query
TAG : sql-server
Date : November 22 2020, 01:01 AM , By : Лазар Дмитро
How to find what table foreign key is from?
How to find what table foreign key is from?
Does that help I have a table with a foreign key. How can I tell what table the FK is a primary key in? There's about 200 tables and I don't know how to find where that info is coming from/connected to. , Use this..
TAG : sql-server
Date : November 21 2020, 07:31 AM , By : user2953937
Sql Server Nested Inserts possible
Sql Server Nested Inserts possible
this one helps. This should do the trick, you can use the APPLY operator to unpivot a table.
TAG : sql-server
Date : November 21 2020, 01:01 AM , By : user2953645
Deterministic way of getting WeekEnding (Sun) for given date column (for use in computed column)
Deterministic way of getting WeekEnding (Sun) for given date column (for use in computed column)
wish of those help A kind of ugly but solid solution would be, to rely on a fixed date value, and then use the date difference modulo 7 as an alternative to the DATEPART function:
TAG : sql-server
Date : November 20 2020, 01:01 AM , By : Lucia Fernandez
SQL Server, why does one order by query work with a string, but not with an integer?
SQL Server, why does one order by query work with a string, but not with an integer?
help you fix your problem Since you need to know the SortOrder of the Parent, when at the Child Level, you need a subquery in your ORDER BY-clause as suggested elsewhere, or alternatively do a self-join like this (to find the parent record from which
TAG : sql-server
Date : November 19 2020, 03:59 PM , By : user2952997
How do I install a SQL Server on the hosted build agent in Visual Studio Online?
How do I install a SQL Server on the hosted build agent in Visual Studio Online?
I hope this helps . for all your help.I contacted @tamasf who is one of the developers for the Effort Testing Tool for Entity Framework, and he told me that Effort Testing Tool only needs to know about he EDMX file in order mock Entity Framework ( wh
TAG : sql-server
Date : November 19 2020, 03:59 PM , By : Hiren
EXECUTE AS/REVERT within a transaction in SQL Server
EXECUTE AS/REVERT within a transaction in SQL Server
hop of those help? Database transactions (SqlTransaction) are session-scoped rather than user-scoped so you can use EXECUTE AS and REVERT within the same transaction (and database connection).
TAG : sql-server
Date : November 19 2020, 01:01 AM , By : user2952474
Distinct 2 field AS one column SQL SERVER
Distinct 2 field AS one column SQL SERVER
around this issue You can use Union keyword which will give distinct elements from Both Tables
TAG : sql-server
Date : November 19 2020, 12:41 AM , By : Cristian DJ-Xriz
how to create a new database after a trigger fired from a table
how to create a new database after a trigger fired from a table
may help you . Although this seems a pretty strange thing to do, if you really have to then create an Agent job that simply restores the database from a backup. In the trigger, you could run the job with:
TAG : sql-server
Date : November 18 2020, 03:49 PM , By : Kamal Deshapriya
How to sort string alphabetically
How to sort string alphabetically
it should still fix some issue May be try the below link which might help http://social.technet.microsoft.com/wiki/contents/articles/19492.sort-letters-in-a-phrase-using-t-sql.aspx
TAG : sql-server
Date : November 18 2020, 11:13 AM , By : Prajwesh Shetty
Checking data in one column in a temp table to a column in another table
Checking data in one column in a temp table to a column in another table
seems to work fine I have a column in a temp table, that contains different values for each row. I want to check to make sure the values in that column exist in any row in a different table. If they do not, RaisError is called. I can do this if there
TAG : sql-server
Date : November 17 2020, 11:55 AM , By : Streggy
What's wrong with my IF/ELSE? "ELSE: Incorrect syntax near 'ELSE'."
What's wrong with my IF/ELSE? "ELSE: Incorrect syntax near 'ELSE'."
Does that help I have code similar to this: , IF - Else syntax is
TAG : sql-server
Date : November 17 2020, 11:55 AM , By : user2950480
CASE CLAUSE IN WHERE CONDITION
CASE CLAUSE IN WHERE CONDITION
To fix this issue I want to create a stored procedure that accepts an optional argument. I want to accomplish something like the following: , Try this.
TAG : sql-server
Date : November 17 2020, 11:52 AM , By : user2950280
TSQL - Creating a running total of a column
TSQL - Creating a running total of a column
I wish did fix the issue. I am writing a production record report and am having some difficulty. Here is what I am trying to accomplish: , Test Data
TAG : sql-server
Date : November 17 2020, 11:52 AM , By : hoang thao
Why am I getting not null here?
Why am I getting not null here?
wish of those help Because NULL NULLIn case statement you comparing NULL = NULL it failed so NOT NULL got selected.
TAG : sql-server
Date : November 17 2020, 11:52 AM , By : Áhmed Marhoon
Why does sp_refreshview raise an exception on views that are not schema bound?
Why does sp_refreshview raise an exception on views that are not schema bound?
seems to work fine It looks to me like sp_refreshview should be run from the database that houses the view. So change the execute line to:
TAG : sql-server
Date : November 17 2020, 01:00 AM , By : user2949534
EXEC parameters from a SELECT
EXEC parameters from a SELECT
seems to work fine I have a SP like this with dozens of parameters: , How about this.
TAG : sql-server
Date : November 17 2020, 01:00 AM , By : ãÓÊæÑ
SQL Server Compact connection
SQL Server Compact connection
I wish this help you To connect to Compact Edition databases, you need to instead use SqlCeConnection (in the System.Data.SqlServerCe namespace, if you haven't already imported it), so instead, I'd expect your code to look a little like:
TAG : sql-server
Date : November 16 2020, 06:23 AM , By : user2949190
Star Schema Structure - To many Dimensions
Star Schema Structure - To many Dimensions
Does that help Do not put the description in the fact table. The purpose of the fact is to measure events. Dimensions show the possible attributes of an event, even if the event hasn't occurred. A restaurant menu would be a dimension, the food ordere
TAG : sql-server
Date : November 15 2020, 06:54 AM , By : user2948764
sort utf string in sql server with join clause
sort utf string in sql server with join clause
wish help you to fix your issue I found the problem! The problem was in my stored data, the string data in my table is in "Persian" language but some of the characters are "Arabic" which look almost exactly like Persian :
TAG : sql-server
Date : November 14 2020, 04:51 PM , By : Daniel
shadow
Privacy Policy - Terms - Contact Us © ourworld-yourmove.org