![]() |
how to create ci_sessions table in ms sql server same - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23) +--- Thread: how to create ci_sessions table in ms sql server same (/showthread.php?tid=49826) |
how to create ci_sessions table in ms sql server same - El Forum - 03-05-2012 [eluser]sunil shrestha[/eluser] I am novice to mssql server and I have to create Sql query for mssql server for creating the ci_sessions table same as table sql query provided in the CI user guide which is given in the mysql as below: Code: CREATE TABLE IF NOT EXISTS `ci_sessions` ( And also for Captcha table that I have to convert to MSSQL query. MySQL query is: Code: CREATE TABLE captcha ( Here, I am trying to connect the codeigniter to mssql server using odbc connection. All is working fine but when problem in creating session that should be stored in database due to wrong design of ci_sessions table. Plz help how to create ci_sessions table in ms sql server same - El Forum - 03-05-2012 [eluser]sunil shrestha[/eluser] [quote author="sunil shrestha" date="1330933112"]I am novice to mssql server and I have to create Sql query for mssql server for creating the ci_sessions table same as table sql query provided in the CI user guide which is given in the mysql as below: Code: CREATE TABLE IF NOT EXISTS `ci_sessions` ( And also for Captcha table that I have to convert to MSSQL query. MySQL query is: Code: CREATE TABLE captcha ( Here, I am trying to connect the codeigniter to mssql server using odbc connection. All is working fine but when problem in creating session that should be stored in database due to wrong design of ci_sessions table. Plz help[/quote] how to create ci_sessions table in ms sql server same - El Forum - 04-16-2012 [eluser]C.T.[/eluser] Try this in M$ SMS, hope it help Code: USE CI_Database P.S. I think M$SQL dont have "unsigned" datatype correct me if I am wrong |