Blogs about: Mssql

Featured Blog

Running cakePHP on IIS

Mike wrote 3 days ago: I am trying to get cakePHP 1.2 running on IIS6 with a MSSQL backend, and so far it’s going pre … more »

Tags: cakephp, php

How to connect MSSQL with php

samsami2u wrote 6 days ago: Please follow the steps given below to connect MSSQL with php: 1. Settings related to your php.ini f … more »

Tags: php, how, to, Connect

The INSERT Statement

gyana wrote 1 week ago: 1. The Basic INSERT Statement It is the most basic statement to insert data into a table. Its syntax … more »

Tags: SQL

It's been a while

Mike wrote 2 weeks ago: I’ve been working on other things recently so have unfortunately left this blog a little quiet … more »

Tags: cakephp

Connecting MSSQL Server with Zend Framework on Linux2 comments

kunalbharati wrote 2 weeks ago: Few days ago we completed a project which used Zend framework and the database was MS Sql Server 200 … more »

Tags: Linux, php, zend framework

Tip of the Day: SQL RANK Statement

blaksheep wrote 1 month ago: About 5 months into my current job, I was asked to come up with a report that ranked scores in orde … more »

Tags: SQL Server, Programming, totd, Tip of the day, Tips, tricks, SQL

Tip of the Day : SQL Dynamic Variables in Stored Procedure

blaksheep wrote 1 month ago: Writing useful and reusable stored procedures is something I struggled with when first learning SQL. … more »

Tags: Programming, SQL Server, technology, totd, Tip of the day, Tips, tricks, SQL

Tip of the Day : SQL Multiple rows to Comma Separated Column

blaksheep wrote 1 month ago: When working with SQL server and normalized data structures, there are often times when you need to … more »

Tags: SQL Server, technology, Programming, totd, Tip of the day, Tips, tricks, SQL, Stuff

Tip of the Day : SQL Union vs Union All

blaksheep wrote 2 months ago: This is another one that I revisist every so often with some of the guys at work. If you have data i … more »

Tags: Programming, SQL Server, totd, Tip of the day, Tips, tricks, SQL

Tip of the Day : SQL Table Variables1 comment

blaksheep wrote 2 months ago: Many times you need to create and use a table temporarily in SQL query or Stored Procedure and then … more »

Tags: SQL Server, Programming, totd, Tip of the day, Tips, tricks, SQL

Tip of the Day : SQL Update from Joined Table1 comment

blaksheep wrote 2 months ago: Updating a table with values from a Joined table. I run into this question from the guys at work qui … more »

Tags: SQL Server, Programming, totd, Tip of the day, Tips, tricks, SQL

You always learn from your mistakes; SharePoint database woes.

slinger wrote 2 months ago: Ran into a very interesting issue about two weeks ago.  The hard drive that our MOSS portal is on g … more »

Tags: SharePoint, MOSS, SQL, ##SSEE, Piss

Getting the last updated Seed value!1 comment

azimyasin wrote 2 months ago: While i was doing work on the FYP! I encountered a problem fetching out data from the mssql DB! Here … more »

Tags: codes, Code, .NET, identity, get id last insert, get identity of last inserted tuple, tuple last id, get seed value

Database Mirroring without Witness3 comments

bondbhai4u wrote 2 months ago: Hi all, this is my first step into the world of blogging so please bear with me… In this post, … more »

Tags: technical, database mirroring, Microsoft

SQL Server Database Publishing Wizard

woaychee wrote 2 months ago: I m just tried out this tool, it can generate entire database (including SP, View and table etc) w … more »

Other SQL optimization tips2 comments

rip747 wrote 3 months ago: Ben started a whirl wind of ideas with his recent post about optimizing SQL queries for better perfo … more »

Tags: Microsoft, SQL, TechSupport, Tips and Tricks

CMS: Asp.net versus PHP

mtatem wrote 3 months ago: I have asked alot of people their opinions on this subject. Basically asp.net versus php in the Cont … more »

Tags: web design, ASP.NET, PHP and MySQL, CMS, php, Microsoft, ASP, mysql, Web Security

MS SQL Server with Linux

vspike wrote 3 months ago: I was wondering if this is possible, and it seems that it is.  I am using Ubuntu 7.10. First I inst … more »

Tags: Linux, ubuntu, freetds, ODBC

Insert multiple row to MSSQL2 comments

koercoe wrote 4 months ago: Bingung…bingung. Sudah dua hari ini mentok bikin script buat nge ‘DUMP’ data ke SQ … more »

Tags: Database, identity, multiple insert, identity_insert


Have your say. Start a blog.

See our free features »

Related Tags
All »

Follow this tag via RSS

Find other items tagged with “mssql”:
Technorati Del.icio.us IceRocket