How to remove invisible characters in t-sql?
The ASCII code for tab is 9; you could try update tablename set columnname = replace(columnname, char(9), ”)
t-sql
Removing a default constraint after adding a new column in code first
Personally I can see nothing wrong with the first approach. Yes, you have to create a default constraint to add a non-nullable column to a non-empty dataset. And yes, you have to delete it afterwards if you need to make sure the new column is always added explicitly in the future, as per your requirement. … Read more
Multiple argument IF statement – T-SQL
You are doing it right. The empty code block is what is causing your issue. It’s not the condition structure 🙂 DECLARE @StartDate AS DATETIME DECLARE @EndDate AS DATETIME SET @StartDate = NULL SET @EndDate = NULL IF (@StartDate IS NOT NULL AND @EndDate IS NOT NULL) BEGIN print ‘yoyoyo’ END IF (@StartDate IS NULL … Read more
T-SQL: select rows not equal to a value, including nulls
Try checking for NULL explicitly: SELECT TOP 30 col1, col2, …, coln FROM Mails WHERE (assignedByTeam <> ‘team01’ OR assignedByTeam IS NULL)
Set column as primary key if the table doesn’t have a primary key
This checks if primary key exists, if not it is created IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_TYPE = ‘PRIMARY KEY’ AND TABLE_NAME = ‘Persons’ AND TABLE_SCHEMA =’dbo’) BEGIN ALTER TABLE Persons ADD CONSTRAINT pk_PersonID PRIMARY KEY (P_Id) END ELSE BEGIN — Key exists END fiddle: http://sqlfiddle.com/#!6/e165d/2
How to improve a case statement that uses two columns
You could do it this way: — Notice how STATE got moved inside the condition: CASE WHEN STATE = 2 AND RetailerProcessType IN (1, 2) THEN ‘”AUTHORISED”‘ WHEN STATE = 1 AND RetailerProcessType = 2 THEN ‘”PENDING”‘ ELSE ‘”DECLINED”‘ END The reason you can do an AND here is that you are not checking the … Read more
Can I Use Order by to sort Stored Procedure results?
I checked jamietre link, and this is the complete answer: Create table #MyTempTable (output varchar(max)) INSERT INTO #MyTempTable EXEC xp_cmdshell ‘tasklist’ select * from #MyTempTable where output like ‘ie%’ order by output Thanks for all…
How to update multiple tables at the same time?
You can’t update fields from multiple tables on a single update query. There error you are getting is because this is not permitted: update a, b, c Since you can only update one table per update command.
Declare a variable in DB2 SQL
I assume this forum posting, which I quote fully below, should answer the question. Inside a procedure, function, or trigger definition, or in a dynamic SQL statement (embedded in a host program): BEGIN ATOMIC DECLARE example VARCHAR(15) ; SET example=”welcome” ; SELECT * FROM tablename WHERE column1 = example ; END or (in any environment): … Read more
Execute stored procedure with table values as parameter
Look at this You can find an example DECLARE @data ObjectList INSERT @data (Id) VALUES (1) EXEC GetData @data