get the text of a stored procedure into a variable in SQL Server

Đưa tất cả text trong procedure vào biến chuỗi SQL:

declare @source_code varchar(max)
declare @objectid int
select @objectid=object_id('dbo.my_stored_procedure_name')
select @source_code = object_definition(@objectid )

52 most useful apps for Android

Ace Stream Media [Ace Stream]: https://play.google.com/store/apps/details?id=org.acestream.media
AlReader [Alan.Neverland]: https://play.google.com/store/apps/details?id=com.neverland.alreader
AnkiDroid [AnkiDroid Open Source Team]: https://play.google.com/store/apps/details?id=com.ichi2.anki&hl=vi
App Backup & Restore [Trustlook Apps]: https://play.google.com/store/apps/details?id=mobi.usage.appbackup&hl=vi
Automatic Tag Editor [fillobotto]:https://play.google.com/store/apps/details?id=com.fillobotto.mp3tagger&hl=vi
BÁO MỚI [ePi Technologies, JSC]: https://play.google.com/store/apps/details?id=com.epi&hl=vi
ColorNote [Notes]: https://play.google.com/store/apps/details?id=com.socialnmobile.dictapps.notepad.color.note&hl=vi
CPU-Z [CPUID]: https://play.google.com/store/apps/details?id=com.cpuid.cpu_z&hl=vi
Diaro [Pixel Crater Ltd.]: https://play.google.com/store/apps/details?id=com.pixelcrater.Diaro&hl=vi
Dropbox [Dropbox, Inc]: https://play.google.com/store/apps/details?id=com.dropbox.android&hl=en
Duolingo [Duolingo]: https://play.google.com/store/apps/details?id=com.duolingo&hl=en
Evernote [Evernote Corp]: https://play.google.com/store/apps/details?id=com.evernote&hl=en
Facebook Lite [Facebook]: https://play.google.com/store/apps/details?id=com.facebook.lite&hl=vi
Fast Scanner [CoolMobileSolution]: https://play.google.com/store/apps/details?id=com.coolmobilesolution.fastscannerfree&hl=vi
Foody [Foody Corp]: https://play.google.com/store/apps/details?id=com.foody.vn.activity&hl=vi
FX File Explorer [NextApp, Inc]: https://play.google.com/store/apps/details?id=nextapp.fx
Google Photo [Google LLC]: https://play.google.com/store/apps/details?id=com.google.android.apps.photos&hl=vi
HERE WeGo [HERE Apps LLC]: https://play.google.com/store/apps/details?id=com.here.app.maps
Laban Key [Zalo Group]:https://play.google.com/store/apps/details?id=com.vng.inputmethod.labankey&hl=en
Lich Van Nien 2018 - Lich Viet [PPCLINK Mobile]: https://play.google.com/store/apps/details?id=com.somestudio.lichvietnam
Live Football [SKORES]: https://play.google.com/store/apps/details?id=com.sosscores.livefootball&hl=vi
Manga Reader [Manga Reader Online Offline]: https://play.google.com/store/apps/details?id=com.bigberry.mviewer&hl=vi
Memrise [Memrise]: https://play.google.com/store/apps/details?id=com.memrise.android.memrisecompanion&hl=en
Mobizen Screen Recorder [MOBIZEN]: https://play.google.com/store/apps/details?id=com.rsupport.mvagent
MoboPlayer [euphmia]: https://play.google.com/store/apps/details?id=com.clov4r.android.nil.noplug
Money Lover [Finsify]: https://play.google.com/store/apps/details?id=com.bookmark.money
Moon+ Reader [Moon+]: https://play.google.com/store/apps/details?id=com.flyersoft.moonreader&hl=en
MX Player [J2 Interactive]: https://play.google.com/store/apps/details?id=com.mxtech.videoplayer.ad
NhacCuaTui [NCT Corp]: https://play.google.com/store/apps/details?id=ht.nct&hl=en
Phonograph Music Player [Karim Abou Zeid]: https://play.google.com/store/apps/details?id=com.kabouzeid.gramophone&hl=vi
Puffin Web Browser [CloudMosa Inc]: https://play.google.com/store/apps/details?id=com.cloudmosa.puffinFree&hl=vi
QuickPic [Cheetah Mobile]: https://play.google.com/store/apps/details?id=com.alensw.PicFolder
Quoda Code Editor [Quoda]: https://play.google.com/store/apps/details?id=com.henrythompson.quoda&hl=vi
RAR [RARLAB]: https://play.google.com/store/apps/details?id=com.rarlab.rar
Samsung Internet Browser Beta [Samsung Electronics Co., Ltd]: https://play.google.com/store/apps/details?id=com.sec.android.app.sbrowser.beta
Shazam [Shazam Entertainment Limited]: https://play.google.com/store/apps/details?id=com.shazam.android&hl=vi
Skype [Skype]: https://play.google.com/store/apps/details?id=com.skype.raider&hl=en
Snapseed [Google LLC]: https://play.google.com/store/apps/details?id=com.niksoftware.snapseed&hl=vi
Sop to Http [devaward]: https://play.google.com/store/apps/details?id=com.devaward.soptohttp&hl=vi
TeamViewer [TeamViewer]: https://play.google.com/store/apps/details?id=com.teamviewer.teamviewer.market.mobile&hl=vi
TFlat [TFlat Group]: https://play.google.com/store/apps/details?id=com.vn.dic.e.v.ui
Today Weather [todayweather.co]: https://play.google.com/store/apps/details?id=mobi.lockdown.weather&hl=en
Tỉ Số Bóng Đá Trực Tiếp [Football Soccer Scores]: https://play.google.com/store/apps/details?id=holoduke.soccer_gen&hl=vi
UC Browser [UCWeb Inc]: https://play.google.com/store/apps/details?id=com.UCMobile.intl
Unit Converter [Smart Tools co.]: https://play.google.com/store/apps/details?id=kr.sira.unit&hl=vi
WPS Office [Kingsoft Office Software Corp]: https://play.google.com/store/apps/details?id=cn.wps.moffice_eng&hl=en
YouTube [Google LLC]:https://play.google.com/store/apps/details?id=com.google.android.youtube
Zalo [Zalo Group]: https://play.google.com/store/apps/details?id=com.zing.zalo&hl=en
ZEDGE™ Ringtones & Wallpapers [Zedge]: https://play.google.com/store/apps/details?id=net.zedge.android
Zing MP3 [Zalo Group]: https://play.google.com/store/apps/details?id=com.zing.mp3&hl=en
Zing TV [Zalo Group]: https://play.google.com/store/apps/details?id=com.zing.tv3&hl=en
µTorrent® [BitTorrent, Inc]: https://play.google.com/store/apps/details?id=com.utorrent.client

