You can easily do this using the following command. Any value of 0 will be turned into a 0 (BIT = false), anything else will be turned into 1 (BIT = true). ALTER TABLE dbo.YourTable ALTER COLUMN YourColumnName BIT The other option would be to create a new column of type BIT, fill it from … Read more
There are three formats of case expression. You can do CASE with many WHEN as; CASE WHEN Col1 = 1 OR Col3 = 1 THEN 1 WHEN Col1 = 2 THEN 2 … ELSE 0 END as Qty Or a Simple CASE expression CASE Col1 WHEN 1 THEN 11 WHEN 2 THEN 21 ELSE 13 … Read more
Please check the ServerName which you provided. It should match with the below shown Name in the UserName textbox, and that name should followed with \SQLEXPRESS:
select t1.id, t1.SomeNumt, SUM(t2.SomeNumt) as sum from @t t1 inner join @t t2 on t1.id >= t2.id group by t1.id, t1.SomeNumt order by t1.id SQL Fiddle example Output | ID | SOMENUMT | SUM | ———————– | 1 | 10 | 10 | | 2 | 12 | 22 | | 3 | 3 | … Read more
You need ALTER TABLE YourTable ALTER COLUMN YourColumn <<new_datatype>> [NULL | NOT NULL] But remember to specify NOT NULL explicitly if desired. ALTER TABLE YourTable ALTER COLUMN YourColumn VARCHAR (500) NOT NULL; If you leave it unspecified as below… ALTER TABLE YourTable ALTER COLUMN YourColumn VARCHAR (500); Then the column will default to allowing nulls … Read more
The suggestions from stb and xiowl are fine if you’re looking for a constant. If you need to use existing fields or parameters which are integers, you can cast them to be floats first: SELECT CAST(1 AS float) / CAST(3 AS float) or SELECT CAST(MyIntField1 AS float) / CAST(MyIntField2 AS float)
The documentation for WAITFOR() doesn’t explicitly lay out the required string format. This will wait for 2 seconds: WAITFOR DELAY ’00:00:02′; The format is hh:mi:ss.mmm.
I was able to get the full text (99,208 chars) out of a NVARCHAR(MAX) column by selecting (Results To Grid) just that column and then right-clicking on it and then saving the result as a CSV file. To view the result open the CSV file with a text editor (NOT Excel). Funny enough, when I … Read more
drop constraint and recreate it alter table Persion drop CONSTRAINT <constraint_name> alter table Persion add primary key (persionId,Pname,PMID) edit: you can find the constraint name by using the query below: select OBJECT_NAME(OBJECT_ID) AS NameofConstraint FROM sys.objects where OBJECT_NAME(parent_object_id)=’Persion’ and type_desc LIKE ‘%CONSTRAINT’
You can create a new db then use the “Restore Wizard” enabling the Overwrite option or: View the contents of the backup file: RESTORE FILELISTONLY FROM DISK=’c:\your.bak’ note the logical names of the .mdf & .ldf from the results, then: RESTORE DATABASE MyTempCopy FROM DISK=’c:\your.bak’ WITH MOVE ‘LogicalNameForTheMDF’ TO ‘c:\MyTempCopy.mdf’, MOVE ‘LogicalNameForTheLDF’ TO ‘c:\MyTempCopy_log.ldf’ This … Read more