automatic casting or somethig.. update in dynamic sql
I have dynamic sql in stored procedure: DECLARE @sql nvarchar(1000) SET @sql = 'UPDATE dbo.T_CUS_TSK_TASK '+ 'SET ' + QUOTENAME(@task_field_…
Top 5 comments from a specific post. How to write my SQL
I want to show only the top 5 comments for a specific post (Like the post on facebook where people cant comment them). gbn was kind enough t…
Set a column on a populated table to not allow nulls where lots of rows already are set to null
I've got a table with an active column of type bit that is mostly set to null. The active column was added as an after thought and mistakenl…
- 共 1 页
- 1