Tạo mã QR code đẹp

QR code Monkey: https://www.qrcode-monkey.com/

Thiết lập:
- Set color:  foreground: màu đen #000000, background màu trắng: #FFFFFF
- Customize design:
 Body Shape và Eye Frame Shape: chọn hình thứ 3
 Eye Ball Shape: chọn hình thứ nhất

App thời tiết tốt nhất

Link Today Weather: CH Play
Link file bản pro APK
Vào cài đặt chọn nguồn dữ liệu lấy từ trang web Dark Sky.

µTorrent®- Torrent Downloader bản PRO

Link tải tại đây.

How to set a default value for an existing column

Cột email của bảng Temp có giá trị mặc định là: abc@gmail.com:

ALTER TABLE Temp ADD CONSTRAINT DF_SomeName DEFAULT N'abc@gmail.com' FOR email

Generate table with define SQL Server

Generate table with define SQL Server

I have 2 tables to manage generate real table with table name and column: Table (TableID, TableName) TableColumn (ColumnID, ColumnName, Datatype, Size) --(Size is size of nvarchar type, ID is auto identity(1,1)) Table: TableID    TableName ---------------------- 1          TopCity TableColumn: ColumnID    ColumnName    DataType    Size ------------------------------------------- 1           CityID        int         null 2           CityName      nvarchar    100 I want to write a procedure to create real table TopCity (CityID, CityName) with column details as described in TableColumn. CREATE TABLE TopCity (     CityID INT IDENTITY(1,1),     CityName NVARCHAR(100) ) This is solution  CREATE PROC AUTOGEN_TABLE     @BangID int AS DECLARE @DanhSachTruong VARCHAR(1000), @TenBang VARCHAR(100)         -- ,@i INT = 1, @j INT = 0 --SELECT @j = COUNT(*) FROM BANG_DULIEU --WHILE @i <= @j BEGIN     SELECT @TenBang = B.TenBang FROM BANG_DULIEU B WHERE BangID = @BangID     SELECT         @DanhSachTruong = COALESCE(@DanhSachTruong + ', ', '') + '' +                     tc.TenTruong                      + ' ' +                     tc.KieuDuLieu                     + '' +                     CASE WHEN tc.DoRong IS NULL                         THEN '' ELSE CONCAT('(',CAST(tc.DoRong AS VARCHAR),')')                     END                     +                     CASE WHEN RIGHT(tc.TenTruong,2)='ID'                         THEN ' IDENTITY(1,1)'                         ELSE ''                     END     FROM BANG_DULIEU t     INNER JOIN TRUONG_DULIEU tc ON tc.BangID = t.BangID     WHERE t.TenBang = @TenBang     --SELECT @TenBang, @DanhSachTruong     EXEC('CREATE TABLE  ' + @TenBang + ' (  ' + @DanhSachTruong + ' )')     --SET @i = @i + 1 END