SQL SERVER Tutorial – T-SQL: LIKE – BETWEEN – COMMENTS – NULL VALUES – AND/OR/NOT
T-SQL TUTORIAL
Duration : 0:9:51
Archive for the 'tsql' Category
SQL SERVER Tutorial – T-SQL: REPLACE & STUFF – LEN, LEFT, RIGHT – CHARINDEX
T-SQL TUTORIAL
Duration : 0:8:40
SQL SERVER Tutorial – T-SQL: Built-in Functions – Working with NULLS – COALESCE – ISNUMERIC
T-SQL TUTORIAL
Duration : 0:8:31
SQL SERVER Tutorial – T-SQL: Updat a row – Update multiple rows- Update Another Table
T-SQL Tutorial
Duration : 0:5:12
HTTP POST request from xp_cmdshell?
I want to execute POST request from TSQL,
like: www.x.com/Update.aspx?client_no=12&name=new_name.
How can I make use of xp_cmdshell procedure?
Any suggestions?
I’ve not done shelling from SQL (we do scheduled jobs via task scheduler), but simply prefixing ‘http://’ will shell the browser.
However, if what you are trying to do is get SQL to do a parameterized call to a web [...]
SQL SERVER Tutorial – T-SQL: SELECT STATEMENT – ALIASING – CONCATENATING – WHERE
T-SQL Tutorial
Duration : 0:6:31
What should I know as a SQL Server systems administrator?
My background is in accounting and I am a CPA.
On Monday, the IT Department told my boss that they would prefer that I become the system administrator for our ERP system called Vision. Its a program used company-wide to process everything from Timesheets to Accounts Payable to Marketing Opportunities.
I have no training in IT. [...]
Adding Text to a Jpg image?
I need to embed text into an image
using either Server side Script or DLL, API calls or TSQL ! etc
This is not putting text on top of an image in an HTML page its similar to adding a permanent watermark.
Can someone supply the code ?
Thanks in advance
I did this in C# /.NET
Essentially…every time someone uploaded [...]
SQL SERVER Tutorial – T-SQL: Create Temp Table – Bulk Insert
T-SQL Tutorial
Duration : 0:6:14
Need Tuitoring SQL SERVER?
Hi guys,
i need a tuitor, who will teach me TSQL and a little about SQL server adminibstration.I know alot but i need some experience guy to clear my concept.Any PAKISTNAI GUY can help me this.
I will pay the tuition Fees.
Thanks
Ive worked SQL Server for many years. Feel free to email me your questions. [...]