comparing null values in sql

Original: "SQL" finds tables with unequal row count and self-increment identity value (that is, there are missing rows)Environment:MSSQL ENT 2k8 R2principle: traverse all user tables with self-increment columns, get the number of rows per table and write to the temporary table using the sp_spaceused procedure, and then use the Ident_current function to get the maximum identification value of the table, compare the two and return the resultIF object_id

There is a requirement that it create a SQL Server query that includes cumulative values based on the event time. A typical example is a bank account, because you are saving and taking money at different times each time. For any account, at a point in time to calculate its borrowing (deposits) and credit (withdrawal) of the sum. After each transaction, you want to know the current balance. List A creates a

Tags: object scons cts and select default value NULL log alter1. Modify the field name:ALTER TABLE name rename column A to B2. Modify the field type:ALTER TABLE name ALTER COLUMN field name type NOT NULL3. Modify the field default valueALTER TABLE name add default (0) for field name with valuesIf the field has a default value, you need to remove the constraint for the field before adding a new default value,Select C.name from Sysconstraints aINNER JOI

Label:Read all fields, natural sortDeclare @fields varchar(Max) Select @fields=ISNULL(@fields,"')++Name+',' fromsyscolumnsWhereId=object_id(' Contact')Order byColorderPrint @fieldsRead all fields, sort by nameDeclare @fields varchar(Max) Select @fields=ISNULL(@fields,"')++Name+',' fromsyscolumnsWhereId=object_id(' Contact')Order bynamePrint @fields;Add field, change type, rename, delete fieldAlter TableCompeteagentinfoAddIsfangtupayint Null, ISF