DECLARE @cars TABLE(id nvarchar(50) NOT NULL, auto nvarchar(50)); INSERT INTO @cars values(1,'Lada Vesta, grey'), (2,'BMW F80, red'), (3,'Hyundai Elantra'); SELECT id, auto, SUBSTRING(auto, 0, CHARINDEX(' ',auto)) AS Make, SUBSTRING(auto, CHARINDEX(' ',auto)+1, CASE WHE...
Appending text to a field that already contains text using TSQL apply cross apply function on condition Arabic question mark Arduino and SQL Server Are there any Bitmap(ped) indexes in SQL Server? Are there MIN(A,B) or MAX(A,B) functions in SQL? Argument data type datetime is invalid ...
Erland: In sp_who2 if you will not find the blocking spid and its inside sp_who then what will you do and as you know we generally have big number of sleeping transactions so very tough to find the culprit hidden inside sp_who. Friday, June 2, 2017 10:51 AMErland: In sp_who2 ...
I am using Fast Report Net/Designer to display data out of a small software linked to a MS SQL Database. Unfortunately one descripition field contains information that is not entirely relevant for the report. I don't want ...
0 substring in sql server 2008 0 My substring is working but i'm getting an extra letter at the end from the ending word 1 SQL Substring Issue 0 SQL Issue using SUBSTRING and LEN 0 Substring in sql server 0 How to use substring in SQL Server 4 Right Substring Statement...
Connect to SSIS Service on machine "localhost" failed Connecting DB2 USING SSIS Connecting to a "Microsoft SQL Server Query File" connecting to Sybase from Sqlserver SSIS. Connecting to the Integration Servic...
Here for Microsoft Edge (you’re not still using Internet Explorer, are you?) And here for Opera. In case you’re using anything else, just google “bitwarden <browser name>” and you’ll find it. NOTE: As you’ll see, about the only annoying thing with Bitwarden is that if you cli...
The argument column is the column from which you'd like to retrieve the substring; it can also be a literal string. The third argument of the SUBSTRING() function is the length of the substring. You can calculate it using the CHARINDEX() and the LEN() functions. You do this by ...
How can I do for MY_LOGIN to check if the procedure PROCEDURE_TO_TEST is running ? What permissions should I grant to MY_LOGIN so that it can do this check? How can I test if this is working? sql-server sql-server-2014 stored-procedures permissions impersonation Sh...
Please start any new threads on our new site at All Forums SQL Server 2000 Forums SQL Server Development (2000) How to find a carriage return in text field?